Dear All,
I'm looking for a solution for this issue:
I have a dataset with a set of 500 dummy variables for around 60.000 observation.
I need to create a symmetric matrix where for each row and column I have the dummy variables, and the intersection should give me the count of how many observations have both dummy equal to 1. Such like this:
Thank you for your help
I'm looking for a solution for this issue:
I have a dataset with a set of 500 dummy variables for around 60.000 observation.
I need to create a symmetric matrix where for each row and column I have the dummy variables, and the intersection should give me the count of how many observations have both dummy equal to 1. Such like this:
Dummy1 | Dummy2 | Dummy3 | |
Dummy1 | 0 | 4 | 6 |
Dummy2 | 4 | 0 | 2 |
Dummy3 | 6 | 2 | 0 |
Comment