Python data analysis notes in Panda (2)

1 separate mobile phone numbers into carriers, regions and number segments

1  frompandas import read_csv;2 3DF = Read_csv ("H:\\pythoncode\\4.6\\data.csv");4 5              6 #转换成字符数据 easy to use slice7df['Tel'] = df['Tel'].astype (str);8 9 #字符的抽取: Extracting new Columns Slice (START,STOP) based on the location of the beginning and end of the known column dataTen #运营商 OneBands = df['Tel'].str.slice (0,3); A #地区 -Areas = df['Tel'].str.slice (3,7); - #号码段 theNums = df['Tel'].str.slice (7, One);

2 look at each table below

(1) DF

(2) Bands

(3) Area

(4) Nums

Python data analysis notes in Panda (2)