Thread Subject:

Finding if a row is in a matrix or not

Assume we have a matrix A,

A=[3 2 1 10;
     5 1 2 8;
     7 4 1 9;
     6 9 2 3];

I want to see if the first 3 elements of any row are equal to a vector I have, so lets say I have a vector [5 1 2] and I want to see if it is or not in the matrix A. If it is then I can get a 1 for true, or a 0 for false. In case I have a vector [1 2 8] it should give a 0 as it is not the same as any first three elements of any row.

I know strfind does the work when we have one column or row vector, but I do not know when we have a matrix. I know I can do a loop through that but I am checking if there is a straight way and faster way to do it.

for i = 1:size(A,1)
    ToF = strfind(A(i,:),[5 1 2]);
    if ToF == 1
        break
    end
end

Hope I made myself clear, if not let me know.

Thanks!

"Diego Zegarra" <diegozbb@gmail.com> wrote in message <gnpdbh$3sh$1@fred.mathworks.com>...
> Assume we have a matrix A,
>
> A=[3 2 1 10;
> 5 1 2 8;
> 7 4 1 9;
> 6 9 2 3];
>
> I want to see if the first 3 elements of any row are equal to a vector I have, so lets say I have a vector [5 1 2] and I want to see if it is or not in the matrix A. If it is then I can get a 1 for true, or a 0 for false. In case I have a vector [1 2 8] it should give a 0 as it is not the same as any first three elements of any row.
>
> I know strfind does the work when we have one column or row vector, but I do not know when we have a matrix. I know I can do a loop through that but I am checking if there is a straight way and faster way to do it.
>
> for i = 1:size(A,1)
> ToF = strfind(A(i,:),[5 1 2]);
> if ToF == 1
> break
> end
> end
>
> Hope I made myself clear, if not let me know.
>
> Thanks!

Use ISMEMBER on the first three columns of A. See the help how to use it on rows.

hth
Jos

Thanks Jos, it would work like this,

tf = sum(ismember(A(:,1:3), [5 1 2], 'rows'))

"Diego Zegarra" wrote in message <gnpgtv$1hh$1@fred.mathworks.com>...
> Thanks Jos, it would work like this,
>
> tf = sum(ismember(A(:,1:3), [5 1 2], 'rows'))

For this purpose I posted a mfind matlab function that finds the matching rows or columns in a matrix

   [ I B ] = mfind(M, X)

   Find the row or column vector X within the matrix M.
   If X is a row vector, I will contain the column indexes where X is a row in M.
   If X is a column vector, I will contain the row indexes where X is a column in M.
   B will contain the boolean matching rows or columns.
   If no match if found, I will be empty.

   Example:
      a = [1 2; 3 4; 5 6];

      [i b] = mfind(a, [3 4])
      i = 2
      b = [ 0; 1; 0 ]

      [i b] = mfind(a, [1; 3; 5])
      i = 1
      b = [ 1 0 ]

The MFIND script may be downloaded here in MATALB central files exchange

A =

     3 2 1 10
     5 1 2 8
     7 4 1 9
     6 9 2 3

a = [ 5 1 2]

To find whether the vector a is occurring in the first three columns of the original matrix A we can give ,

find(ismember(A(:,1:3),a,'rows'),1)

ans =

      2