/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 vote221 views1 answer
Python get last cell value
Python
2 votes179 views3 answers
Str to datetime time
Python
-1 vote152 views1 answer
Image analysis python
Python
96 votes223 views6 answers
Read json file
Python
0 vote205 views1 answer
Python datetime add one week
Python
4 votes199 views2 answers
Count characters in string python
Python
0 vote183 views1 answer
Adding numbers with numbers. python
Python
0 vote186 views1 answer
Tk inter entry
Python
1 vote197 views1 answer
How to add a fuction in python
Python
1 vote174 views1 answer
Python set and dictionary comprehensions
Python