A compact way to find max in one column with a condition on the second column
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Given
a = [35 -1
21 1
11 2];
I want the max in the first column, but the max cannot be that one where there is a "-1" in the second column.
Therefore the correct answer is not "35" (since in the second column there is "-1"), but "21".
Do you know a compact way to get this max in the first column, with the condition on the second column ?
0 Kommentare
Akzeptierte Antwort
Bruno Luong
am 7 Okt. 2022
a = [35 -1
21 1
11 2];
max(a(a(:,2) ~= -1,1))
3 Kommentare
Bruno Luong
am 7 Okt. 2022
If you want to get row index of the max value:
a = [35 -1
21 1
11 2];
filteridx = find(a(:,2) ~= -1);
[maxvalue, maxidx] = max(a(filteridx,1));
maxidx = filteridx(maxidx)
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Matrices and Arrays finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!