How to reshape rows into columns

2011 9 1
2 个回答
回答已采纳
31 次查看（30 天）

0 个投票

How can I change the following matrix:
[1, 5,0,0; 2,4,0,0; 3, 2,6,4]
to look like:
[1,5; 2, 4; 3,2; 3,6; 3,4]?
Any suggestion would be great. Thanks

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

 采纳的回答

Andrei Bobrov
Andrei Bobrov 2011-9-1

0 个投票

A =[1, 5,0,0; 2,4,0,0; 3, 2,6,4]
[i1 j1] = find(A(:,2:end))
sz = size(A)
out = sortrows([A(i1,1) A(sz(1)+sub2ind(sz- [0 1],i1,j1))],1)
more
[i2 j2 c] = find(A)
t = j2~=1
out = sortrows([A(i2(t),1) c(t)],1)
variant 3
AA = A(:,2:end)
[i1,~] = find(AA)
out = sortrows([A(i1,1) reshape(AA(AA~=0),[],1)],1)

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Amandeep
Amandeep 2011-9-1
Thanks for your quick response.
But waht if instead:
A = [1,5,0,0;3,4,0,0;5,2,6,4]
Andrei Bobrov
Andrei Bobrov 2011-9-1
>> A = [1,5,0,0;3,4,0,0;5,2,6,4];
[i2 j2 c] = find(A);
t = j2~=1;
out = [A(i2(t),1) c(t)]
out =
1 5
3 4
5 2
5 6
5 4
Amandeep
Amandeep 2011-9-1
I think I nearly figured it out
A = [1,5,0,0;3,4,0,0;5,2,6,4]
AA = permute(A(:,2:end),[2,1])
AA = reshape(AA,numel(A(:,2:end)),1)
zero = (AA==0)
AA(zero) = []
Now just trying to create the first column

请先登录，再进行评论。

更多回答（1 个）

0 个投票

Hi, There is a command named reshape. Check with it.
Regards, Sivakumaran vlsiva@yahoo.co.in

2 个评论
显示 无 隐藏 无

Amandeep
Amandeep 2011-9-1
How do I use reshape on the third row?
Oleg Komarov
Oleg Komarov 2011-9-1
@Siva: if I were you I wouldn't leave my mail on a forum.

请先登录，再进行评论。

类别

在 帮助中心 和 File 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