CODE EXAMPLE FOR PYTHON

group by weekhour

df.groupby((df.index.dayofweek) * 24 + (df.index.hour)).mean().rename_axis('HourOfWeek')