How to Sort Matrix Rows from Highest to Lowest

Question

Brian 2024-7-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2141606-how-to-sort-matrix-rows-from-highest-to-lowest

评论： Stephen23 2024-7-31

Simplied my problem so it's easier to solve. Let's pretend I have MatrixA that has 2 columns, and I want to sort the rows from highest to lowest depending on the value of the cell in the second column. How would I do this?

I also have a VectorB that starts at 10 and would like to add the value of each row in column 2 of the sorted MatrixA. How would I do this? Note this needs to come after MatrixA is sorted from highest to lowest.

Any suggestions matlab wizards out there? Really want to avoid using loops to make the code inefficient.

%Just creating example of the matrix I want to sort you can ignore this
MatrixA = cell(3,2);
MatrixA{1,1} = "D1";
MatrixA{2,1} = "D2";
MatrixA{3,1} = "D3";
MatrixA{1,2} = 5;
MatrixA{2,2} = 15;
MatrixA{3,2} = 10;
% Creating Vector B based on the already defined values for MatrixA which aren't in order 
VectorA = [10 10+MatrixA{1,2} 10+MatrixA{2,2} 10+MatrixA{3,2}];
% How would I sort MatrixA from highest to lowest here and the values of VectorB to be based on the sorted MatrixA?

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

Stephen23 2024-7-31

"How would I do this?"

By using a table, which would suit your data better.

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2024-7-30

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2141606-how-to-sort-matrix-rows-from-highest-to-lowest#answer_1492591

在 MATLAB Online 中打开

MatrixA = cell(3,2);
MatrixA{1,1} = "D1";
MatrixA{2,1} = "D2";
MatrixA{3,1} = "D3";
MatrixA{1,2} = 5;
MatrixA{2,2} = 15;
MatrixA{3,2} = 10;
T = cell2table(MatrixA)
T = 3x2 table
    MatrixA1    MatrixA2
    ________    ________

      "D1"          5   
      "D2"         15   
      "D3"         10   
sortrows(T, 2, 'descend')
ans = 3x2 table
    MatrixA1    MatrixA2
    ________    ________

      "D2"         15   
      "D3"         10   
      "D1"          5   

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

请先登录，再进行评论。

Answer 2

dpb 2024-7-30

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2141606-how-to-sort-matrix-rows-from-highest-to-lowest#answer_1492601

编辑：dpb 2024-7-31

在 MATLAB Online 中打开

It's not clear about B, but

A = cell(3,2);
A(:,1)=cellstr("D"+[1:3]);
A(:,2)={5;15;10};
A=sortrows(A,2,'descend')
A = 3x2 cell array
    {'D2'}    {[15]}
    {'D3'}    {[10]}
    {'D1'}    {[ 5]}
B=10+[A{:,2}].'
B = 3x1
    25
    20
    15
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>