How to take an average over one month during different years ?

Question

Ali Saremi 2017-9-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/354921-how-to-take-an-average-over-one-month-during-different-years

评论： Kelly Kearney 2017-9-6

Hi,

I've got some data from 1979 to 2017. I want to take an average over data of month, for example, January from 1979 to 2017. Only January, not other months. PLease see attached. I have also attached my Matlab file which contains the table with date and data. If you could take a look and let me know how I can do it, I would appreciate it. Thank you.

Regards Ali

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

请先登录，再进行评论。

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

Answer 1

Kelly Kearney 2017-9-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/354921-how-to-take-an-average-over-one-month-during-different-years#answer_280034

在 MATLAB Online 中打开

A bit hard to tell from your screenshot whether your time array is an array of datetimes or an array of date strings. Assuming it's the former

% Some fake data
t = datetime(1979,1,1):datetime('today');
x = rand(size(t));
% Average data by month
for im = 1:12
    xavg(im) = mean(x(month(t)==im));
end

3 个评论
显示 1更早的评论隐藏 1更早的评论

Ali Saremi 2017-9-2

Dear kelly,

I have also attached my MATLAB file. If you could take a look at this, would be great. Thank you.

Kind Regards Ali

Kelly Kearney 2017-9-6

I don't see any attached mat file. If you post the exact code you attempted, and any error messages, that will be much more useful than screenshots to diagnose the problem.

In particular, is the Time column in your table composed of datetimes or date strings?

请先登录，再进行评论。