How to find common rows between two cell arrays containing string values?

16 次查看（过去 30 天）

显示更早的评论

Deepika Vatsa 2019-4-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/455770-how-to-find-common-rows-between-two-cell-arrays-containing-string-values

评论： Jan 2019-4-12

I have two cell arrays A and B containing string values of the form like this :

A = (ABC , DEF ;

HTG , JUKHI;

RTHG,KIO)

B = (HTG , JUKHI;

GHTY , UJIK;

RTGHY, IOP)

I want to find the common rows from these cell arrays, i.e., output = [HTG , JUKHI]

How to do that? I have tried ismember, but it doesnot give correct ans because I want to match exact rows and not just one entry in a row. Any solutions?

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

Jan 2019-4-11

This is no valid Matlab code to create "string values". Therefore the readers have to guess, what your inputs are. So please post some code, which creates the inputs.

请先登录，再进行评论。

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

回答（2 个）

Jan 2019-4-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/455770-how-to-find-common-rows-between-two-cell-arrays-containing-string-values#answer_370187

编辑：Jan 2019-4-11

在 MATLAB Online 中打开

What about ismember(A, B, 'rows')?

I guess your inputs are:

A = ["ABC",  "DEF"; ...
     "HTG",  "JUKHI"; ...
     "RTHG", "KIO"];
B = ["HTG",   "JUKHI"; ...
     "GHTY",  "UJIK"; ...
     "RTGHY", "IOP"]
index  = ismember(A, B, 'rows');
result = A(index, :)

or:

result = intersect(A, B, 'rows')

2 个评论
显示无隐藏无

Deepika Vatsa 2019-4-11

'rows' argument does not go with cell arrays in ismember

Jan 2019-4-12

在 MATLAB Online 中打开

@Deepika Vatsa: You did not mention, that you are talking of cell string. I asked you in a comment, what your inputs are and you did not reply to my comment. It wastes time to let the readers guess, what your inputs are.

The code I have posted works as expected. So simply use strings instead of cell strings.

A = {'ABC',  'DEF'; ...
     'HTG',  'JUKHI'; ...
     'RTHG', 'KIO'};
B = {'HTG',   'JUKHI'; ...
     'GHTY',  'UJIK'; ...
     'RTGHY', 'IOP'};
[~, iA] = intersect(strcat(A(:,1), '*', A(:,2)), ...
                    strcat(B(:,1), '*', B(:,2)));
Result = A(iA, :);

请先登录，再进行评论。

Alex Mcaulley 2019-4-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/455770-how-to-find-common-rows-between-two-cell-arrays-containing-string-values#answer_370189

在 MATLAB Online 中打开

An option:

A = {'ABC','DEF';'HTG','JUKI';'RTHG','KIO'};
B = {'HTG','JUKI';'GHTY','UJIK';'RTGHY','IOP'};
setdiff(A,setdiff(A,B))

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

Alex Mcaulley 2019-4-11

在 MATLAB Online 中打开

But your code doesn't work in your first example:

[~ , idd1] = ismember(A(:,1),B(:,1));
[~ , idd2] = ismember(A(:,2),B(:,2));
idx = idd1 == idd2;
common_rows = A(idx,:);
common_rows =
  3×2 cell array
    'ABC'     'DEF' 
    'HTG'     'JUKI'
    'RTHG'    'KIO' 