Finding out mean monthly values from daily values
Afficher commentaires plus anciens
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
Birdman
le 9 Avr 2018
Can you share your table in a mat file?
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
le 9 Avr 2018
Réponses (1)
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 Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!