Replace elements between two matrices

2 vues (au cours des 30 derniers jours)
Ismaeel
Ismaeel le 6 Déc 2016
Modifié(e) : Ismaeel le 7 Déc 2016
I have two matrices A and B:
A= [8 1;
16 2];
B= [8 10;
16 5]
I want to replace any element in B that exist in the 1st column of A, by its corresponding value in the second column of A. The result should be:
C=[1 10;
2 5];
Thanks for help

Réponse acceptée

Image Analyst
Image Analyst le 7 Déc 2016
Try this:
A= [8 1;
16 2]
B= [8 10;
16 5]
% If A & B are integers
rowsToReplace = A(:, 1) == B(:, 1)
C = B; % Initialize C to B.
% Now, replace the rows that need replacing:
C(rowsToReplace, 1) = A(rowsToReplace, 2)
  2 commentaires
Ismaeel
Ismaeel le 7 Déc 2016
That is what I was looking for, thank you so much.
Ismaeel
Ismaeel le 7 Déc 2016
Modifié(e) : Ismaeel le 7 Déc 2016
Image Analyst, sorry but how about if size(A)~=size(B)? I have a case in this pattern.

Connectez-vous pour commenter.

Plus de réponses (1)

Chaya N
Chaya N le 7 Déc 2016
Try the setxor function. You may need to tweak the directionality of the inputs a bit, so use something like
C = setxor(A',B','rows')'
  3 commentaires
Image Analyst
Image Analyst le 7 Déc 2016
Ismael, this code:
A= [8 1;
16 2]
B= [8 10;
16 5]
C = setxor(A',B','rows')'
gives
A =
8 1
16 2
B =
8 10
16 5
C =
1 10
2 5
which is the C you originally asked for. Now you're giving a different desired value for C. Which is it?
Ismaeel
Ismaeel le 7 Déc 2016
Modifié(e) : Ismaeel le 7 Déc 2016
That is true for the case when the first column in A and B are the same. How about if some elements of the 1st column of B are not similar to the elements in the 1st column of A. If, for instance, the element (1,1) in B which is =8 is any number except 8, I don't want to keep different elements and replace similars with their corresponding second column in A.
Simply,
if B(i,1)==A(i,1)
replace B(i,1) with A(i,2)
otherwise don't change

Connectez-vous pour commenter.

Catégories

En savoir plus sur NaNs dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by