How to find common rows between two cell arrays containing string values?
16 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentario
Jan
el 11 de Abr. de 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.
Respuestas (2)
Jan
el 11 de Abr. de 2019
Editada: Jan
el 11 de Abr. de 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 comentarios
Jan
el 12 de Abr. de 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
el 11 de Abr. de 2019
An option:
A = {'ABC','DEF';'HTG','JUKI';'RTHG','KIO'};
B = {'HTG','JUKI';'GHTY','UJIK';'RTGHY','IOP'};
setdiff(A,setdiff(A,B))
6 comentarios
Alex Mcaulley
el 11 de Abr. de 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'
Ver también
Categorías
Más información sobre Logical en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!