MATLAB: Comparing 2 columns of a matrix

MATLABmatrix

I want to compare 2 columns of my matrix as shown below:

For example, I have the number 4 in the first column occurring thrice. I need to compare it's corresponding values in column 2 and obtain the minimum value among them. I then need to store that value in another matrix.

Could someone suggest me a way to get this desired result.

Thanks and regards

Best Answer

Try this (using the accumarray (link) function):

A = [randi(10, 20, 1) rand(20,1)]                               % Create Data
[A1u,~,idx] = unique(A(:,1));                                   % Unique Values & Indices
MinVals = accumarray(idx, A(:,2), [], @(x)min(x));              % Find Minimum Of Each
Result = [A1u, MinVals]                                         % Desired Result

Use your own matrix for ‘A’.

Related Solutions

MATLAB: Finding Rest of Row

Do you mean like vlookup in excel? Try this:

data = randi(1,4,5); % Just an example matrix
first = data(randi(4),1); % Example of desired number in first column
index = data(:,1) == first; % Find in which row is your desired number located
rest = data(index,2:end); % Get the rest of columns of that row

MATLAB: How to find rows with maximum number

This works:

A = [5
    2
    2
    4
    3
    2];
[Au,ia,ic] = unique(A, 'stable');
h = accumarray(ic, 1);
B = A;
B(ic~=Au(h==max(h))) = 0
B =
       0
       2
       2
       0
       0
       2

Best Answer

Related Solutions

MATLAB: Finding Rest of Row

MATLAB: How to find rows with maximum number

Related Question