accessing Groupby Sum results

Asked May 02 '18 at 14:53

Active May 02 '18 at 14:53

Viewed 33 times

I'm trying to do a groupby/ sum to a dataframe,

this is my code:

stage1.groupby(['Year']).sum().max())

it is giving me the value of the maximum sum which is great but I would like to know how to get the year value as well.

Any help would be much appreciated.

also any idea why I can't access the values of a groupby/sum to plot it: years= table['Year'].values values=table['Value'].values

asked May 02 '18 at 14:53

Mazen Sleiman

Do you need `table = stage1.groupby(['Year']).sum().reset_index()` ? – jezrael May 02 '18 at 14:55
1

@jezrael. That was exactly what I needed. thank you so much – Mazen Sleiman May 02 '18 at 16:53

0 Answers0