Sum of columns with certain window

Question

Miroslav Josic 2017-1-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/322543-sum-of-columns-with-certain-window

评论： Miroslav Josic 2017-1-30

Hi guys

I need your help with summing columns based on certain window as I could not find a solution already discussed. I have a matrix of size 2,159x372 where in every 6 columns I have specific industry data for one country (total of 62 countries). So, I would like to sum columns 1-6, 7-12, 13-19 etc in order to get only country data in columns. It means I would have in the end a matrix of size 2,159x62.

I guess I have to use for loop but I am just not clear how to set the window.

Miroslav

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

请先登录，再进行评论。

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

Answer 1

Jan 2017-1-30

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/322543-sum-of-columns-with-certain-window#answer_252607

编辑：Jan 2017-1-30

在 MATLAB Online 中打开

Data   = rand(2159, 372);
Data   = reshape(Data, 2159, 6, 62);
Result = reshape(sum(Data, 2), 2159, 62);

This splits the 2nd dimension after all 6 elements shifting the rest to the 3rd dimension. After calculating the sum, the inserted dimension is removed again. squeeze(sum(Data, 2)) would be an option also.