MATLAB Answers

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

120 views (last 30 days)
Blue
Blue on 9 Aug 2019
Commented: Blue on 9 Aug 2019
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

  0 Comments

Sign in to comment.

Accepted Answer

dpb
dpb on 9 Aug 2019
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'
>>

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!