How to count number of times 2 elements appear together in a table
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Michael Boyle
le 30 Avr 2021
Modifié(e) : Scott MacKenzie
le 30 Avr 2021
I have a table of teams and names and I want to get an output of the number of times 2 specific names appear together in the table. For example, I want to know the number of times that 'person2' and 'person4' appear in the same row in columns 2 and 3 and in columns 5 and 6. The name placements are randomized every time the code is run so it would need to work for every new table
0 commentaires
Réponse acceptée
Scott MacKenzie
le 30 Avr 2021
Modifié(e) : Scott MacKenzie
le 30 Avr 2021
p1 = 'person5'; % as an example
p2 = 'person4'; % as an example
sum(strcmp(T{:,2},p1) & strcmp(T{:,3},p2) & ...
strcmp(T{:,5},p1) & strcmp(T{:,6},p2));
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Logical 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!