How to sum pandas dataframe by specific column without changing other columns?

Asked Apr 15 '21 at 16:18

Active Apr 15 '21 at 16:20

Viewed 20 times

I have a dataframe like this one

ddf = pd.DataFrame({
    'A': ['a', 'a', 'c', 'c'],
    'B': ['b', 'b', 'd', 'd'],
    'C': [1, 2, 3, 4]
})

ddf


    A   B   C
0   a   b   1
1   a   b   2
2   c   d   3
3   c   d   4

And i would like to have the following result by summing through column C:

    A   B   C
0   a   b   3
1   c   d   7

How to do that in pandas ?

asked Apr 15 '21 at 16:18

moctarjallo

1,479
1
16
33

Is there groupby functionality in pandas? – whytheq Apr 15 '21 at 16:20
`ddf.groupby(['A','B'],as_index=False)['C'].sum()` – anky Apr 15 '21 at 16:20
You can also use: `ddf.groupby(['A','B'],as_index=False).agg({'C':'sum'})` – Anurag Dabas Apr 15 '21 at 16:30

How to sum pandas dataframe by specific column without changing other columns?

0 Answers0