/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

0 vote265 views2 answers
Python2 to python3 converter
Python
3 votes283 views2 answers
How to make a grid in python
Python
4 votes238 views1 answer
Telegram bot send file
Python
5 votes269 views1 answer
Englsih to japanese
Python
0 vote308 views1 answer
How to get wikipedia photos using wikipedia module ip python
Python
0 vote275 views1 answer
Freqtrade - Informative Pairs
Python
0 vote260 views1 answer
Django fixtures. To loaddata
Python
15 votes281 views2 answers
How to run a python script
Python
0 vote307 views1 answer
Server error 500 heroku django
Python
6 votes264 views2 answers
Python min in dictionary
Python