#字段抽取
from pandas import read_csv
ab=read_csv('D://Python projects//reference data//4.6//data.csv')
#将数字型转换成字符型
ab['tel']=ab['tel'].astype(str)
#运营商
bands=ab['tel'].str.slice(0,3)
#地区
areas=ab['tel'].str.slice(3,7)
#号码
nums=ab['tel'].str.slice(7,11)
#赋值回去
ab['bands']=bands
ab['areas']=areas
ab['nums']=nums
ab['nums']=ab['nums'].astype[float]
#字段拆分
from pandas import read_csv
ac=read_csv('D://Python projects//reference data//4.7//data.csv')
ad=ac['name'].str.split(' ',1,True)
ae=ac['name'].str.split(' ',1)
ad.columns=['Brand','Name']
#自定义函数转换
def convert_currency(var):
new_value=var.replace('2','0').replace('1','0')
return float(new_value)
abb=ab['nums'].apply(convert_currency)
#一行函数带过
ab['nums'].apply(lambda x:x.replace('1','7').replace('2','8')).astype("float")