Find non unique string in a table

28 visualizaciones (últimos 30 días)
Sonima
Sonima el 6 de Ag. de 2019
Respondida: Sonima el 9 de Ag. de 2019
Hi!
I have a table "TT" which I want to return the "Ticket" of non unique string in the "Alpha".
TT =
8×2 table
Ticket Alpha
_______ ________
29991 AB'
29991 CD'
29993 EF'
30018 GH'
30066 IJ'
30105 KL'
30105 EF'
30107 NO'
here EF in not unique under "Alpha" and I want to return "30105". How can i do this?

Respuesta aceptada

Adam Danz
Adam Danz el 6 de Ag. de 2019
Editada: Adam Danz el 8 de Ag. de 2019
nonUnqIdx is a logical index of rows of TT.Alpha that are a repeat (ie, not the first instance).
[~, AlphaGroups] = ismember(TT.Alpha, unique(TT.Alpha,'stable')); % identify groups
nonUnqIdx = [1;diff(AlphaGroups)] < 1;
% Tickets for all non-unique (ie repeat) strings in Alpha
TT.Ticket(nonUnqIdx)

Más respuestas (2)

Sean de Wolski
Sean de Wolski el 8 de Ag. de 2019
n = groupcounts(T.Alpha)
[~, last] = unique(T.Alpha, 'last')
T.Ticket(last(n>1))
Using the "new and shiny" groupcounts.

Sonima
Sonima el 9 de Ag. de 2019
T.Ticket(groupcounts(T.Alpha)>1)

Categorías

Más información sobre Tables en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by