how to compare every pair of rows and return a matrix?

5 次查看（过去 30 天）

chocho 2018-5-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/401885-how-to-compare-every-pair-of-rows-and-return-a-matrix

评论： Jan 2018-5-28

Hello guys, I have a matrix of 135 rows and 2 columns and I want to compare every two pairs of rows based on their overlapped elements and return a matrix.

I have attached some rows from my matrix to make the question more clear

4 个评论
显示 2更早的评论隐藏 2更早的评论

Guillaume 2018-5-22

编辑：Guillaume 2018-5-22

It's not clear what a common element is. Not helped by the fact that there's probably a typo in if i take row2 and row2 they have 5 common elements since comparing something with itself is certain to say that everything is common.

Similarly, defines what compare means for you.

chocho 2018-5-22

编辑：chocho 2018-5-22

@Guillaume sorry is a typo I mean row2 and row3 because they have 5 genes in common (RASGRP4, RASGPR2, RAF1, PRAKACA, RAS1) so the output is 5

请先登录，再进行评论。

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

采纳的回答

Jan 2018-5-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/401885-how-to-compare-every-pair-of-rows-and-return-a-matrix#answer_321331

在 MATLAB Online 中打开

I guess your matrix is a cell string and you want to find common sub-strings in it.

% Assuming your matrix is called "M":
n = size(M, 1);
% Convert the strings in the 2nd column to cell strings:
Sub = cell(1, n);
for k = 1:n
  Sub{k} = strtrim(strsplit(M{k, 2}, ','));
end
Match = cell(n, n);
for i1 = 1:n
  for i2 = i1+1:n
    v             = intersect(Sub{i1}, Sub{i2});
    Match{i1, i2} = v;
    Match{i2, i1} = v;   % Output is symmetric
  end
end

Or maybe you want ismember instead of intersect. Or you want to output the indices? Or the output should be a logical matrix, which is TRUE if the sub-strings have any overlap?

Please explain "compare every two pairs of rows" specifically. Most likely the above code can be adjusted easily.