/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

2 votes142 views1 answer
Python sort multiple lists based on sorting of single list
Python
3 votes206 views1 answer
Import "decouple" could not be resolved Pylance
Python
0 vote135 views1 answer
Print all objects in list python
Python
1 vote327 views1 answer
Replace space with . pyhton
Python
25 votes138 views5 answers
Pandas show all dataframe
Python
0 vote156 views1 answer
While my_input != "exit":
Python
1 vote169 views4 answers
Flask activ environment
Python Flask
1 vote171 views1 answer
For loop in django
Python Django
0 vote126 views2 answers
Error: Could not locate a Flask application. You did not provide the "FLASK_APP" environment variable, and a "wsgi.py" or "app.py" module was not found in the current directory.
Python
0 vote130 views1 answer
How to open cmd at specific size using python
Python