Python Transpose data and change to 0,1's

Question

I have some data in the following format, thousands of rows.

I want to transpose the data and also change the format to 1 and 0's

Name Codes
Dave DSFFS
Dave SDFDF
stu  SDFDS
stu  DSGDSG

I want to retain the Name column in row format, but have the codes column go into Column format instead and have 1 and 0's

Answer 1

pd.get_dummies() should help here.

df = pd.DataFrame({'Name': ['Dave','Dave','stu','stu'],
                   'Codes': ['DSFFS','SDFDF','SDFDS','DSGDSG']})
print(df)
    Codes  Name
0   DSFFS  Dave
1   SDFDF  Dave
2   SDFDS   stu
3  DSGDSG   stu

print(pd.get_dummies(df, columns=['Codes']))
   Name  Codes_DSFFS  Codes_DSGDSG  Codes_SDFDF  Codes_SDFDS
0  Dave            1             0            0            0
1  Dave            0             0            1            0
2   stu            0             0            0            1
3   stu            0             1            0            0

Answer 2

u can use df.transpose() in pandas!