cumsum function for seperate time

Question

davit petraasya 2016-6-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/291682-cumsum-function-for-seperate-time

回答： Are Mjaavatten 2016-8-13

Hi

I have 2 data colomn. 1-colomn time in a form(01/01/1975, 05/01/1975, 25/01/1975, 05/02/1975,...., 22/11/2015), second colomn constant values corresponding to the time(75, 25, 30, 70,..., 55). I wanted to calculate monthly cumulative sum values.Such as for 1-month sum value should appear as 130(75+25+30). And sequences continue...

How I may do it?

Thanks!

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

请先登录，再进行评论。

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

Answer 1

Are Mjaavatten 2016-8-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/291682-cumsum-function-for-seperate-time#answer_231634

在 MATLAB Online 中打开

Interesting problem. Here is one possible solution:

 dates = {'01/01/1975'; '05/01/1975'; '25/01/1975'; '05/02/1975';...
     '15/02/1975';'12/03/1975';'17/02/1978'};
 data = [75;25;30;70;32;24;49];
 time = datenum(dates,'dd/mm/yyyy');  % Convert strings to Matlab dates
 [Y,M] = datevec(time);               % Extract year and month vectors
 mnthno = Y*12+M;                     % Unique value for every month
 [C,ia] = unique(mnthno);             % List of unique months
 sums = zeros(size(C));               % Allocate space for the sums 
 for i = 1:length(C)
     sums(i) = sum(data(mnthno==C(i)));  % Sum data for each month
     % Display results:
     fprintf('Year: %4d, Month = %2d, sum = %6.2f \n',...
         Y(ia(i)),M(ia(i)), sums(i));
 end