How to count the number of unique elements by group in a table
Mostrar comentarios más antiguos
Hi,
How can I count the number of unique elements by group in a table and save the answer in a vector ?
% Create table
name = {'A', 'A', 'A', 'B', 'B', 'B', 'C', 'C', 'C'}.';
type = {'AA', 'BB', 'CC', 'BB', 'BB', 'BB', 'AA', 'CC', 'CC'}.';
t = table(name, type);
For example, in the table here the number of unique 'type' per 'name' would yield 3, 1, 2 (i.e. 3 'unique 'types' for name A, 1 'unique 'types' for name B, and 2 'unique 'types' for name C,)
Thank you,
Respuesta aceptada
Más respuestas (1)
KALYAN ACHARJYA
el 8 de Ag. de 2019
Editada: KALYAN ACHARJYA
el 8 de Ag. de 2019
name = {'A', 'A', 'A', 'B', 'B', 'B', 'C', 'C', 'C'}.';
type = {'AA', 'BB', 'CC', 'BB', 'BB', 'BB', 'AA', 'CC', 'CC'}.';
t = table(unique(name), unique(type))
Command Window:
t =
3×2 table
Var1 Var2
_ ____
'A' 'AA'
'B' 'BB'
'C' 'CC'
Unique Elements
>> H=height(t)
H =
3
1 comentario
Blue
el 8 de Ag. de 2019
Categorías
Más información sobre Tables en Centro de ayuda y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!