自從我嘗試在 python 中作業以來已經有一段時間了
我有這個資料框,其中列太多,無法命名
last/first location job department
smith john Vancouver A1 servers
rogers steve Toronto A2 eng
Rogers Dave Toronto A4 HR
如何洗掉最后一列/第一列中的大寫字母并將最后一列/第一列拆分為“”?
目標
last first location job department
smith john Vancouver A1 servers
rogers steve Toronto A2 eng
rogers dave Toronto A4 HR
uj5u.com熱心網友回復:
IIUC,您可以使用str.lowerand str.split:
df[['last', 'first']] = (df.pop('last/first')
.str.lower()
.str.split(n=1, expand=True)
)
輸出:
location job department last first
0 Vancouver A1 servers smith john
1 Toronto A2 eng rogers steve
2 Toronto A4 HR rogers dave
轉載請註明出處,本文鏈接:https://www.uj5u.com/caozuo/443619.html
