MATLAB: Finding identical rows in 2 tables

find

Hi everyone, I think my question is relatively easy to answer, but for some reason I can't seam to get it right. Any help will be apreciated.

Let's say I have a table A that has N rows and M columns. i have an other table B that has N+X rows and M columns. Table B contains all the rows in A, plus other rows.

I would like, for every row, to create a variable that takes the value 1 if this row is in table A, and that takes the value 0 if this row isn't in Table A.

Thanks in advance.

Best Answer

look for doc in "doc ismember". There is an example for table rows found in another table.

Related Solutions

MATLAB: Table: how to extract rows that contain a certain string and put those values into a new column

YourTable.NewVariableName = string(nan(height(YourTable, 1)));
mask = contains(YourTable{:,3}, "house");
YourTable.NewVariableName(mask) = YourTable{mask,:3};

MATLAB: Finding and saving identical rows in a matrix

Alternatively:

 [~, ~, ic] = unique( A(:,1:2), 'rows' ) ;
 groups = splitapply( @(x){x}, A, ic ) ;

produces

 groups =
  11×1 cell array
    {3×3 double}
    {3×3 double}
    {3×3 double}
    {3×3 double}
    {3×3 double}
    {3×3 double}
    {3×3 double}
    {3×3 double}
    {3×3 double}
    {1×3 double}
    {1×3 double}

and then

 isAlone = cellfun( @(x) size(x,1), groups ) == 1 ;
 merged  = vertcat( groups{isAlone} ) ;
 groups  = groups(~isAlone) ;

where groups is the cell array of all groups of rows that are not unique, and merged is a merge of all others.

Best Answer

Related Solutions

MATLAB: Table: how to extract rows that contain a certain string and put those values into a new column

MATLAB: Finding and saving identical rows in a matrix

Related Question