Finding out mean monthly values from daily values

2 vues (au cours des 30 derniers jours)
Mark Rodger
Mark Rodger le 9 Avr 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 commentaires
Dina Berenbaum
Dina Berenbaum le 9 Avr 2018
Modifié(e) : Dina Berenbaum le 9 Avr 2018
This should work:
for row = 1:2
mn(row) = mean((table(row,:).Variables));
end
Mark Rodger
Mark Rodger le 9 Avr 2018
I've attached the mat file

Connectez-vous pour commenter.

Réponses (1)

Akira Agata
Akira Agata le 16 Avr 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');

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by