/Python/Dataframe groupby multiple columns

Dataframe groupby multiple columns

grouped_multiple = df.groupby(['Team', 'Pos']).agg({'Age': ['mean', 'min', 'max']})
grouped_multiple.columns = ['age_mean', 'age_min', 'age_max']
grouped_multiple = grouped_multiple.reset_index()
print(grouped_multiple)

Source: jamesrledoux.com

Pandas sum multiple columns groupby

df.groupby(['col1','col2']).agg({'col3':'sum','col4':'sum'}).reset_index()

Source: stackoverflow.com

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

Two groupby pandas

In [8]: grouped = df.groupby('A')

In [9]: grouped = df.groupby(['A', 'B'])

Source: pandas.pydata.org

Similar codes

2 votes258 views1 answer
How do i print the entire array pthon jupyter
Python
0 vote243 views1 answer
Read json file python utf8
Python
36 votes245 views4 answers
Python sum
Python
92 votes255 views6 answers
Python create virtualenv
Python
9 votes261 views2 answers
How to connecct id's in the models of jdango
Python
12 votes273 views3 answers
How to update python raspberry pi
Python
11 votes266 views2 answers
Save machine learning model
Python
0 vote210 views0 answer
Python
0 vote256 views1 answer
How to get one record in django
Python
1 vote263 views1 answer
Draw line from 2 mouse event in image python
Python