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

2 visualizzazioni (ultimi 30 giorni)
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?

Risposta accettata

Matt J
Matt J il 12 Apr 2021
Modificato: Matt J il 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,:)

Più risposte (0)

Prodotti


Release

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by