find column variable sharing another column variable (table)
1 view (last 30 days)
Show older comments
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
0 Comments
Answers (1)
Ameer Hamza
on 6 Apr 2020
name2={'XX1';'XX1';'XX1';'XX2';'XX2'};
groups = findgroups(name2)
ans =
1
1
1
2
2
0 Comments
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!