MATLAB: How to select between duplicated non-integer values of a matrix

find duplicated non-integer

A= [10.01 5.02;15.20 6.01;14.05 7.12;14.05 5.14;13.5 9.11] I need to find equal number in first column and find the minimum of the corresponding second column. [14.05 5.12] Then create a new matrix as: B= [10.01 5;15.20 6;14.05 5;13.5 9]

But I cannot use “accumarray” as my values are not integer. Would you please guide me?

Best Answer

"But I cannot use “accumarray” as my values are not integer." So what?

[values, ~, subs] = unique(A(:, 1));
B = [values, accumarray(subs, A(:, 2), [], @min)]

Related Solutions

MATLAB: Erasing specifi rows from a cell matrix

 [x,y]=unique(A(:,1),'stable');A=A(y,:)

MATLAB: How Do I find unique values of an element in a matrix

Use accumarray:

>> A = [5,12,25,0;2,10,24,0;1,7,25,1;5,5,12,0;2,6,23,1]
A =
     5    12    25     0
     2    10    24     0
     1     7    25     1
     5     5    12     0
     2     6    23     1
>> [val,~,idx] = unique(A(:,1));
>> out(:,4) = accumarray(idx,A(:,4));
>> out(:,3) = accumarray(idx,A(:,3));
>> out(:,2) = accumarray(idx,A(:,2));
>> out(:,1) = val
out =
     1     7    25     1
     2    16    47     1
     5    17    37     0

Best Answer

Related Solutions

MATLAB: Erasing specifi rows from a cell matrix

MATLAB: How Do I find unique values of an element in a matrix

Related Question