/Python/Pandas sum multiple columns groupby

Pandas sum multiple columns groupby

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

Source: stackoverflow.com

Pandas sum multiple columns groupby

#UPDATED (June 2020): Introduced in Pandas 0.25.0, 
#Pandas has added new groupby behavior “named aggregation” and tuples, 
#for naming the output columns when applying multiple aggregation functions 
#to specific columns.

df.groupby(
     ['col1','col2']
 ).agg(
     sum_col3 = ('col3','sum'),
     sum_col4     = ('col4','sum'),
 ).reset_index()

Source: stackoverflow.com

Similar codes

17 votes184 views6 answers
Remove list from list python
Python
6 votes248 views1 answer
Pandas change date format to yyyy-mm-dd
Python
0 vote209 views1 answer
What if init migrations run two times or by pass this migrate
Python
0 vote212 views1 answer
How to close a webpage using selenium driver python
Python
1 vote270 views1 answer
Updating many to many field in django using pk
Python Django
0 vote214 views2 answers
Python 5 minimal values from array
Python
2 votes249 views1 answer
What does * mean in python in functions
Python
0 vote220 views1 answer
Django python base 64 decode
Python
1 vote252 views1 answer
Squared sum of all elements in list python
Python
0 vote207 views1 answer
Python drop the first word
Python