Matlab - Finding values within a matrix

Question

How can I find the row that have all the values from A into the matrix B and display the index of the rows using Matlab?

A= [2 5 6];

B=[1 2 4 9 10 15 27 30; 
   1 2 3 4 5 6 7 8; 
   1 2 3 5 6 9 22 101; 
   2 4 5 6 14 20 22 23]

Thanks

Just to clarify: in your example you would get rows 2,3 and 4 as output? Or does the [2 5 6] vector need to be contiguous? — Wouter Kuijsters
– Wouter Kuijsters, Commented Mar 15, 2015 at 13:37
All good now, The answer bellow was what I was looking for. Thanks — Emanuel
– Emanuel, Commented Mar 18, 2015 at 11:56

Divakar · Accepted Answer · 2015-03-15 14:12:03Z

3

With bsxfun in 3D -

ind = find(all(any(bsxfun(@eq,B,permute(A,[1 3 2])),2),3))

With bsxfun again, but keeping it in 2D -

ind = find(sum(reshape(any(bsxfun(@eq,B(:),A(:).'),2),size(B)),2)==numel(A))

With ismember -

ind = find(sum(reshape(ismember(B(:),A(:)),size(B)),2)==numel(A))

With pdist2 from Statistics and Machine Learning Toolbox -

ind = find(sum(reshape(any(pdist2(B(:),A(:))==0,2),size(B)),2)==numel(A))

With knnsearch again from Statistics and Machine Learning Toolbox-

[~,dists] = knnsearch(A(:),B(:))
ind = find(sum(reshape(dists==0,size(B)),2)==numel(A))

Sample run -

A =
     2     5     6
B =
     1     2     4     9    10    15    27    30
     1     2     3     4     5     6     7     8
     1     2     3     5     6     9    22   101
     2     4     5     6    14    20    22    23
ind =
     2
     3
     4

edited Mar 15, 2015 at 14:12

answered Mar 15, 2015 at 13:38

Divakar

222k19 gold badges273 silver badges374 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Divakar Over a year ago

@Emanuel Consider accepting it, by clicking on the checkmark next to the solution. Read more about it here.

Emanuel Over a year ago

And if I have three or four matrices to search through B and get the index similar? A= [2 5 6]; C=[4 5 6]; D=[8 9 10; 2 9 19]; B=[1 2 4 9 10 15 27 30; 1 2 3 4 5 6 7 8; 1 2 3 5 6 9 22 101; 2 4 5 6 14 20 22 23] How can I do this?

Collectives™ on Stack Overflow

Matlab - Finding values within a matrix

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related