清空筛选条件
清空筛选条件

How to get monthly average

1 次查看（过去 30 天）
b.m.n n
b.m.n n 2018-10-15
评论： dpb 2018-10-16
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?

请先登录，再回答此问题。

回答（1 个）

dpb
dpb 2018-10-15
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 个评论
b.m.n n
b.m.n n 2018-10-16
thank you dpb this file looks like the pic
dpb
dpb 2018-10-16
So did you try it? Looks like it would work "out of the box".

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Get Started with MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by