I am using Python Pandas. I have got a column with a string and I would like to have the crossing between the columns.
E.g I have got the following input
1: Andi
2: Andi, Cindy
3: Thomas, Cindy
4: Cindy, Thomas
And I would like to have the following output:
Hence, the combination of Andi and Thomas does not appear in the data, but Cindy and Thomas appear twice.
Andi Thomas Cindy
Andi 1 0 1
Thomas 0 1 2
Cindy 1 2 1
Has somebody any idea how I could handle this? That would be really great!
Many thanks and regards,
Andi