06.给字母排序 - Canvas2018

给字母排序

 1 import pandas as pd 
 2 #读取文件
 3 employees = pd.read_excel('Employees.xlsx',index_col='ID')
 4 df = employees['Full Name'].str.split(expand=True)
 5 # print(df)
 6 employees['First Name']=df[0]
 7 employees['Last Name']=df[0]
 8 print(employees)
 9 
10 #给字符串
11 import pandas as pd 
12 
13 employees = pd.read_excel('Employees.xlsx',index_col='ID')
14 df = employees['Full Name'].str.split(n=3,expand=True)   # n给字符串
15 # print(df)
16 employees['First Name']=df[0]
17 employees['Last Name']=df[1]
18 print(employees)
19 
20 #排序
21 import pandas as pd 
22 
23 employees = pd.read_excel('Employees.xlsx',index_col='ID')
24 df = employees['Full Name'].str.split(expand=True)
25 # print(df)
26 employees['First Name']=df[0]
27 employees['Last Name']=df[1].str.upper()   # upper 大写
28 print(employees)

posted on 2019-02-21 17:55 Canvas2018 阅读(128) 评论(0) 收藏举报