Sum specific intervals of rows for a matrix

8 次查看(过去 30 天)
Hello everybody,
I know there are some similar posts regarding the topic but I was not able to solve my problem.
I have a matrix a=53320x228 and wanted to calculate the sum in intervals of 12 for each row (f.e. sum of elements 1:12,13:24... for each row), so that my output would be a 53320x19 matrix as each row has 19*12 elements. In the past I was always able to handle similar problems with:
reshape(sum(reshape(...)))
or
sum(reshape())
But unfortunately, this time I did not recognize how it will work. Other topics related to the problem also suggest to use reshape but it doesn't produce the desired results.
Hopefully someone could help me out, I would really appreciate each hint.

采纳的回答

Aveek Podder
Aveek Podder 2018-2-23
Hi,
I believe you want to sum the 12 consecutive columns of a Matrix and convert it to one column. Doing this Matrix a of size 53320x228 results to a 53320x19 Matrix.
You need to shape the Matrix into a 53320x12x19 Matrix. Then you have to do column summation and reshape the matrix back to 5330x19 Matrix.
Please have a look at the following code:
B = reshape(a,53320,12,19);
C = sum(B,2);
out = reshape(C,53320,19);
Hope this helps.
  2 个评论
Timo
Timo 2018-2-26
编辑:Timo 2018-2-26
Thank you so much, I was not aware of this simple possibility and "trick" :)!
Great answer, thanks again!
Greetings
Maryam S
Maryam S 2019-2-28
Hi Aveek, your answer was great hlep to me , thanks!

请先登录,再进行评论。

更多回答(1 个)

Danielle Torp
Danielle Torp 2018-10-31
I have a follow up to this problem- If i wanted to calculate sums in intervals of differing lengths because each column has differing number of rows (i.e. column a = 100 rows, column b = 90 rows), but I want to reshape so each column only has 10 rows (which are sums of equal intervals per column).
  3 个评论
Timo
Timo 2018-11-1
If your Matrix is m Then try sum(reshape(m,10,[]),2) since your Matrix must be filled with NaN or 0s to Form a regular grid. But Maybe i misunderstand u :)?

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by