Groupby Every 2 Hours Data Of A Dataframe

I have a dataframe: Time T201FN1ST2010 T201FN1VT2010 1791 2017-12-26 00:00:00 854.69 0.87 1792 2017-12-26 00:20:00 855.76

Solution 1:

I think you need groupby + Grouper + some aggregate function:

df = last8.groupby(pd.Grouper(freq='2H', key='Time')).mean()

Or resample + some aggregate function:

df = last8.resample('2H', on='Time').mean()

Or use groupby + floor:

df = last8.groupby(last8.Time.dt.floor('2H')).mean()

---

print(df)T201FN1ST2010T201FN1VT2010Time2017-12-26 00:00:00     855.5516670.8666672017-12-26 02:00:00     855.8783330.8533332017-12-26 04:00:00     855.7250000.8566672017-12-26 06:00:00     854.9300000.880000