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

2 次查看（过去 30 天）
Sara Alonso Vicario
编辑： 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?

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

采纳的回答

Matt J
Matt J 2021-4-12
编辑：Matt J 2021-4-12
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,:)

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Matched Filter and Ambiguity Function 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by