How to get yearly sum values

2 次查看（过去 30 天）

davit petraasya 2016-5-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/285093-how-to-get-yearly-sum-values

评论： Ice lady 2016-8-21

I Have time variables, such as [01/04/1960(dd/mm/yyyy),23/09/1960, 08/01/1980, 18/11/1980] and corresponding magnitude values[5, 4.2, 6, 7]. I need yearly sum values of magnitudes. So for the year 1960 I am supposed to get 9.2, and for 1980 the value 13.(Actually my table is much bigger, I just gave 2 years values to know the way how to do it).

So how I can get yearly sum values?

Thank a lot!

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

请先登录，再进行评论。

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

采纳的回答

Azzi Abdelmalek 2016-5-20

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/285093-how-to-get-yearly-sum-values#answer_222843

在 MATLAB Online 中打开

d={'01/04/1960';'23/09/1960';'08/01/1980';'18/11/1980'}
v=[5; 4.2; 6;7]
a=datevec(d,'dd/mm/yyyy')
[y,~,kk]=unique(a(:,1))
out=[y accumarray(kk,v)]

7 个评论
显示 5更早的评论隐藏 5更早的评论

davit petraasya 2016-5-20

Thank you Azzi for answering to this question also. You are very helpful.

Ice lady 2016-8-21

Dear Azzi,

I have a similar problem to davit and tried to re-write the above to work for me, but failed. My date data is in form YYYY = A(:,1), mm = A(:,2) and dd = A(:,3). My daily data has variable number of entries and is in column A(:,5). I also need to compute annual data totals.

Any suggestions would be greatly appreciated.

Thanks in advance

请先登录，再进行评论。