/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 vote156 views1 answer
Api view wrapper django
Python Django
0 vote124 views1 answer
How to repeat a python file
Python
10 votes106 views3 answers
Python reduce
Python
0 vote138 views1 answer
Error warning tkinter
Python
23 votes119 views1 answer
Python year month from date
Python
0 vote107 views1 answer
Python get response headers
Python
7 votes120 views3 answers
Update django
Python
1 vote136 views1 answer
Remove all pyc files
Python
16 votes130 views6 answers
Map in python
Python
219 votes320 views6 answers
Random number python
Python