Finding out mean monthly values from daily values
Ältere Kommentare anzeigen
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 Kommentare
Birdman
am 9 Apr. 2018
Can you share your table in a mat file?
Dina Berenbaum
am 9 Apr. 2018
Bearbeitet: Dina Berenbaum
am 9 Apr. 2018
This should work:
for row = 1:2
mn(row) = mean((table(row,:).Variables));
end
Mark Rodger
am 9 Apr. 2018
Antworten (1)
Akira Agata
am 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');
Kategorien
Mehr zu Tables finden Sie in Hilfe-Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!