/Python/Pandas groupby max multiple columns in pandas

Pandas groupby max multiple columns in pandas

Group by 2 columns pandas

In [11]: df.groupby(['col5', 'col2']).size()
Out[11]:
col5  col2
1     A       1
      D       3
2     B       2
3     A       3
      C       1
4     B       1
5     B       2
6     B       1
dtype: int64

Source: stackoverflow.com

Pandas groupby max multiple columns in pandas

annotations.groupby(['bookid','conceptid'], sort=False)['weight'].max()

Source: stackoverflow.com

Similar codes

2 votes292 views1 answer
Drop a range of rows pandas
Python
1 vote276 views1 answer
How to print alternate numbers in python
Python
6 votes291 views6 answers
Python create list
Python
10 votes306 views6 answers
How to add a value to a list in python
Python
0 vote294 views1 answer
How to create numpy array using two vectors
Python
0 vote299 views1 answer
Creating new column with dictionary
Python
0 vote267 views1 answer
How to pause a thread in python
Python
0 vote286 views1 answer
No module named 'bootstrap4' django
Python
3 votes296 views1 answer
Convert epoch to date time in python
Python
1 vote364 views2 answers
How to get user id django
Python Django