How do I change these daily time series data to monthly?

7 次查看（过去 30 天）
Abubakar Sani-Mohammed
评论： Abubakar Sani-Mohammed 2019-1-28
Hello, I have a daily time series data in an array of 81(rows) by 4748 (columns), the 81 rows represents the points at which the data (in their respective corresponding column) was measured (daily). Then I have another arrey of the Time, which is 4748 by 1 (a column matrix) consisting the dates, from January 1, 2005. I need guidance on how to turn these daily time series into monthly. Thank you.

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

采纳的回答

Walter Roberson
Walter Roberson 2019-1-22
Convert to timetable() objects and use retime()
  11 个评论
显示 9更早的评论
Walter Roberson
Walter Roberson 2019-1-27
dv = datevec(datenum('2005/01/01 12:00'):datenum('2017/12/31 12:00'));
monthnum = dv(:,1)*12 + dv(:,2);
relmonth = monthnum - monthnum(1) + 1;
nummonth = relmonth(end);
numpoints = size(duVq_hydl,1);
summarized = zeros(numpoints, nummonth);
for pointnum = 1 : numpoints
summarized(pointnum, :) = accumarray( relmonth, duVq_hydl(pointnum, :).', [], @mean );
end
summary_dates = datenum(2005, 1:nummonth, 1);
This is 156 months, not 157 months.
You were not clear as to what date format you wanted the summary dates to be, so I used serial date numbers.
Abubakar Sani-Mohammed
Abubakar Sani-Mohammed 2019-1-28
Thank you very much, I will work around it. I really appreciate your time and effort.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Calendar 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by