I have time series data of 1 year each day 2880 values row wise so a matrix of 365X2880. I want to do monthly average. January 31 days average one file of one month, so that I can finally get 12 files each of monthly average.

Question

Mohammed Yousuf 2019-9-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/480025-i-have-time-series-data-of-1-year-each-day-2880-values-row-wise-so-a-matrix-of-365x2880-i-want-to-d

编辑： Andrei Bobrov 2019-9-12

I have time series data of 1 year each day 2880 values row wise so a matrix of 365X2880.

I want to do monthly average. January 31 days average one file of one month, so that I can finally get 12 files each of monthly average.

I think should be considered, days in each month are not same. I have 2015 data so it is not a leap year, Therefore february contain 28 days.

Plese help me to come out of it

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

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2019-9-12

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/480025-i-have-time-series-data-of-1-year-each-day-2880-values-row-wise-so-a-matrix-of-365x2880-i-want-to-d#answer_391510

在 MATLAB Online 中打开

A - you're array 365 x 2880, in example per 2015 year.

t = (datetime(2015,1,1):datetime(2015,12,31))';
TT = array2timetable(A,'RowTimes',t);
T_out = retime(TT,'monthly','mean');

2 个评论
显示无隐藏无

Mohammed Yousuf 2019-9-12

datetime function is not available in my Matlab version .

I am using Matlab 2014a

Andrei Bobrov 2019-9-12

编辑：Andrei Bobrov 2019-9-12

在 MATLAB Online 中打开

Well then for old MATLAB:

t = (datenum(2015,1,1):datenum(2015,12,31))';
[y,m] = datevec(t);
[a,~,c] = unique([y,m],'rows');
[ii,jj] = ndgrid(c,1:size(A,2));
out = [a, accumarray([ii(:),jj(:)],A(:),[],@mean)];

or with tables:

t = (datenum(2015,1,1):datenum(2015,12,31))';
[y,m] = datevec(t);
T = array2table([y,m,A]);
T.Properties.VariableNames = [{'Year','Month'},sprintfc('Data%d',1:size(A,2))];
T_out = varfun(@mean,T,'GroupingVariables',{'Year','Month'},'InputVariables',T.Properties.VariableNames(3:end));