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

Question

Michael Boyle 2021-4-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/818355-how-to-count-number-of-times-2-elements-appear-together-in-a-table

编辑： Scott MacKenzie 2021-4-30

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Scott MacKenzie 2021-4-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/818355-how-to-count-number-of-times-2-elements-appear-together-in-a-table#answer_688915

编辑：Scott MacKenzie 2021-4-30

在 MATLAB Online 中打开

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));