I have 7 years of hourly data(attached file). I have them in a timetable that has (7*8760 + extra hours from leap year) number of rows.
I am trying to find the average of each hour of the years. I have been exporting the table above to excel and then splittin it column wise and averaging and coming back to matlab and working on it. I tried the groupsummary function, but it gives me 24 hours of value.
I did find a previous answer to a similar question, but that was confusing to me as well. I have attached the link to that answer.
I would appreciate if someone could help me with this.