How to find common rows between two cell arrays containing string values?
18 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
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 日
編集済み: Jan
2019 年 4 月 11 日
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 件のコメント
Jan
2019 年 4 月 12 日
@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 日
An option:
A = {'ABC','DEF';'HTG','JUKI';'RTHG','KIO'};
B = {'HTG','JUKI';'GHTY','UJIK';'RTGHY','IOP'};
setdiff(A,setdiff(A,B))
6 件のコメント
Alex Mcaulley
2019 年 4 月 11 日
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'
参考
カテゴリ
Help Center および File Exchange で Logical についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!