Select rows by minimum values of a column considering unique values of another column

Question

Sara Alonso Vicario 2021-4-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/799617-select-rows-by-minimum-values-of-a-column-considering-unique-values-of-another-column

编辑： Matt J 2021-4-12

I want to select only the rows for each unique name of a column (first column) that have a minimum value in another column (sixth column). This is my data in matlab.

I want to select a row for each unique name_file that has its minimum value in Z_value_Secondcriterion.

Any idea about how to do it Matlab?

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

请先登录，再进行评论。

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

Answer 1

Matt J 2021-4-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/799617-select-rows-by-minimum-values-of-a-column-considering-unique-values-of-another-column#answer_673161

编辑：Matt J 2021-4-12

在 MATLAB Online 中打开

A=Results{:,1};
B=str2double(Results{:,6});
C=(1:numel(B)).';
G=findgroups(A);
sel=splitapply(@(b,c) c(find(b==min(b),1)), B,C, G);
Selection=Results(sel,:)