How to create comparison matrices "comparing" strings from 6 different data sources?

Question

German Preciat Gonzalez 2016-7-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/295871-how-to-create-comparison-matrices-comparing-strings-from-6-different-data-sources

评论： Guillaume 2016-7-15

I have data from 4 different sources in a form of strings. I want to compare which strings are the same and if they are not equal count how many times they disagree.

So if the first set of strings is:

array{1}={'111','113','111','111'}

strings 1,3 and 4 are the same, and string 2 is different to all, so I will like to receive a matrix where similar strings have the same number, and one matrix that counts the number of differences when compared with the first string (the first column should be always zero), like this:

 c(1,:)=[1 2 1 1] 
 d(1,:)=[0 1 0 0]   % normaly I use strcmp

if all the strings were different I will like to receive something like this:

c(n,:)=[1 2 3 4]

or all the same

 c(n,:)=[1 1 1 1] 
 d(n,:)=[0 0 0 0]

if a string is missing get an NaN

 c(n,:)=[1 NaN 1 1] 
 d(n,:)=[0 NaN 0 0]

so for this arrays:

 array{1}={'111','113','111','111'}
 array{2}={'111','',   '221','221'}
 array{3}={'111','113',''   ,'113'}
 array{4}={''   ,'133','133','221'}
 array{5}={'231','231','111','231'}

I would like to recieve smoething like:

 c  =  [1    2    1    1;
        1    NaN  3    3;
        1    2    NaN  2;
        NaN  2    2    4;
        1    1    3    1]

Each row represent a comparison of a file between different sources, columns represent the sources, each of the elements of the matrix can take values form 1-4 or NaN.

Column 1 have values of 1 or NaN

Column 2 have values of 1,2 or NaN

Column 3 have values of 1,2,3 or NaN

Column 4 have values of 1,2,3,4 or NaN

And the differences:

 d  =  [0    1    0    0;
        0    NaN  2    2;
        0    1    NaN  1;
        NaN  NaN  NaN  NaN;     % since the first value is missing
        0    0    2    0]

I did that using a lot of IF and the script looks so ugly haha, "If" you can recomend me something I would really appreciate it

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Stephen23 2016-7-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/295871-how-to-create-comparison-matrices-comparing-strings-from-6-different-data-sources#answer_228773

编辑：Stephen23 2016-7-15

在 MATLAB Online 中打开

Your data:

array{1}={'111','113','111','111'};
array{2}={'111','',   '221','221'};
array{3}={'111','113',''   ,'113'};
array{4}={''   ,'133','133','221'};
array{5}={'231','231','111','231'};

The calculation, based on unique:

idz = cellfun('isempty',vertcat(array{:}));
% Comparison:
fun = @(x)unique(x,'first');
[~,idx,idy] = cellfun(fun,array,'UniformOutput',false);
C = cellfun(@(x,y)x(y),idx,idy,'UniformOutput',false);
C = vertcat(C{:});
C(idz) = NaN
% Difference:
D = C-1;
D(bsxfun(@or,idz,idz(:,1))) = NaN

and the outputs:

   C =
       1     2     1     1
       1   NaN     3     3
       1     2   NaN     2
     NaN     2     2     4
       1     1     3     1
  D =
       0     1     0     0
       0   NaN     2     2
       0     1   NaN     1
     NaN   NaN   NaN   NaN
       0     0     2     0

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Guillaume 2016-7-15

在 MATLAB Online 中打开

In my version of matlab (r2016a), 'first' is the default option of unique so could be omitted.

Also, in my version of matlab, the 2nd and 3rd return of matlab are documented as returning column vectors. So I assume the above, use the 'legacy' mode of unique, so fun should be modified to:

fun = @(x) unique(x, 'legacy');

Alternatively, modify the C generation to:

C = cellfun(@(x, y) reshape(x(y), 1, [], idx, idx, 'UniformOutput', false);

With the reshape, it does not matter if unique returns rows or columns.

请先登录，再进行评论。