how to select desired row

Question

FIR 2011-11-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/20349-how-to-select-desired-row

I have a 5 columns of data 
data =
col1   col2  col3    col4     col5
1      3     0.9     0.02     94
2      4      01     0.05     93
3      1      2      0.03     94
1      3       5     0.236    97
4      5     10      0.059    69 
2      10     02      0.02     89  
now i want to select the values greater that 90 which is 5th column
and want to dispaly it for ex i want to dispay as

i have totally 900 rows and 5 column of data,please help

    3     0.9     0.02     94
    4      01     0.05     93
    1      2      0.03     94
    3       5     0.236    97
next i have two onws in column 1 i want to select the one corresponging to the value in column 5 which has greater value
the output must be
    4      01     0.05     93
    1      2      0.03     94
    3       5     0.236    97

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

请先登录，再进行评论。

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

Answer 1

Sven 2011-11-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/20349-how-to-select-desired-row#answer_26863

在 MATLAB Online 中打开

A = [1      3     0.9     0.02     94
2      4      01     0.05     93
3      1      2      0.03     94
1      3       5     0.236    97
4      5     10      0.059    69 
2      10     02      0.02     89  ]
% Get only those with col5 above 90
myMask = A(:,5)>90;
B = A(myMask,:)
% Sort everything by col5, descending
sortedB = sortrows(B,-5);
% Get the index of the first unique occurence in col1
[~,uniqueIdxs] = unique(sortedB(:,1));
% Get your final output
finalResult = sortedB(uniqueIdxs,:);