1 回答

TA貢獻1847條經驗 獲得超7個贊
嘗試使用get_dummies:
df['Genre'] = df['Genre'].str.split('|')
dfx = pd.get_dummies(pd.DataFrame(df['Genre'].tolist()).stack()).sum(level=0)
df = pd.concat([df, dfx], axis=1).drop(columns=['Genre'])
print(df)
Artist Id Blues Hip-Hop Jazz Pop Rap Rb Rock Trap
0 Bob 1 1 0 1 0 0 0 0 0
1 Fred 2 0 0 1 0 0 0 1 0
2 Jeff 3 0 1 0 0 1 0 0 1
3 Amy 4 0 0 1 1 0 0 1 0
4 Mary 5 0 1 1 0 0 1 0 0
詳細解釋看這里 -> Pandas column of lists to separate columns
添加回答
舉報