python pandas dataframe aggregate groupby

Question

I have pandas DataFrame with many rows and columns, only three rows shown here:

date    place    number
2010    LON      10
2010    BER      20
2010    LON      5
2011    LON      10
2011    BER      15
2011    BER      10

I want to make a new dataframe which aggregates by year and sums up the number according to place:

date   place    number
2010   LON      15
2010   BER      20
2011   LON      10
2011   BER      25

I have tried many combinations of groupby with sum, inplace etc. But I cannot achieve this, any suggestions?

milos.ai · Accepted Answer · 2016-11-03 20:46:17Z

4

You can try:

df.groupby(['date','place']).agg(sum)

Or If you want to get exactely the data frame as in your example:

df.groupby(['date','place']).agg(sum).reset_index()

answered Nov 3, 2016 at 20:46

milos.ai

3,9287 gold badges34 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1