把一列数据分割成两列

import pandas as pd
employees = pd.read_excel('D:/Temp/Employees.xlsx',index_col='ID')

df = employees['Full Name'].str.split(expand = True)  #expand 分成2列
employees['Firest Name'] =df[0]
employees['Last Name']=df[1].str.upper()  #大写
print(employees)

 

posted @ 2019-06-19 21:02  Inserence  阅读(454)  评论(0编辑  收藏  举报