[Python] Converting repeated data from column in unique row to form correct matrix [duplicate]

I have below data set

enter image description here

i want result like this in python

Output

I tried in excel . it can be done with UNIQUE function in excel but same is not working.

basically i want all unique column data in row and want to create office opening matrix.

Continue reading...