#calculate sum of sales grouped by month df.groupby(df.date.dt.month)['sales'].sum() date 1 34 2 44 3 31 Name: sales, dtype: int64