Grouping Odd And Even Days

I have a pandas dataframe as the following data Out[8]: value1 Date 2015-03-31 09:53:

Solution 1:

Try this:

In [7]: df2 = data.groupby(data.index.day % 2).agg(np.mean)

In [8]: df2
Out[8]:
      value1
Date
01.66511.600

Explanation:

In[9]: data.index.dayOut[9]: Int64Index([31, 31, 31, 31, 1, 1, 1, 2, 2, 2, 3, 3, 4, 5, 5, 5], dtype='int64', name='Date')

In[10]: data.index.day % 2Out[10]: Int64Index([1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 1, 1, 0, 1, 1, 1], dtype='int64', name='Date')