groupby date month year pandas code example

Example 1: pandas group by month

b = pd.read_csv('b.dat')
b.index = pd.to_datetime(b['date'],format='%m/%d/%y %I:%M%p')
b.groupby(by=[b.index.month, b.index.year])
# or
b.groupby(pd.Grouper(freq='M'))  # update for v0.21+
# or
df.groupby(pd.TimeGrouper(freq='M'))

Example 2: groupby year datetime pandas

data.groupby(data.date.dt.year)