How to obtain the unique combinations of two columns in a table

99 次查看（过去 30 天）
Blue
Blue 2019-8-9
评论： Blue 2019-8-9
Hi,
I am trying to obtain all the unique combinations of two columns in a table. Lets say we have the following table:
year = {1994, 1994, 1994, 1995, 1995, 1995, 1996, 1996, 1996}.';
type = {'AA', 'BB', 'CC', 'BB', 'BB', 'BB', 'AA', 'CC', 'CC'}.';
t = table(year, type);
How can I extract the unique combinations of 'year' and 'type' in order to get something like this:
year = {1994, 1994, 1994, 1995, 1996, 1996}.';
type = {'AA', 'BB', 'CC', 'BB', 'AA', 'CC'}.';
answer = table(year, type);
Thank you

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

采纳的回答

dpb
dpb 2019-8-9
year = [1994, 1994, 1994, 1995, 1995, 1995, 1996, 1996, 1996].';
type = {'AA', 'BB', 'CC', 'BB', 'BB', 'BB', 'AA', 'CC', 'CC'}.';
t = table(year, type);
>> unique(t,'rows')
ans =
6×2 table
year type
____ ____
1994 'AA'
1994 'BB'
1994 'CC'
1995 'BB'
1996 'AA'
1996 'CC'
>>

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by