Analyse historical data: average of every hour of every day over a number of years
I have historical data from 2012 to 2023. I am trying to calculate the average for every hour in every day over these years to build a ‘reference year’ or ‘baseline’. My DataFrame (final_df) looks like this: