Finding out mean monthly values from daily values

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
Birdman le 9 Avr 2018
Can you share your table in a mat file?
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
I've attached the mat file

Connectez-vous pour commenter.

Réponses (1)

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

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by