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

조회 수: 1 (최근 30일)
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 CenterFile 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