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

2 Ansichten (letzte 30 Tage)
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?

Akzeptierte Antwort

Matt J
Matt J am 12 Apr. 2021
Bearbeitet: Matt J am 12 Apr. 2021
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,:)

Weitere Antworten (0)

Produkte


Version

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by