Borrar filtros
Borrar filtros

How to count number of times 2 elements appear together in a table

3 visualizaciones (últimos 30 días)
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

Respuesta aceptada

Scott MacKenzie
Scott MacKenzie el 30 de Abr. de 2021
Editada: Scott MacKenzie el 30 de Abr. de 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));

Más respuestas (0)

Categorías

Más información sobre Tables en Help Center y File Exchange.

Productos


Versión

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by