Monday, 26 August 2013

Plot groupby data by month

Plot groupby data by month

I'm trying to plot grouped by month DataFrame, where index column is
DateTime.
My goal is to plot all months on separate plots.
index=date_range('2011-9-1 00:00:03', '2012-09-01 00:00:03', freq='10min')
df=pd.DataFrame(np.random.rand(len(index),3),index=index)
df2 = df.groupby(lambda x: x.month)
df2.plot()
This gives me 14 plots (not 12), where 2 first are empty - on the x-axis
are years from 2000 to 2010. Than two first plots are January.
Hoping for your good advice how to cope with this.

No comments:

Post a Comment