Changing matrix column order
91 views (last 30 days)
Show older comments
Penny Ibil
on 18 May 2020
Commented: Walter Roberson
on 18 May 2020
An having difficulty expressing the result I would like, but it is shown in the example below. How can I change the order of matrix A's columns so that they are like matrix B, regardless of the data values.
A =
1 2 3 11 22 33 111 222 333
1 2 3 11 22 33 111 222 333
1 2 3 11 22 33 111 222 333
1 2 3 11 22 33 111 222 333
B =
1 11 111 2 22 222 3 33 333
1 11 111 2 22 222 3 33 333
1 11 111 2 22 222 3 33 333
0 Comments
Accepted Answer
Walter Roberson
on 18 May 2020
reshape(permute(reshape(A,size(A,1),3,[]),[1 3 2]),size(A,1),[])
3 Comments
Walter Roberson
on 18 May 2020
permute(X, [1 3 2]) means that dimension 1 should stay the same, and what was dimension 3 should become the new dimension 2, and that what was dimension 2 should become the new third dimension.
permute() is a generalization of transpose(). It moves elements around.
for I = 1 : size(A, 1)
for J = 1 : size(A,2)
for K = 1 : size(A,3);
output(I, K, J) = A(I, J, K);
end
end
end
More Answers (1)
Ameer Hamza
on 18 May 2020
Edited: Ameer Hamza
on 18 May 2020
For this particular example
A = ...
[1 2 3 11 22 33 111 222 333
1 2 3 11 22 33 111 222 333
1 2 3 11 22 33 111 222 333
1 2 3 11 22 33 111 222 333];
idx = [1 4 7 2 5 8 3 6 9];
B = A(:, idx);
Result
>> B
B =
1 11 111 2 22 222 3 33 333
1 11 111 2 22 222 3 33 333
1 11 111 2 22 222 3 33 333
1 11 111 2 22 222 3 33 333
Is there a general rule that can be expressed mathematically?
2 Comments
Ameer Hamza
on 18 May 2020
Do you want to move all columns start with 1 to the left in increasing order, then columns of 2, then 3, so on. Something like this?
See Also
Categories
Find more on Logical in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!