I am aware that pandas resample function has **hourly ** rule. However, it returns the average for every hour for the whole dataset.

When using that method (df.Value.resample('H').mean()), I get the following output:

However, I would like hourly resample of data which shows the average values throughout the year for the whole dataset (not everyday hourly).

What I want:

Thanks in advance.

CodePudding user response：

groupby can give you the result you want. Can you try this?

dfx=df.groupby(df['date_column'].dt.hour).mean()