Borrar filtros
Borrar filtros

Finding out mean monthly values from daily values

3 visualizaciones (últimos 30 días)
Mark Rodger
Mark Rodger el 9 de Abr. de 2018
Respondida: Akira Agata el 16 de Abr. de 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 comentarios
Dina Berenbaum
Dina Berenbaum el 9 de Abr. de 2018
Editada: Dina Berenbaum el 9 de Abr. de 2018
This should work:
for row = 1:2
mn(row) = mean((table(row,:).Variables));
end
Mark Rodger
Mark Rodger el 9 de Abr. de 2018
I've attached the mat file

Iniciar sesión para comentar.

Respuestas (1)

Akira Agata
Akira Agata el 16 de Abr. de 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');

Categorías

Más información sobre Tables en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by