How to sort the rows of an array by the total number of zeros in the row

Question

David Gillcrist 2023-3-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1930920-how-to-sort-the-rows-of-an-array-by-the-total-number-of-zeros-in-the-row

评论： David Gillcrist 2023-3-18

I have any array where each row is a unique vector index, I want to sort the array so that column by column the numbers increase but also I want to make sure that the number of zeros in any given row does not increase from the previous row. For example, I want this:

To be

The actual order of the nonzero numbers in a section with a constain pattern in zeros column-wise doesn't matter so long as the zeros follow the pattern shown is all that matters. How could I do this, particlarly in a succinct and efficient way, but I'd like it work regardless of the size of the 2D matrix. Additionally, what would be the fastest way to break the array into those sections, i.e.

Again something that could do this regardless of the size of the matrix.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Stephen23 2023-3-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1930920-how-to-sort-the-rows-of-an-array-by-the-total-number-of-zeros-in-the-row#answer_1195675

编辑：Stephen23 2023-3-18

在 MATLAB Online 中打开

A = [1,0,0;2,0,0;3,0,0;0,1,0;1,1,0;2,1,0;0,2,0;1,2,0;0,3,0;0,0,1;1,0,1;2,0,1;0,1,1;1,1,1;0,2,1;0,0,2;1,0,2;0,1,2;0,0,3]
A = 19×3
   0     0
   0     0
   0     0
   1     0
   1     0
   1     0
   2     0
   2     0
   3     0
   0     1
[~,X] = sortrows([-sum(A==0,2),A(:,end:-1:1)]);
B = A(X,:)
B = 19×3
   0     0
   0     0
   0     0
   1     0
   2     0
   3     0
   0     1
   0     2
   0     3
   1     0

or equivalently:

[~,X] = sortrows([sum(A==0,2),A],[-1,1+size(A,2):-1:1]);
B = A(X,:)
B = 19×3
   0     0
   0     0
   0     0
   1     0
   2     0
   3     0
   0     1
   0     2
   0     3
   1     0