Finding out mean monthly values from daily values
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
Birdman
on 9 Apr 2018
Can you share your table in a mat file?
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
Mark Rodger
on 9 Apr 2018
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');
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!