How to do a Matrix Aggregation.

2016 5 23
1 个回答
更新时间：2016 5 27
6 次查看（30 天）

0 个投票

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.

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

回答（1 个）

Matt J
Matt J 2016-5-23

0 个投票

Once you've read your data into a 138040x7 matrix, A
aggregation =sum( reshape(A.',7,7,[]) ,3).' ;

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Amine Ben Ayara
Amine Ben Ayara 2016-5-23
编辑：Matt J 2016-5-23
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
Matt J 2016-5-23
编辑：Matt J 2016-5-23
MATLAB is saying that you read only 966273 elements into Period1, but you should have 7 more,
>> 138040*7
ans =
966280
Amine Ben Ayara
Amine Ben Ayara 2016-5-26
Please look at the screen shot that I have from my Matlab workspace. So my input matrix is
Matt J
Matt J 2016-5-27
I have looked at it. It confirms what I said. You said you have 138040 rows, but the screenshot shows only 138039.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by