Group by date range in pandas dataframe

Question

I have a time series data in pandas, and I would like to group by a certain time window in each year and calculate its min and max.

For example:

times = pd.date_range(start = '1/1/2011', end = '1/1/2016', freq = 'D')
df = pd.DataFrame(np.random.rand(len(times)), index=times, columns=["value"])

How to group by time window e.g. 'Jan-10':'Mar-21' for each year and calculate its min and max for column value?

Answer 1

You can use the resample method.

df.resample('5d').agg(['min','max'])