Sum specific intervals of rows for a matrix

Timo (view profile)

on 20 Feb 2018
Latest activity Commented on by Maryam S

Maryam S (view profile)

on 28 Feb 2019
Accepted Answer by Aveek Podder

Aveek Podder (view profile)

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.

Tags

Answer by Aveek Podder

Aveek Podder (view profile)

on 23 Feb 2018

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.

Timo

Timo (view profile)

on 26 Feb 2018
Thank you so much, I was not aware of this simple possibility and "trick" :)!
Great answer, thanks again!
Greetings
Maryam S

Maryam S (view profile)

on 28 Feb 2019
Hi Aveek, your answer was great hlep to me , thanks!

Answer by Danielle Torp

Danielle Torp (view profile)

on 31 Oct 2018

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).

Timo

Timo (view profile)

on 31 Oct 2018
Hey, So if its an irregular array i guess the Rest of each column should have nan values or 0's, right?
Danielle Torp

Danielle Torp (view profile)

on 1 Nov 2018
Yes, the rest of the column would be blank.
Timo

Timo (view profile)

on 1 Nov 2018
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 :)?