How to group together rows of Pandas Dataframe with same values in first 2 columns by summing values in the 3rd column?

user_7175177 0
Viewed 8748

I have a dataframe of the form:

enter image description here

For same values of col1 and col2 (for example, A B), I want to add all values in the col3 of the dataframe such that only one row of that form (A B) remains and all values in col3 correspond to those are added.

The result would look like:

enter image description here

I tried:

df.groupby(['col1', 'col2'], axis=0, as_index=True).sum()

but it gave me:

enter image description here

which is not exactly what I am looking for. Please help and advise. Thanks in advance.

pandas-groupby pandas dataframe python-3.x python
1 Answers

You just need to do this, False instead of True:

df.groupby(['col1', 'col2'], axis=0, as_index=False).sum()
user_61683230
Related