Sort column based on value in another column (sort rows by column values a>b>c)

Question

Nathan Garcia 2021-3-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/769992-sort-column-based-on-value-in-another-column-sort-rows-by-column-values-a-b-c

评论： Nathan Garcia 2021-4-1

I am using the function [E,index] = sortrows(A,'descend');

This sorts the first column by row value and also secondarily sorts the second column. I would then like to specify how the sort works based on relative values in a third column. For example, I am only interested in rows where column A value > column B value > column C value. I am interested in the index that identifies the rows that fit this definition. How can I set this up?

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

请先登录，再进行评论。

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

Answer 1

Pranav Verma 2021-3-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/769992-sort-column-based-on-value-in-another-column-sort-rows-by-column-values-a-b-c#answer_648497

编辑：Pranav Verma 2021-3-16

在 MATLAB Online 中打开

Hi Nathan,

From the question I understand that after performing the usual sorting operation on the table, you want the rows which follow the definition of "value of column A > column B > column C".

You can start by sorting the rows in whichever order you want them to be sorted (ascending / descending). After that you can use the find function in MATLAB and get the row numbers which follow the definition provided.

For eg;,

% a =  3     2     1
%      2     3     4
%      5     4     3
%      1     2     3
a = [3 2 1 ; 2 3 4 ; 5 4 3 ; 1 2 3];
% value of column A > column B > column C
b = find(a(:,1) > a(:,2) & a(:,2) > a(:,3));
% b =
%     1
%     3