Finding out mean monthly values from daily values
3 views (last 30 days)
Show older comments
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
Dina Berenbaum
on 9 Apr 2018
Edited: Dina Berenbaum
on 9 Apr 2018
This should work:
for row = 1:2
mn(row) = mean((table(row,:).Variables));
end
Answers (1)
Akira Agata
on 16 Apr 2018
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');
0 Comments
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!