A compact way to find max in one column with a condition on the second column

2 次查看（过去 30 天）
Sim
Sim 2022-10-7
评论： Sim 2022-10-7
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 ?

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

采纳的回答

Bruno Luong
Bruno Luong 2022-10-7
Ran in:
a = [35 -1
21 1
11 2];
max(a(a(:,2) ~= -1,1))
ans = 21
  3 个评论
显示 1更早的评论
Bruno Luong
Bruno Luong 2022-10-7
Ran in:
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)
maxidx = 2

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by