How to get monthly average

2018 10 15

1 个回答

2 次查看（30 天）

0 个投票

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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

dpb 2018-10-15

0 个投票

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.

b.m.n n 2018-10-16

thank you dpb this file looks like the pic

dpb 2018-10-16

So did you try it? Looks like it would work "out of the box".

在帮助中心和 File Exchange 中查找有关 Downloads 的更多信息

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

Translated by