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 Kommentare

Birdman
Birdman am 9 Apr. 2018
Can you share your table in a mat file?
This should work:
for row = 1:2
mn(row) = mean((table(row,:).Variables));
end
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

Tags

Gefragt:

am 9 Apr. 2018

Beantwortet:

am 16 Apr. 2018

Community Treasure Hunt

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

Start Hunting!

Translated by