Python Pandas: Group datetime column into hour and minute aggregations

Question

This seems like it would be fairly straight forward but after nearly an entire day I have not found the solution. I've loaded my dataframe with read_csv and easily parsed, combined and indexed a date and a time column into one column but now I want to be able to just reshape and perform calculations based on hour and minute groupings similar to what you can do in excel pivot.

I know how to resample to hour or minute but it maintains the date portion associated with each hour/minute whereas I want to aggregate the data set ONLY to hour and minute similar to grouping in excel pivots and selecting "hour" and "minute" but not selecting anything else.

Any help would be greatly appreciated.

Answer 1

Use these below line of code where df is your DataFrame:

times = pd.to_datetime(df.timestamp_col)

df.groupby([times.hour, times.minute]).value_col.sum()

If You want to learn data science with python visit this data science online course by intellipaat.