How do I select the minimum value from the first column based on the corresponding value in the second column?

15 次查看（过去 30 天）
Bhavishey Thapar
Bhavishey Thapar 2022-2-17
评论： Bhavishey Thapar 2022-2-17
I have data in two columns as shown below.
I want to find the minimum value in column one but the minimum function should only consider values in the 1st column, whose corresponding value in the 2nd column is a 0.
So in the above 8 rows the minimum value would be 3 since the minimum function would only look at 3,5,7,76.
How can achieve this?

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

采纳的回答

KSSV
KSSV 2022-2-17
Ran in:
Let A be your data.
A = [1 1; 22 1; 3 0 ; 5 0; 60 1; 76 0; 7 0; 12 0] ;
iwant = min(A(A(:,2)==0,1))
iwant = 3

更多回答（1 个）

Sajid Afaque
Sajid Afaque 2022-2-17
编辑：Sajid Afaque 2022-2-17
use the below workaround
%variable
var = [[1;22;3;5;60;76;7;12] [1;1;0;0;1;0;0;1]];
%select only the portion which has second column entries as zeroes
var1 = var(find(var(:,2) == 0),:);
%now apply the min function
min_value = min(var1(:,1));
same in one line
%
min_value = min(var(find(var(:,2) == 0),1))

类别

在 Help Center 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by