How to arrange one row vector into a row x column matrix?
2 views (last 30 days)
Show older comments
Miroslav Josic
on 7 Feb 2017
Commented: Miroslav Josic
on 7 Feb 2017
Hi guys, I would appreciate your help on this problem. I have a row vector (M) of size 1x2108 which contains data for 62 countries and 34 industries for each country. So, column 1:34 is industry data for country 1, 35:68 country #2 etc. I just need to make a matrix which will be of a size 62x2108 and have data in following way: - row #1, columns 1:34 for country #1, elsewhere zeros - row #2, columns 35:68 for country #2, elsewhere zeros - row #3, columns 39:102 for country #3, elsewhere zeros etc.
So far, I used this code:
M_new=zeros(62,2108);
for i=1:62
for j=1:62
M_new(i,((j-1)*34+1):(j*34))=M(1,((j-1)*34+1):(j*34));
end
end
but I only get row vector copied 62 times in each row.
Best,
Miroslav
0 Comments
Accepted Answer
Guillaume
on 7 Feb 2017
M_new = [reshape(M, 34, 62); zeros(2108, 62)];
M_new = reshape(M_new(1:end-2108), 2108, [])'
No need for a loop.
However, I question the wisdom of using 62 times more memory to store the same information.
More Answers (1)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!