How to count number of times 2 elements appear together in a table
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Michael Boyle
il 30 Apr 2021
Modificato: Scott MacKenzie
il 30 Apr 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 Commenti
Risposta accettata
Scott MacKenzie
il 30 Apr 2021
Modificato: Scott MacKenzie
il 30 Apr 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 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Logical in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!