/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 vote161 views1 answer
Sort rows by values dataframe
Python
44 votes153 views2 answers
Cm to foot
Python
0 vote152 views1 answer
Python plot axis labels
Python
-1 vote143 views2 answers
Dd-mm-yy to yyyy-mm-dd in python
Python
90 votes164 views6 answers
Python get current directory
Python
6 votes160 views2 answers
How many nan in array python
Python
18 votes162 views6 answers
Strptime
Python
1 vote155 views1 answer
How to change a thread name in python
Python
-2 votes148 views1 answer
Python telegram bot get user name
Python
8 votes151 views2 answers
If else elif python
Python