/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

23 votes259 views3 answers
Pip install django rest framework
Python Django
0 vote118 views1 answer
Convert_hex_to_ASCII_3.py
Python
0 vote121 views1 answer
Subplots whitespace
Python
1 vote135 views1 answer
Update python 3.10 ubuntu
Python
41 votes124 views6 answers
Replace nan with 0 pandas
Python
3 votes180 views2 answers
Change django administration title
Python Django
3 votes129 views2 answers
Python discord webhook
Python
0 vote137 views1 answer
What is a good django orm cookbook
Python
0 vote132 views1 answer
C# dictionary values to array
Python
0 vote126 views1 answer
Find total no of true in a list in python
Python