pandas dataframe groupby datetime month

python pandas pandas-groupby datetime

Managed to do it:

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+

(update: 2018)

Note that pd.Timegrouper is depreciated and will be removed. Use instead:

 df.groupby(pd.Grouper(freq='M'))

Related

Proving that the genus of a nonsingular plane curve is $\frac{(d-1)(d-2)}{2}$
Proving Stewart's theorem without trig
CW complex structure of the projective space $\mathbb{RP}^n$
Why are these geometric problems so hard?
dual of $H^1_0$: $H^{-1}$ or $H_0^1$?
Symmetric Matrices with trace zero
In what sense is $p$-adic Hodge theory related to ordinary (complex) Hodge theory?
Prove that $\int_0^\infty\frac1{x^x}\, dx<2$
Real Analysis. Suggestions.
A closed form for the sum $\frac{a}{b}+\frac{a\cdot(a+1)}{b\cdot(b+1)}+\frac{a\cdot(a+1)\cdot(a+2)}{b\cdot(b+1)\cdot(b+2)}+\cdots$
Product of Consecutive Integers is Not a Power
Is it possible to assign a value to the sum of primes?