How to find common rows between two cell arrays containing string values?
18 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentar
Jan
am 11 Apr. 2019
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.
Antworten (2)
Jan
am 11 Apr. 2019
Bearbeitet: Jan
am 11 Apr. 2019
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 Kommentare
Jan
am 12 Apr. 2019
@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
am 11 Apr. 2019
An option:
A = {'ABC','DEF';'HTG','JUKI';'RTHG','KIO'};
B = {'HTG','JUKI';'GHTY','UJIK';'RTGHY','IOP'};
setdiff(A,setdiff(A,B))
6 Kommentare
Alex Mcaulley
am 11 Apr. 2019
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'
Siehe auch
Kategorien
Mehr zu Logical finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!