find column variable sharing another column variable (table)
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Ameer Hamza
le 6 Avr 2020
name2={'XX1';'XX1';'XX1';'XX2';'XX2'};
groups = findgroups(name2)
ans =
1
1
1
2
2
0 commentaires
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!