Finding out mean monthly values from daily values

2 Ansichten (letzte 30 Tage)
Mark Rodger
Mark Rodger am 9 Apr. 2018
Beantwortet: Akira Agata am 16 Apr. 2018
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
Dina Berenbaum
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
Mark Rodger am 9 Apr. 2018
I've attached the mat file

Melden Sie sich an, um zu kommentieren.

Antworten (1)

Akira Agata
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 Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by