Clear Filters
Clear Filters

extracting data from matrix

3 views (last 30 days)
Abdelwahab Fawzy
Abdelwahab Fawzy on 16 Jul 2016
Edited: per isakson on 16 Jul 2016
Hello every bod
let assume matrix
A =
[10 20 1
30 40 2
50 60 3
70 80 4
90 100 5]
B =
[30 40
70 80]
we need to identify the third column of the matrix B, hence
B =
[30 40 2
70 80 4]

Answers (1)

Azzi Abdelmalek
Azzi Abdelmalek on 16 Jul 2016
Edited: Azzi Abdelmalek on 16 Jul 2016
A= [10 20 1
30 40 2
50 60 3
70 80 4
90 100 5]
B=[30 40
70 80]
idx=ismember(A(:,1:2),B,'rows')
B(:,3)=A(idx,3)
  2 Comments
Abdelwahab Fawzy
Abdelwahab Fawzy on 16 Jul 2016
I tried this code for other different matrices I get a problem at which the third column is not compatible with the first and 2'nd column data in terms of ordering
Azzi Abdelmalek
Azzi Abdelmalek on 16 Jul 2016
Edited: Azzi Abdelmalek on 16 Jul 2016
Can you explain? post an example to make your question clear

Sign in to comment.

Categories

Find more on Matrices and Arrays in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!