Answers for "pandas how to group by multiple columns adding a count"

pandas sum multiple columns groupby

df.groupby(['col1','col2']).agg({'col3':'sum','col4':'sum'}).reset_index()

Posted by: Guest on November-10-2020

pandas group by multiple columns and count

df.groupby(['col1', 'col2']).size() 
   .sort_values(ascending=False) 
   .reset_index(name='count')

Posted by: Guest on May-01-2021

Code answers related to "pandas how to group by multiple columns adding a count"