Reorder Matrix Rows from the row with the most nonzero elements to the row with the least nonzero elements
Show older comments
I have a matrix with rows of values. I want to order the rows of the matrix so that the matrix with the most nonzero elements is the first row and the next most nonzero elements is the second row, and so on until the end. If two or rows are the same length it doesnt matter which one comes first. Here is the matrix, thanks in advance.
A = [0 1 2 4 7 12 17 22 27 33 42
0 0 1 3 6 11 16 21 26 34 43
0 1 2 4 7 12 17 22 28 35 44
0 0 1 2 8 13 18 23 29 36 45
0 0 1 3 9 14 19 24 30 37 46
0 1 2 5 10 15 20 25 31 38 47
0 1 3 6 11 16 21 26 32 39 48
1 2 4 7 12 17 22 27 33 40 49
0 1 2 5 10 15 20 25 31 41 50];
1 Comment
Stephen23
on 5 Jan 2021
Curious. Apparently not homework, but the same question was asked by multiple OPs at the same time:
Backup just in case:
Answers (2)
Cris LaPierre
on 5 Jan 2021
0 votes
I'm not aware of anyway to do this without having to write some code, which is probably the exact reason you were given the assignment. Look into logical indexing and sortrows.
3 Comments
Walter Roberson
on 5 Jan 2021
sortrows and logical indexing are not needed. There is a one-line solution based upon totaling the number of zeros in each row and sorting. Ascending number of zeros is descending number of non-zeros.
Cris LaPierre
on 5 Jan 2021
Sorry, I meant logical arrays, not logical indexing.
Vance Blake
on 5 Jan 2021
Edited: Vance Blake
on 5 Jan 2021
A = [...
0 1 2 4 7 12 17 22 27 33 42
0 0 1 3 6 11 16 21 26 34 43
0 1 2 4 7 12 17 22 28 35 44
0 0 1 2 8 13 18 23 29 36 45
0 0 1 3 9 14 19 24 30 37 46
0 1 2 5 10 15 20 25 31 38 47
0 1 3 6 11 16 21 26 32 39 48
1 2 4 7 12 17 22 27 33 40 49
0 1 2 5 10 15 20 25 31 41 50];
[~,X] = sort(sum(A==0,2));
B = A(X,:)
Categories
Find more on Operators and Elementary Operations in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!