How to count the number of unique elements by group in a table

21 次查看（过去 30 天）
Blue
Blue 2019-8-8
回答： Blue 2019-8-8
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,

请先登录，再回答此问题。

采纳的回答

Blue
Blue 2019-8-8
I found the answer in an earlier post (https://www.mathworks.com/matlabcentral/answers/418060-count-unique-id-occurrences-in-a-column-after-grouping-based-on-another-column)
name = {'A', 'A', 'A', 'B', 'B', 'B', 'C', 'C', 'C'}.';
type = {'AA', 'BB', 'CC', 'BB', 'BB', 'BB', 'AA', 'CC', 'CC'}.';
t = table(name, type);
n_type = rowfun(@(v) numel(unique(v)), t, 'GroupingVariables', 'name', 'InputVariables', 'type')

更多回答（1 个）

KALYAN ACHARJYA
KALYAN ACHARJYA 2019-8-8
编辑：KALYAN ACHARJYA 2019-8-8
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 个评论
Blue
Blue 2019-8-8
Thank you kindly for your answer but it doesnt quite do what I want. I need a count of the unique elements per group, in this case 3,1,2.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by