How to find common rows between two cell arrays containing string values?
16 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaire
Jan
le 11 Avr 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.
Réponses (2)
Jan
le 11 Avr 2019
Modifié(e) : Jan
le 11 Avr 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 commentaires
Jan
le 12 Avr 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
le 11 Avr 2019
An option:
A = {'ABC','DEF';'HTG','JUKI';'RTHG','KIO'};
B = {'HTG','JUKI';'GHTY','UJIK';'RTGHY','IOP'};
setdiff(A,setdiff(A,B))
6 commentaires
Alex Mcaulley
le 11 Avr 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'
Voir également
Catégories
En savoir plus sur Logical dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!