Group Datetime in panda into three hourly intervals

Question

I want to modify this SO topic here to three hourly interval. I have a database of events at minute resolution. I need to group them in three hourly, and extract the count of this grouping.

The output would ideally look something like a table like the following:

3hourly    count
0          10
3          3
6          5
9          2
...

Answer 1

You haven't provided much detail, but you can use the 'TimeGrouper':

df.groupby(pd.TimeGrouper(key='your_time_column', freq='3H')).count()

The key parameter is optional if your time is the index.