Compare two matrices and select max one based on the a column

I have two matrixes and I want to compare the last column. Then select the max one and the whole corresponding row.
For example
A = [ 1 , 4, 5; 1, 4, 6];
B = [2, 6, 6; 2, 5 , 9];
The next matrix based on the last column max will be
C = [2, 6, 6; 2, 5 , 9];
Anyway to help, please

 Réponse acceptée

If I understood correctly:
C = A;
replacebyB = B(:, end) > A(:, end);
C(replacebyB, :) = B(replacebyB, :);
The above gives priority to A when the last columns are equal.

Plus de réponses (1)

C = max(A,B)

3 commentaires

Yaser Khojah
Yaser Khojah le 17 Mar 2020
Modifié(e) : Yaser Khojah le 17 Mar 2020
It does not work in my example. I have to select the max of the last column then select its row? This one would compare element by element
Illustrate the answer if the B were to be
B = [2, 6, 4; 2, 5 , 9];
Something like this without the forloop
C = zeros(size(A));
for i = 1:11
c = [A(i,:);B(i,:)];
[Max_v, idx] = max(c(:,end));
C(i,:) = c(idx,:);
end

Connectez-vous pour commenter.

Catégories

En savoir plus sur Loops and Conditional Statements dans Centre d'aide et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by