Finding out mean monthly values from daily values

2 visualizzazioni (ultimi 30 giorni)
Mark Rodger
Mark Rodger il 9 Apr 2018
Risposto: Akira Agata il 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 Commenti
Dina Berenbaum
Dina Berenbaum il 9 Apr 2018
Modificato: Dina Berenbaum il 9 Apr 2018
This should work:
for row = 1:2
mn(row) = mean((table(row,:).Variables));
end

Accedi per commentare.

Risposte (1)

Akira Agata
Akira Agata il 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');

Categorie

Scopri di più su Tables in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by