MATLAB: Compare datasets and remove not common rows

compare remove

Hello all, I have to compare two datasets (a= 89072 x 13 & b=89268 x 37) that must have the same rows, so I have to remove the rows that are not common. The columns number for the two dataset are not the same, so I can't 'Intersect' them. How can I remove these rows please?

Thank you

Best Answer

What do you mean by " I have to remove the rows that are not common"? if you mean to reduce the size of the other dataset(b) and make it equal to

a,

then you can use

b(1:length(a),:)

Related Solutions

MATLAB: “Error using horzcat Dimensions of matrices being concatenated are not consistent.”

Remove the [] in the kk line.

MATLAB: How to reorder cell array columns based on the order of a vector matrix, while keeping rows intact in Matlab

Would this work?

 >> buffer = arrayfun(@(rId) data(rId,order(rId,:)).', 1:size(order,1), ...
                      'UniformOutput', false) ;
 >> reordered_data = [buffer{:}].'
 reordered_data = 
    'B'    'B'    'B'    'B'    'B'    'A'    'A'    'B'
    'B'    'B'    'A'    'B'    'A'    'A'    'A'    'A'
    'A'    'A'    'B'    'A'    'A'    'B'    'B'    'B'
    'A'    'A'    'A'    'A'    'B'    'A'    'A'    'A'

Best Answer

Related Solutions

MATLAB: “Error using horzcat Dimensions of matrices being concatenated are not consistent.”

MATLAB: How to reorder cell array columns based on the order of a vector matrix, while keeping rows intact in Matlab

Related Question