find column variable sharing another column variable (table)

2 次查看（过去 30 天）
Dave
Dave 2020-4-6
回答： Ameer Hamza 2020-4-6
I have two variables where name1 shares name2 in some cases.
unique(name1) is larger than unique(name2)
name1={'ABC';'ABC';'DEF';'GHI';'GHI'};
name2={'XX1';'XX1';'XX1';'XX2';'XX2'};
T=table(name1, name2);
In this example ABC and DEF share XX1.
How can I find the location of the shared cases? In this example would be rows 1, 2, 3

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

回答（1 个）

Ameer Hamza
Ameer Hamza 2020-4-6
name2={'XX1';'XX1';'XX1';'XX2';'XX2'};
groups = findgroups(name2)
ans =
1
1
1
2
2

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by