String matrix compare to get common in rows

Question

Touts Touts 2019-6-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/469090-string-matrix-compare-to-get-common-in-rows

评论： Touts Touts 2019-6-28

Deal all, i have a problem to compare two string matrix :

A1 = {'AA', 'b' ; 'cc', 'ff'}
A2 = {'ee', 'AA' ; 'hhh', 'm'}
strcmp(A1,A2)

I get

A1 = 
    'AA'    'b' 
    'cc'    'ff'
A2 = 
    'ee'     'AA'
    'hhh'    'm'
ans =
     0     0
     0     0

But i need to get

'AA' is common between A1 iand A2 in the row 1

Best regard

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

请先登录，再进行评论。

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

Answer 1

Stephen23 2019-6-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/469090-string-matrix-compare-to-get-common-in-rows#answer_381186

编辑：Stephen23 2019-6-28

在 MATLAB Online 中打开

>> A1 = {'AA', 'b' ; 'cc', 'ff' ; 'tt', 'kk'; 'XX', 'b'; 'AA', 'b'};
>> A2 = {'ee', 'AA' ; 'hhh', 'm'; 'kk', 'o'; 'ee', 'XX'; 'AA', 'b'};
>> X = cell2mat(cellfun(@ismember,num2cell(A1,2),num2cell(A2,2),'uni',0));
>> [R,~] = find(X);
>> [~,Y] = sort(R);
>> C = [A1(X),num2cell(R)].';
>> fprintf('''%s'' common at row %d\n',C{:,Y})
'AA' common at row 1
'kk' common at row 3
'XX' common at row 4
'AA' common at row 5
'b' common at row 5

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

Stephen23 2019-6-28

在 MATLAB Online 中打开

"...is it possible to ignore the empty values"

Of course, just add this line after X is defined:

X = X & ~cellfun(@isempty,A1);

Touts Touts 2019-6-28

Thanks a lot dear Stephen Cobeldick

请先登录，再进行评论。

Answer 2

Geoff Hayes 2019-6-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/469090-string-matrix-compare-to-get-common-in-rows#answer_380983

在 MATLAB Online 中打开

Touts - consider using ismember to check to see if any string of A1 matches with any string of A2

>> ismember(A1,A2)
ans =
     1     0
     0     0

5 个评论
显示 3更早的评论隐藏 3更早的评论

Stephen23 2019-6-28

编辑：Stephen23 2019-6-28

@Touts Touts: repeating and clarifying Geoff Hayes's questions, which you did not answer:

what happens if 'AA' occurs on different rows?
what happens if 'AA' occurs multiple times within one matrix?

Touts Touts 2019-6-28

在 MATLAB Online 中打开

Dear Stephen Cobeldick and Geoff Hayes

Please, i need all the common between A1 and A2 and their rows

A1 = {'AA', 'b' ; 'cc', 'ff' ; 'tt', 'kk'; 'XX', 'b'; 'AA', 'b'}
A2 = {'ee', 'AA' ; 'hhh', 'm'; 'kk', 'o'; 'ee', 'XX'; 'AA', 'b'}

so

A1 = 
    'AA'    'b' 
    'cc'    'ff'
    'tt'    'kk'
    'XX'    'b' 
    'AA'    'b' 
A2 = 
    'ee'     'AA'
    'hhh'    'm' 
    'kk'     'o' 
    'ee'     'XX'
    'AA'     'b' 