I have a monthly time series data in matrix form with 4 columns. I want to sum up always the 3 row elements of the columns. 1-3,3-6,6-9,... ,to get quaterly data. How can I do this in matlab ?

Question

Fox 2015-12-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/259726-i-have-a-monthly-time-series-data-in-matrix-form-with-4-columns-i-want-to-sum-up-always-the-3-row-e

评论： Fox 2015-12-10

sum(A(1:3)); sum(A(3:6)); sum(A(6:9)); ... % because I´ve monthly values from 1952-2013 it's impossible to solve all this in the by hand upper way. Does somebody knows, how I can create a function or something else to solve this in a faster way? %

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

请先登录，再进行评论。

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

Answer 1

dpb 2015-12-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/259726-i-have-a-monthly-time-series-data-in-matrix-form-with-4-columns-i-want-to-sum-up-always-the-3-row-e#answer_202836

在 MATLAB Online 中打开

I are complete years, then

reshape(sum(reshape(x,3,[])),numel(x)/(3*size(x,2)),[])

If lacking complete year, operate on the modulo/3 number of rows which do have and have to treat the remainder as special case.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Fox 2015-12-10

Thank you very much. Worked well.

请先登录，再进行评论。

I have a monthly time series data in matrix form with 4 columns. I want to sum up always the 3 row elements of the columns. 1-3,3-6,6-9,... ,to get quaterly data. How can I do this in matlab ?

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

采纳的回答

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

I have a monthly time series data in matrix form with 4 columns. I want to sum up always the 3 row elements of the columns. 1-3,3-6,6-9,... ,to get quaterly data. How can I do this in matlab ?

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

采纳的回答

1 个评论 显示 -1更早的评论隐藏 -1更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

WeChat

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论