Finding out mean monthly values from daily values

I have a 7536x2 table that shows values for each hour of the day starting over February-Decemeber. I would like to find the mean value of each month. Any thoughts?

3 Comments

Can you share your table in a mat file?
This should work:
for row = 1:2
mn(row) = mean((table(row,:).Variables));
end
I've attached the mat file

Sign in to comment.

Answers (1)

By converting your table to timetable and using retime function, you can do it easily, like:
load('hourly_wind_speeds.mat');
TT = table2timetable(y1);
MonthlyMean = retime(TT,'monthly','mean');

Categories

Tags

Asked:

on 9 Apr 2018

Answered:

on 16 Apr 2018

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!