How to get monthly average

2 visualizaciones (últimos 30 días)
b.m.n n
b.m.n n el 15 de Oct. de 2018
Comentada: dpb el 16 de Oct. de 2018
I have data (47 * 1)for 26 months starting in 2015 ending in 2107 as the Xlsx file
Some months it has 3 values and some are 2 or1
I want to get average values for each month as new-data(26*1).
Any suggestion, to help me?

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

dpb
dpb el 15 de Oct. de 2018
t=readtable('month.xlsx');
t=table2timetable(t);
mn=retime(t.Var1,'monthly',@mean);
I didn't download the file so if there are variable names for Var1 use whatever the variable is.
  2 comentarios
b.m.n n
b.m.n n el 16 de Oct. de 2018
thank you dpb this file looks like the pic
dpb
dpb el 16 de Oct. de 2018
So did you try it? Looks like it would work "out of the box".

Iniciar sesión para comentar.

Categorías

Más información sobre Spreadsheets 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