How to do a Matrix Aggregation.

I have 19720 of (7by7) matrices stacked up in excel file ( so basically a total of 138040 row). I want to aggregate these matrices into one (7by7) matrix where each row element represents the sum of all the elements in the rows from each (7by7) matrix. Any suggestions, please.

Answer 1

[Matt J]

Once you've read your data into a 138040x7 matrix, A

aggregation =sum(  reshape(A.',7,7,[])  ,3).' ;

[Amine Ben Ayara]

Hey Matt, I tried to run the code as you instructed, and I got this error message.

"aggregation =sum(  reshape(Period1.',7,7,[])  ,3).' ;
Error using reshape
Product of known dimensions, 49, not divisible into total number of elements, 966273.

[Matt J]

MATLAB is saying that you read only 966273 elements into Period1, but you should have 7 more,

    >> 138040*7

    ans =

          966280

[Amine Ben Ayara]

Please look at the screen shot that I have from my Matlab workspace. So my input matrix is

[Matt J]

I have looked at it. It confirms what I said. You said you have 138040 rows, but the screenshot shows only 138039.