How to replace the 3rd column element of a matrix by comparing 1st and 2nd column of another matrix?

2 vues (au cours des 30 derniers jours)
I have a matrix
A =
1 2 5
1 3 5
1 4 5
1 5 6
2 3 6
2 4 7
3 4 7
3 5 7
4 5 7
and
B=
1 2 3
1 3 4
1 4 5
1 5 6
2 3 4
2 4 5
3 4 5
3 5 6
4 5 6
i want to compare 1st and 2nd column and replace the element of 3rd column of B
for example,
in A when 1st and 2nd column is
[1 2] in 3rd column its corresponding value is 5
so i want to replace B's 3rd column whenever in 1st and 2nd column are 1 2
same way when [1 3] it's value will be updated in B in same format.
please help me...
with regard
Suchismita

Réponse acceptée

Walter Roberson
Walter Roberson le 6 Mai 2015
Have a look at ismember(V,B(:,1:2),'row')
  2 commentaires
suchismita
suchismita le 6 Mai 2015
I was doing this way and was getting error,
[lo,ii] = ismember(B(:,1:2),A(:,1:2)
out = B;
out(lo,3) = A(ii(lo),3)
now i know where was the error...thank u once again

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Resizing and Reshaping Matrices 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