/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 vote105 views1 answer
Python setup install_requires local whl
Python
3 votes100 views1 answer
Pandas reciprocal
Python
8 votes99 views6 answers
Python int to binary
Python
52 votes107 views2 answers
What is index in list in python
Python
0 vote98 views1 answer
Como tornar uma string numa lista
Python
1 vote100 views2 answers
Python list equality
Python
1 vote86 views1 answer
Flask run app reset on change
Python Flask
-1 vote106 views1 answer
Python date from yy/mm/dd to yy-mm-dd
Python
0 vote104 views1 answer
Python find HCF
Python
0 vote117 views1 answer
Nltk stop words
Python