calculate monthly averages of time series

1 次查看（过去 30 天）
Richard
Richard 2012-7-5
评论： Benju Baniya 2022-7-12
I have a dataset which contains measurements taken at discrete intervals for the past ~ 40 years. I would like to calculate the monthly mean values from the measurements. Consider the following example:
DateTime=datestr(datenum('1970-01-01','yyyy-mm-dd'):1:...
datenum('2011-12-31','yyyy-mm-dd'),...
'yyyy-mm-dd');
DateTime=cellstr(DateTime);
DateVec = datevec(DateTime);
dt = [1,4,32,232,101,44,23,1,87,843,456];
DateVec(dt,:) = [];
Data = rand(1,length(DateVec(:,1)));
Here, I have excluded some of the Dates in order to specify that the intervals of measurements were not continuous, obviously the measurements are far more spread out than shown above. So, what I would like to do is to use the date vector to specify each year and then calculate the mean of each month for a given year so that at the end I would have 12 measurements for each year.

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2012-7-5
编辑：Andrei Bobrov 2012-7-5
[a,b,b] = unique(DateVec(:,1:2),'rows');
out = [a,accumarray(b,Data,[],@mean)]; %EDIT row
or
[a1,b1,b1] = unique(DateVec(:,1));
[a2,b2,b2] = unique(DateVec(:,2));
out = [nan,a2';a1,accumarray([b1,b2],Data,[],@mean)]; % EDIT row
  3 个评论
显示 1更早的评论
Andrei Bobrov
Andrei Bobrov 2012-7-5
Sorry! I edited my answer. Please read about MATLAB's function accumarray.
Benju Baniya
Benju Baniya 2022-7-12
Hi, i am new to matlab and trying to work with timeseries data. What does a, b, b mean here? My data looks like as shown below. How do I calculate GPP based on month so that I get 12 values for each year? Thanks in advance.
YEAR TIMESTAMP DoY NEE GPP
2013 201301010030 1 -0.0064 0.0025
2013 201301010100 2 - 0.0076 0.0026
2014 201401010030 1 0.0983 -0.0076
2014 201301010100 2 0.0075 - 0.0089

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by