how to sum values of third column where col1 col2 have duplicates in pandas

Shahjahan 0
Viewed 22

Below The image is a demo dataset

enter image description here

The Desired Result is like this, what pandas functions should I use here enter image description here

Please Read the headings in Image 2 to get a better understanding of my question

group-by dataframe pandas python
1 Answers

Use groupby with aggregation

df.groupby(['col1', 'col2']).agg({'col3': ['count', 'sum']})
Vishnudev0
Related