MATLAB: How to compare every pair of rows and return a matrix

comparison

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

Best Answer

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.
Related Question