MATLAB: Is there a way to use setdiff or any function to compare two data sets within a range of each other

comparisondatadatasetssetdiffStatistics and Machine Learning Toolbox

I have two large data sets that are equal in dimensions but not in variables. Also the variables are similar but not exact so setdiff returns every value in the smaller data set. I'd like to know is there a way to add some range into the setdiff function like setdiff(A,B<+-2,B<+-2)?

Best Answer

Starting in R2015a, there is a function ismembertol. You can use this and the set diff logic on idx.

Related Solutions

MATLAB: How to join two matrices based on similar array in each

Here is one way:

uniqueA = unique(A,'rows');
[~,idx] = ismember(B(:,3),uniqueA(:,1));
C = [B,uniqueA(idx,2:end)];

I am making a couple assumptions here, based on your one example:

The rows in A with the same values in the first column are also identical throughout.
Every value in B(:,3) is represented in A(:,1)

MATLAB: Operating on One Column Based on Another

You should look into accumarray:

>> A = [1;1;1;1;2;2;2;3;3;3;3;3;4;4;4;5;5;5];
>> B = [1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18];
>> S = accumarray(A,B,[],@sum)
S =
    10
    18
    50
    42
    51
>> S(A)
ans =
    10
    10
    10
    10
    18
    18
    18
    50
    50
    50
    50
    50
    42
    42
    42
    51
    51
    51

If the values of A are not consecutive integers starting from one, then use unique first and use its third output argument.

Best Answer

Related Solutions

MATLAB: How to join two matrices based on similar array in each

MATLAB: Operating on One Column Based on Another

Related Question