数据清洗之 csv文件读写

快来打我* 2023-07-24 11:47 67阅读 0赞

# csv文件读写 #

*  pandas内置了10多种数据源读取函数，常见的就是CSV和EXCEL
 *  使用read\_csv方式读取。结果为dataframe格式
 *  在读取csv文件时，文件名称尽量是英文
 *  参数较多，可以自行控制，但很多时候用默认参数
 *  读取csv时，注意编码，常用编码为utf-8、gbk、gbk2312和gb18030等
 *  使用to\_csv方法快速保存

import numpy as np
    import pandas as pd
    import os

os.getcwd()

'D:\\Jupyter\\notebook\\Python数据清洗实战\\数据清洗之文件读写'

os.chdir('D:\\Jupyter\\notebook\\Python数据清洗实战\\数据')

baby = pd.read_csv('sam_tianchi_mum_baby.csv', encoding='utf-8')

baby.head(5)

<table> 
 <thead> 
  <tr> 
   <th></th> 
   <th>user_id</th> 
   <th>birthday</th> 
   <th>gender</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <th>0</th> 
   <td>2757</td> 
   <td>20130311</td> 
   <td>1</td> 
  </tr> 
  <tr> 
   <th>1</th> 
   <td>415971</td> 
   <td>20121111</td> 
   <td>0</td> 
  </tr> 
  <tr> 
   <th>2</th> 
   <td>1372572</td> 
   <td>20120130</td> 
   <td>1</td> 
  </tr> 
  <tr> 
   <th>3</th> 
   <td>10339332</td> 
   <td>20110910</td> 
   <td>0</td> 
  </tr> 
  <tr> 
   <th>4</th> 
   <td>10642245</td> 
   <td>20130213</td> 
   <td>0</td> 
  </tr> 
 </tbody> 
</table>

order = pd.read_csv('meal_order_info.csv', encoding='gbk', dtype={ 'info_id':str, 'emp_id':str})

order.info()

<class 'pandas.core.frame.DataFrame'>
    RangeIndex: 945 entries, 0 to 944
    Data columns (total 21 columns):
    info_id               945 non-null object
    emp_id                945 non-null object
    number_consumers      945 non-null int64
    mode                  0 non-null float64
    dining_table_id       945 non-null int64
    dining_table_name     945 non-null int64
    expenditure           945 non-null int64
    dishes_count          945 non-null int64
    accounts_payable      945 non-null int64
    use_start_time        945 non-null object
    check_closed          0 non-null float64
    lock_time             936 non-null object
    cashier_id            0 non-null float64
    pc_id                 0 non-null float64
    order_number          0 non-null float64
    org_id                945 non-null int64
    print_doc_bill_num    0 non-null float64
    lock_table_info       0 non-null float64
    order_status          945 non-null int64
    phone                 945 non-null int64
    name                  945 non-null object
    dtypes: float64(7), int64(9), object(5)
    memory usage: 155.1+ KB

order.head(5)

<table> 
 <thead> 
  <tr> 
   <th></th> 
   <th>info_id</th> 
   <th>emp_id</th> 
   <th>number_consumers</th> 
   <th>mode</th> 
   <th>dining_table_id</th> 
   <th>dining_table_name</th> 
   <th>expenditure</th> 
   <th>dishes_count</th> 
   <th>accounts_payable</th> 
   <th>use_start_time</th> 
   <th>...</th> 
   <th>lock_time</th> 
   <th>cashier_id</th> 
   <th>pc_id</th> 
   <th>order_number</th> 
   <th>org_id</th> 
   <th>print_doc_bill_num</th> 
   <th>lock_table_info</th> 
   <th>order_status</th> 
   <th>phone</th> 
   <th>name</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <th>0</th> 
   <td>417</td> 
   <td>1442</td> 
   <td>4</td> 
   <td>NaN</td> 
   <td>1501</td> 
   <td>1022</td> 
   <td>165</td> 
   <td>5</td> 
   <td>165</td> 
   <td>2016/8/1 11:05:36</td> 
   <td>...</td> 
   <td>2016/8/1 11:11:46</td> 
   <td>NaN</td> 
   <td>NaN</td> 
   <td>NaN</td> 
   <td>330</td> 
   <td>NaN</td> 
   <td>NaN</td> 
   <td>1</td> 
   <td>18688880641</td> 
   <td>苗宇怡</td> 
  </tr> 
  <tr> 
   <th>1</th> 
   <td>301</td> 
   <td>1095</td> 
   <td>3</td> 
   <td>NaN</td> 
   <td>1430</td> 
   <td>1031</td> 
   <td>321</td> 
   <td>6</td> 
   <td>321</td> 
   <td>2016/8/1 11:15:57</td> 
   <td>...</td> 
   <td>2016/8/1 11:31:55</td> 
   <td>NaN</td> 
   <td>NaN</td> 
   <td>NaN</td> 
   <td>328</td> 
   <td>NaN</td> 
   <td>NaN</td> 
   <td>1</td> 
   <td>18688880174</td> 
   <td>赵颖</td> 
  </tr> 
  <tr> 
   <th>2</th> 
   <td>413</td> 
   <td>1147</td> 
   <td>6</td> 
   <td>NaN</td> 
   <td>1488</td> 
   <td>1009</td> 
   <td>854</td> 
   <td>15</td> 
   <td>854</td> 
   <td>2016/8/1 12:42:52</td> 
   <td>...</td> 
   <td>2016/8/1 12:54:37</td> 
   <td>NaN</td> 
   <td>NaN</td> 
   <td>NaN</td> 
   <td>330</td> 
   <td>NaN</td> 
   <td>NaN</td> 
   <td>1</td> 
   <td>18688880276</td> 
   <td>徐毅凡</td> 
  </tr> 
  <tr> 
   <th>3</th> 
   <td>415</td> 
   <td>1166</td> 
   <td>4</td> 
   <td>NaN</td> 
   <td>1502</td> 
   <td>1023</td> 
   <td>466</td> 
   <td>10</td> 
   <td>466</td> 
   <td>2016/8/1 12:51:38</td> 
   <td>...</td> 
   <td>2016/8/1 13:08:20</td> 
   <td>NaN</td> 
   <td>NaN</td> 
   <td>NaN</td> 
   <td>330</td> 
   <td>NaN</td> 
   <td>NaN</td> 
   <td>1</td> 
   <td>18688880231</td> 
   <td>张大鹏</td> 
  </tr> 
  <tr> 
   <th>4</th> 
   <td>392</td> 
   <td>1094</td> 
   <td>10</td> 
   <td>NaN</td> 
   <td>1499</td> 
   <td>1020</td> 
   <td>704</td> 
   <td>24</td> 
   <td>704</td> 
   <td>2016/8/1 12:58:44</td> 
   <td>...</td> 
   <td>2016/8/1 13:07:16</td> 
   <td>NaN</td> 
   <td>NaN</td> 
   <td>NaN</td> 
   <td>330</td> 
   <td>NaN</td> 
   <td>NaN</td> 
   <td>1</td> 
   <td>18688880173</td> 
   <td>孙熙凯</td> 
  </tr> 
 </tbody> 
</table>

5 rows × 21 columns

baby = pd.read_csv('baby_trade_history.csv', nrows=100)  # 读取前100行

baby

100 rows × 7 columns

# 数据显示不完全怎么办，可自行设置显示行数和列数
    pd.set_option('display.max_columns',20)  # 最多显示20列

pd.set_option('display.max_rows',100)  # 最多显示100行

baby

<table> 
 <thead> 
  <tr> 
   <th></th> 
   <th>user_id</th> 
   <th>auction_id</th> 
   <th>cat_id</th> 
   <th>cat1</th> 
   <th>property</th> 
   <th>buy_mount</th> 
   <th>day</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <th>0</th> 
   <td>786295544</td> 
   <td>41098319944</td> 
   <td>50014866</td> 
   <td>50022520</td> 
   <td>21458:86755362;13023209:3593274;10984217:21985...</td> 
   <td>2</td> 
   <td>20140919</td> 
  </tr> 
  <tr> 
   <th>1</th> 
   <td>532110457</td> 
   <td>17916191097</td> 
   <td>50011993</td> 
   <td>28</td> 
   <td>21458:11399317;1628862:3251296;21475:137325;16...</td> 
   <td>1</td> 
   <td>20131011</td> 
  </tr> 
  <tr> 
   <th>2</th> 
   <td>249013725</td> 
   <td>21896936223</td> 
   <td>50012461</td> 
   <td>50014815</td> 
   <td>21458:30992;1628665:92012;1628665:3233938;1628...</td> 
   <td>1</td> 
   <td>20131011</td> 
  </tr> 
  <tr> 
   <th>3</th> 
   <td>917056007</td> 
   <td>12515996043</td> 
   <td>50018831</td> 
   <td>50014815</td> 
   <td>21458:15841995;21956:3494076;27000458:59723383...</td> 
   <td>2</td> 
   <td>20141023</td> 
  </tr> 
  <tr> 
   <th>4</th> 
   <td>444069173</td> 
   <td>20487688075</td> 
   <td>50013636</td> 
   <td>50008168</td> 
   <td>21458:30992;13658074:3323064;1628665:3233941;1...</td> 
   <td>1</td> 
   <td>20141103</td> 
  </tr> 
  <tr> 
   <th>5</th> 
   <td>152298847</td> 
   <td>41840167463</td> 
   <td>121394024</td> 
   <td>50008168</td> 
   <td>21458:3408353;13023209:727117752;22009:2741771...</td> 
   <td>1</td> 
   <td>20141103</td> 
  </tr> 
  <tr> 
   <th>6</th> 
   <td>513441334</td> 
   <td>19909384116</td> 
   <td>50010557</td> 
   <td>50008168</td> 
   <td>25935:21991;1628665:29784;22019:34731;22019:20...</td> 
   <td>1</td> 
   <td>20121212</td> 
  </tr> 
  <tr> 
   <th>7</th> 
   <td>297411659</td> 
   <td>13540124907</td> 
   <td>50010542</td> 
   <td>50008168</td> 
   <td>21458:60020529;25935:31381;1633959:27247291;16...</td> 
   <td>1</td> 
   <td>20121212</td> 
  </tr> 
  <tr> 
   <th>8</th> 
   <td>82830661</td> 
   <td>19948600790</td> 
   <td>50013874</td> 
   <td>28</td> 
   <td>21458:11580;21475:137325</td> 
   <td>1</td> 
   <td>20121101</td> 
  </tr> 
  <tr> 
   <th>9</th> 
   <td>475046636</td> 
   <td>10368360710</td> 
   <td>203527</td> 
   <td>28</td> 
   <td>22724:40168;22729:40278;21458:21817;2770200:24...</td> 
   <td>1</td> 
   <td>20121101</td> 
  </tr> 
  <tr> 
   <th>10</th> 
   <td>734147966</td> 
   <td>15307958346</td> 
   <td>50018202</td> 
   <td>38</td> 
   <td>21458:3270827;7361532:28710594;7397093:7536994...</td> 
   <td>2</td> 
   <td>20121101</td> 
  </tr> 
  <tr> 
   <th>11</th> 
   <td>68547330</td> 
   <td>21162876126</td> 
   <td>50012365</td> 
   <td>122650008</td> 
   <td>1628665:3233941;1628665:3233942;1628665:323393...</td> 
   <td>1</td> 
   <td>20121123</td> 
  </tr> 
  <tr> 
   <th>12</th> 
   <td>697081418</td> 
   <td>15898050723</td> 
   <td>50013636</td> 
   <td>50008168</td> 
   <td>21458:19726868;1633959:179425852;13836282:1290...</td> 
   <td>1</td> 
   <td>20121123</td> 
  </tr> 
  <tr> 
   <th>13</th> 
   <td>377550424</td> 
   <td>15771663914</td> 
   <td>50015841</td> 
   <td>28</td> 
   <td>1628665:3233941;1628665:3233942;3914866:11580;...</td> 
   <td>1</td> 
   <td>20121123</td> 
  </tr> 
  <tr> 
   <th>14</th> 
   <td>88313935</td> 
   <td>22532727492</td> 
   <td>50013711</td> 
   <td>50008168</td> 
   <td>1628665:3233941;1628665:3233942;22019:3340598;...</td> 
   <td>1</td> 
   <td>20131005</td> 
  </tr> 
  <tr> 
   <th>15</th> 
   <td>25918750</td> 
   <td>16078389250</td> 
   <td>50012359</td> 
   <td>122650008</td> 
   <td>21458:3405407;1633959:6186201;1628366:32799;81...</td> 
   <td>1</td> 
   <td>20131005</td> 
  </tr> 
  <tr> 
   <th>16</th> 
   <td>350288528</td> 
   <td>35086271572</td> 
   <td>50010544</td> 
   <td>50008168</td> 
   <td>21458:61813;25935:21991;1628665:3233938;162866...</td> 
   <td>1</td> 
   <td>20131129</td> 
  </tr> 
  <tr> 
   <th>17</th> 
   <td>348090113</td> 
   <td>17436967558</td> 
   <td>50009540</td> 
   <td>50014815</td> 
   <td>21458:21910;3110425:30696849;2191928:75373546;...</td> 
   <td>1</td> 
   <td>20131129</td> 
  </tr> 
  <tr> 
   <th>18</th> 
   <td>1635282280</td> 
   <td>36153356431</td> 
   <td>50013207</td> 
   <td>50008168</td> 
   <td>1628665:29784;1628665:29799;2904342:31004;2201...</td> 
   <td>1</td> 
   <td>20131129</td> 
  </tr> 
  <tr> 
   <th>19</th> 
   <td>530850018</td> 
   <td>22058239899</td> 
   <td>50024147</td> 
   <td>28</td> 
   <td>21458:205007542;43307470:5543413;2339128:62147...</td> 
   <td>1</td> 
   <td>20140210</td> 
  </tr> 
  <tr> 
   <th>20</th> 
   <td>749507708</td> 
   <td>19171641742</td> 
   <td>50018860</td> 
   <td>28</td> 
   <td>21458:3602856;1628665:3233941;1628665:3233942;...</td> 
   <td>1</td> 
   <td>20140210</td> 
  </tr> 
  <tr> 
   <th>21</th> 
   <td>201088567</td> 
   <td>38564176352</td> 
   <td>50013207</td> 
   <td>50008168</td> 
   <td>1628665:3233941;1628665:3233942;1628665:323393...</td> 
   <td>1</td> 
   <td>20140502</td> 
  </tr> 
  <tr> 
   <th>22</th> 
   <td>469517728</td> 
   <td>8232924597</td> 
   <td>211122</td> 
   <td>38</td> 
   <td>21458:21782;36786:42781029;13023102:6999219;22...</td> 
   <td>6</td> 
   <td>20140502</td> 
  </tr> 
  <tr> 
   <th>23</th> 
   <td>691367866</td> 
   <td>17712372914</td> 
   <td>121434042</td> 
   <td>50014815</td> 
   <td>21458:49341152;8021059:5525523;6851452:1398669...</td> 
   <td>1</td> 
   <td>20140804</td> 
  </tr> 
  <tr> 
   <th>24</th> 
   <td>77193822</td> 
   <td>35537441586</td> 
   <td>50006520</td> 
   <td>50014815</td> 
   <td>22277:6262384;21458:30992;1628665:3233941;1628...</td> 
   <td>2</td> 
   <td>20140804</td> 
  </tr> 
  <tr> 
   <th>25</th> 
   <td>605678021</td> 
   <td>15502618744</td> 
   <td>50010555</td> 
   <td>50008168</td> 
   <td>25935:31381;1628665:3233941;1628665:3233942;16...</td> 
   <td>1</td> 
   <td>20130226</td> 
  </tr> 
  <tr> 
   <th>26</th> 
   <td>47702620</td> 
   <td>26481508332</td> 
   <td>121412034</td> 
   <td>50014815</td> 
   <td>21458:49341152;11057903:4036007;130475532:7537...</td> 
   <td>1</td> 
   <td>20140918</td> 
  </tr> 
  <tr> 
   <th>27</th> 
   <td>763560371</td> 
   <td>40945285800</td> 
   <td>50012365</td> 
   <td>122650008</td> 
   <td>21458:30992;1628665:3233939;22007:30338;22007:...</td> 
   <td>1</td> 
   <td>20150201</td> 
  </tr> 
  <tr> 
   <th>28</th> 
   <td>408028533</td> 
   <td>35838498718</td> 
   <td>50012442</td> 
   <td>50008168</td> 
   <td>21458:3596449;6811831:3446999;13023209:3446999...</td> 
   <td>1</td> 
   <td>20141009</td> 
  </tr> 
  <tr> 
   <th>29</th> 
   <td>53566371</td> 
   <td>27177784760</td> 
   <td>121394024</td> 
   <td>50008168</td> 
   <td>21458:42090508;1628665:3233941;1628665:3233942...</td> 
   <td>1</td> 
   <td>20141009</td> 
  </tr> 
  <tr> 
   <th>30</th> 
   <td>69873877</td> 
   <td>40133707057</td> 
   <td>50010555</td> 
   <td>50008168</td> 
   <td>21458:30992;25935:31381;1628665:3233941;162866...</td> 
   <td>1</td> 
   <td>20141017</td> 
  </tr> 
  <tr> 
   <th>31</th> 
   <td>1609185254</td> 
   <td>42001753405</td> 
   <td>121394024</td> 
   <td>50008168</td> 
   <td>21458:30992;1628665:3233942;1628665:3233936;16...</td> 
   <td>1</td> 
   <td>20141228</td> 
  </tr> 
  <tr> 
   <th>32</th> 
   <td>1746148145</td> 
   <td>41181827319</td> 
   <td>50012365</td> 
   <td>122650008</td> 
   <td>21458:621749996;13023209:12868;122217803:30916...</td> 
   <td>1</td> 
   <td>20141228</td> 
  </tr> 
  <tr> 
   <th>33</th> 
   <td>256475742</td> 
   <td>39059292616</td> 
   <td>121452056</td> 
   <td>50008168</td> 
   <td>1628665:29784;1628665:29782;122217801:50793479...</td> 
   <td>1</td> 
   <td>20140711</td> 
  </tr> 
  <tr> 
   <th>34</th> 
   <td>405194127</td> 
   <td>15462429573</td> 
   <td>50007011</td> 
   <td>50008168</td> 
   <td>21458:35624651;1633959:7320293;1628665:3233941...</td> 
   <td>1</td> 
   <td>20120819</td> 
  </tr> 
  <tr> 
   <th>35</th> 
   <td>938309370</td> 
   <td>14149079479</td> 
   <td>50023669</td> 
   <td>28</td> 
   <td>21458:4204704;11820090:105550653;11644036:2861...</td> 
   <td>1</td> 
   <td>20120819</td> 
  </tr> 
  <tr> 
   <th>36</th> 
   <td>84258337</td> 
   <td>14653740604</td> 
   <td>50016704</td> 
   <td>50022520</td> 
   <td>21458:3394654;5261331:4377028;1633959:4377028;...</td> 
   <td>1</td> 
   <td>20120819</td> 
  </tr> 
  <tr> 
   <th>37</th> 
   <td>14466144</td> 
   <td>17610665576</td> 
   <td>50011993</td> 
   <td>28</td> 
   <td>21458:104000;21475:137325</td> 
   <td>1</td> 
   <td>20130327</td> 
  </tr> 
  <tr> 
   <th>38</th> 
   <td>177724549</td> 
   <td>14228645401</td> 
   <td>50018824</td> 
   <td>38</td> 
   <td>21475:108284;6933666:96059;33595:16453265;2145...</td> 
   <td>1</td> 
   <td>20130327</td> 
  </tr> 
  <tr> 
   <th>39</th> 
   <td>727823869</td> 
   <td>39674261411</td> 
   <td>121466023</td> 
   <td>50008168</td> 
   <td>21458:14332755;1628665:3233941;1628665:3233942...</td> 
   <td>2</td> 
   <td>20140813</td> 
  </tr> 
  <tr> 
   <th>40</th> 
   <td>659020106</td> 
   <td>40484992676</td> 
   <td>50011993</td> 
   <td>28</td> 
   <td>21458:16162126;13023209:10551667;122218042:605...</td> 
   <td>1</td> 
   <td>20140813</td> 
  </tr> 
  <tr> 
   <th>41</th> 
   <td>46277938</td> 
   <td>40070019945</td> 
   <td>50006602</td> 
   <td>50008168</td> 
   <td>21458:29563;10984217:21985;13023209:3488197;21...</td> 
   <td>1</td> 
   <td>20140813</td> 
  </tr> 
  <tr> 
   <th>42</th> 
   <td>827091396</td> 
   <td>18678458676</td> 
   <td>50010566</td> 
   <td>50008168</td> 
   <td>21458:46906;13023209:158751187;25935:21991;320...</td> 
   <td>1</td> 
   <td>20140911</td> 
  </tr> 
  <tr> 
   <th>43</th> 
   <td>18100946</td> 
   <td>38451267766</td> 
   <td>121540027</td> 
   <td>28</td> 
   <td>21458:215485914;125501489:19689726;11945782:78...</td> 
   <td>1</td> 
   <td>20140911</td> 
  </tr> 
  <tr> 
   <th>44</th> 
   <td>725813399</td> 
   <td>40519533209</td> 
   <td>50010544</td> 
   <td>50008168</td> 
   <td>21458:32270;13023209:669513679;25935:21991;162...</td> 
   <td>1</td> 
   <td>20140911</td> 
  </tr> 
  <tr> 
   <th>45</th> 
   <td>1054852159</td> 
   <td>19063296909</td> 
   <td>50006235</td> 
   <td>50008168</td> 
   <td>1628665:3233941;21475:17106236;21475:17106365;...</td> 
   <td>2</td> 
   <td>20140703</td> 
  </tr> 
  <tr> 
   <th>46</th> 
   <td>262519726</td> 
   <td>19051046285</td> 
   <td>121398041</td> 
   <td>28</td> 
   <td>11666049:40203;21458:3961150;17472269:13302841...</td> 
   <td>1</td> 
   <td>20140703</td> 
  </tr> 
  <tr> 
   <th>47</th> 
   <td>87207277</td> 
   <td>14234909614</td> 
   <td>121470030</td> 
   <td>50014815</td> 
   <td>21458:30992;1628665:3233941;1628665:3233942;16...</td> 
   <td>1</td> 
   <td>20140703</td> 
  </tr> 
  <tr> 
   <th>48</th> 
   <td>1053602675</td> 
   <td>20252281923</td> 
   <td>50013636</td> 
   <td>50008168</td> 
   <td>21458:216724052;1628665:29798;1628665:29796;25...</td> 
   <td>1</td> 
   <td>20140220</td> 
  </tr> 
  <tr> 
   <th>49</th> 
   <td>103125167</td> 
   <td>18426669796</td> 
   <td>50018438</td> 
   <td>50014815</td> 
   <td>21458:46896;1628665:3233941;1628665:3233942;21...</td> 
   <td>16</td> 
   <td>20140220</td> 
  </tr> 
  <tr> 
   <th>50</th> 
   <td>886492677</td> 
   <td>19668429343</td> 
   <td>50016704</td> 
   <td>50022520</td> 
   <td>21458:3662539;5261385:3351834;13023209:3351834...</td> 
   <td>1</td> 
   <td>20140628</td> 
  </tr> 
  <tr> 
   <th>51</th> 
   <td>115566151</td> 
   <td>14778919435</td> 
   <td>50013187</td> 
   <td>28</td> 
   <td>1628665:3233938;1628665:29796;1628665:133527;1...</td> 
   <td>1</td> 
   <td>20140113</td> 
  </tr> 
  <tr> 
   <th>52</th> 
   <td>55544814</td> 
   <td>4917672059</td> 
   <td>50015727</td> 
   <td>50014815</td> 
   <td>21458:4540492;1633959:58840623;7107736:3227806...</td> 
   <td>4</td> 
   <td>20131106</td> 
  </tr> 
  <tr> 
   <th>53</th> 
   <td>1714403831</td> 
   <td>22443564698</td> 
   <td>50014129</td> 
   <td>28</td> 
   <td>21458:57737100;12102318:7282254;11945782:78135...</td> 
   <td>1</td> 
   <td>20131106</td> 
  </tr> 
  <tr> 
   <th>54</th> 
   <td>723975586</td> 
   <td>8096949165</td> 
   <td>50023591</td> 
   <td>50022520</td> 
   <td>1628665:3233941;1628665:29798;1628665:3233938;...</td> 
   <td>1</td> 
   <td>20120911</td> 
  </tr> 
  <tr> 
   <th>55</th> 
   <td>66451440</td> 
   <td>9258781845</td> 
   <td>50013636</td> 
   <td>50008168</td> 
   <td>21458:11580;1628665:3233941;1628665:3233936;16...</td> 
   <td>1</td> 
   <td>20120911</td> 
  </tr> 
  <tr> 
   <th>56</th> 
   <td>47342027</td> 
   <td>14066344263</td> 
   <td>50013636</td> 
   <td>50008168</td> 
   <td>21458:21599;13585028:3416646;1628665:3233942;1...</td> 
   <td>1</td> 
   <td>20120911</td> 
  </tr> 
  <tr> 
   <th>57</th> 
   <td>354780072</td> 
   <td>17851314047</td> 
   <td>50016704</td> 
   <td>50022520</td> 
   <td>21458:3394654;5261331:237777686;1633959:237777...</td> 
   <td>1</td> 
   <td>20130725</td> 
  </tr> 
  <tr> 
   <th>58</th> 
   <td>1660751516</td> 
   <td>12496195786</td> 
   <td>50024842</td> 
   <td>50008168</td> 
   <td>1628665:3233941;25935:21991;13545112:43704;135...</td> 
   <td>2</td> 
   <td>20130725</td> 
  </tr> 
  <tr> 
   <th>59</th> 
   <td>1981826945</td> 
   <td>40793811285</td> 
   <td>50010538</td> 
   <td>50008168</td> 
   <td>21458:37946447;13023209:696649694;25935:21990;...</td> 
   <td>1</td> 
   <td>20150108</td> 
  </tr> 
  <tr> 
   <th>60</th> 
   <td>61003275</td> 
   <td>36738992094</td> 
   <td>50018831</td> 
   <td>50014815</td> 
   <td>21458:21899;7255169:61035386;7368343:7327107;1...</td> 
   <td>3</td> 
   <td>20150108</td> 
  </tr> 
  <tr> 
   <th>61</th> 
   <td>848482116</td> 
   <td>42178787281</td> 
   <td>50010538</td> 
   <td>50008168</td> 
   <td>21458:31340;13023209:25581424;25935:21991;1628...</td> 
   <td>1</td> 
   <td>20150119</td> 
  </tr> 
  <tr> 
   <th>62</th> 
   <td>405014302</td> 
   <td>43130926446</td> 
   <td>50012777</td> 
   <td>50014815</td> 
   <td>21458:46850;1628665:3233939;1628665:92012;1628...</td> 
   <td>1</td> 
   <td>20150119</td> 
  </tr> 
  <tr> 
   <th>63</th> 
   <td>806635728</td> 
   <td>38985185626</td> 
   <td>121452056</td> 
   <td>50008168</td> 
   <td>21458:9398440;1628665:29784;122217801:3265977;...</td> 
   <td>1</td> 
   <td>20140615</td> 
  </tr> 
  <tr> 
   <th>64</th> 
   <td>1970876909</td> 
   <td>20197969079</td> 
   <td>211122</td> 
   <td>38</td> 
   <td>6940834:29865;21458:3270820;1629375:3253542;32...</td> 
   <td>1</td> 
   <td>20141017</td> 
  </tr> 
  <tr> 
   <th>65</th> 
   <td>605724983</td> 
   <td>19747694834</td> 
   <td>50006520</td> 
   <td>50014815</td> 
   <td>21458:30992</td> 
   <td>12</td> 
   <td>20141017</td> 
  </tr> 
  <tr> 
   <th>66</th> 
   <td>2148300507</td> 
   <td>41694440222</td> 
   <td>50010549</td> 
   <td>50008168</td> 
   <td>115931637:36783070;25935:21990;1628665:3233941...</td> 
   <td>1</td> 
   <td>20141112</td> 
  </tr> 
  <tr> 
   <th>67</th> 
   <td>818595619</td> 
   <td>36424612559</td> 
   <td>50013636</td> 
   <td>50008168</td> 
   <td>21458:99466824;13023209:3334185;120198214:3334...</td> 
   <td>1</td> 
   <td>20141112</td> 
  </tr> 
  <tr> 
   <th>68</th> 
   <td>442760655</td> 
   <td>36611607467</td> 
   <td>50016704</td> 
   <td>50022520</td> 
   <td>1628665:3233941;1628665:29790;1628665:3233936;...</td> 
   <td>1</td> 
   <td>20141228</td> 
  </tr> 
  <tr> 
   <th>69</th> 
   <td>1026379511</td> 
   <td>19281156237</td> 
   <td>50012375</td> 
   <td>50022520</td> 
   <td>21458:3731805;1633959:14267607;2397831:1656121...</td> 
   <td>1</td> 
   <td>20120905</td> 
  </tr> 
  <tr> 
   <th>70</th> 
   <td>113473924</td> 
   <td>15486726090</td> 
   <td>50014250</td> 
   <td>28</td> 
   <td>21458:30015090;1633959:43047819;1627584:28619;...</td> 
   <td>1</td> 
   <td>20120905</td> 
  </tr> 
  <tr> 
   <th>71</th> 
   <td>117887031</td> 
   <td>10956228163</td> 
   <td>50012451</td> 
   <td>50008168</td> 
   <td>1628665:3233942;1628665:3233938;1628665:133527...</td> 
   <td>1</td> 
   <td>20120905</td> 
  </tr> 
  <tr> 
   <th>72</th> 
   <td>468447138</td> 
   <td>15550398428</td> 
   <td>50012442</td> 
   <td>50008168</td> 
   <td>1628665:3233936;1628665:29782;1627349:11462;16...</td> 
   <td>1</td> 
   <td>20120905</td> 
  </tr> 
  <tr> 
   <th>73</th> 
   <td>348660284</td> 
   <td>10896577394</td> 
   <td>50014250</td> 
   <td>28</td> 
   <td>1628665:29796;1628665:108579;1627584:11580;116...</td> 
   <td>1</td> 
   <td>20130525</td> 
  </tr> 
  <tr> 
   <th>74</th> 
   <td>129642523</td> 
   <td>23703880889</td> 
   <td>50012364</td> 
   <td>122650008</td> 
   <td>1628665:3233941;1628665:3233942;1628665:323393...</td> 
   <td>1</td> 
   <td>20130525</td> 
  </tr> 
  <tr> 
   <th>75</th> 
   <td>1708761610</td> 
   <td>18560026026</td> 
   <td>50016030</td> 
   <td>50008168</td> 
   <td>21458:30992;1628665:3233941;25935:31381;22019:...</td> 
   <td>1</td> 
   <td>20130525</td> 
  </tr> 
  <tr> 
   <th>76</th> 
   <td>908702885</td> 
   <td>15515470575</td> 
   <td>50023591</td> 
   <td>50022520</td> 
   <td>21458:26309047;1633959:39224289;11697064:31617...</td> 
   <td>1</td> 
   <td>20130312</td> 
  </tr> 
  <tr> 
   <th>77</th> 
   <td>151915451</td> 
   <td>17305821144</td> 
   <td>211122</td> 
   <td>38</td> 
   <td>21458:21782;36786:42781029;6933553:3313169;130...</td> 
   <td>2</td> 
   <td>20140104</td> 
  </tr> 
  <tr> 
   <th>78</th> 
   <td>745002413</td> 
   <td>36815797313</td> 
   <td>50023645</td> 
   <td>28</td> 
   <td>1628665:82340;21475:11488282;21458:56610575;49...</td> 
   <td>1</td> 
   <td>20140104</td> 
  </tr> 
  <tr> 
   <th>79</th> 
   <td>1046234868</td> 
   <td>10799142007</td> 
   <td>50023591</td> 
   <td>50022520</td> 
   <td>1628665:3233941;1628665:3233942;1628665:323393...</td> 
   <td>1</td> 
   <td>20121109</td> 
  </tr> 
  <tr> 
   <th>80</th> 
   <td>810362779</td> 
   <td>16933071954</td> 
   <td>50010545</td> 
   <td>50008168</td> 
   <td>21458:57430303;1633959:2477;23150:45030;25935:...</td> 
   <td>1</td> 
   <td>20121109</td> 
  </tr> 
  <tr> 
   <th>81</th> 
   <td>119784861</td> 
   <td>20796936076</td> 
   <td>50140021</td> 
   <td>50008168</td> 
   <td>21458:120325094;22019:2026;22019:34731;22019:3...</td> 
   <td>1</td> 
   <td>20121129</td> 
  </tr> 
  <tr> 
   <th>82</th> 
   <td>277184180</td> 
   <td>17734463967</td> 
   <td>50010555</td> 
   <td>50008168</td> 
   <td>21458:3482405;8697758:26247633;1633959:3336498...</td> 
   <td>1</td> 
   <td>20121129</td> 
  </tr> 
  <tr> 
   <th>83</th> 
   <td>648623529</td> 
   <td>16590447919</td> 
   <td>50010555</td> 
   <td>50008168</td> 
   <td>25935:31381;1628665:3233938;1628665:82340;1628...</td> 
   <td>1</td> 
   <td>20121129</td> 
  </tr> 
  <tr> 
   <th>84</th> 
   <td>1085938456</td> 
   <td>39009925227</td> 
   <td>50013207</td> 
   <td>50008168</td> 
   <td>21458:21599;1628665:3233941;22121:30905;122217...</td> 
   <td>1</td> 
   <td>20140827</td> 
  </tr> 
  <tr> 
   <th>85</th> 
   <td>2214390386</td> 
   <td>40856437695</td> 
   <td>50013636</td> 
   <td>50008168</td> 
   <td>21458:216724052;36628385:3480253;1628665:32339...</td> 
   <td>1</td> 
   <td>20140827</td> 
  </tr> 
  <tr> 
   <th>86</th> 
   <td>346816172</td> 
   <td>37132432638</td> 
   <td>50013636</td> 
   <td>50008168</td> 
   <td>21458:216291676;13023209:3583497;35044286:1242...</td> 
   <td>1</td> 
   <td>20140827</td> 
  </tr> 
  <tr> 
   <th>87</th> 
   <td>654037597</td> 
   <td>13775864723</td> 
   <td>50011993</td> 
   <td>28</td> 
   <td>21458:116116655;1633959:3276615;1628862:50276;...</td> 
   <td>1</td> 
   <td>20130513</td> 
  </tr> 
  <tr> 
   <th>88</th> 
   <td>1667892062</td> 
   <td>16767168507</td> 
   <td>50158020</td> 
   <td>50008168</td> 
   <td>1628665:131622;13395135:21671;22019:3340598;22...</td> 
   <td>1</td> 
   <td>20130513</td> 
  </tr> 
  <tr> 
   <th>89</th> 
   <td>277279277</td> 
   <td>18024521052</td> 
   <td>211122</td> 
   <td>38</td> 
   <td>21458:33516;33480:3238774;2653417:7353464;3359...</td> 
   <td>12</td> 
   <td>20130513</td> 
  </tr> 
  <tr> 
   <th>90</th> 
   <td>1721792494</td> 
   <td>36154660054</td> 
   <td>50008845</td> 
   <td>28</td> 
   <td>21458:3400531;5653832:7049425;13023209:7049425...</td> 
   <td>1</td> 
   <td>20140312</td> 
  </tr> 
  <tr> 
   <th>91</th> 
   <td>56549058</td> 
   <td>26930668292</td> 
   <td>50003700</td> 
   <td>28</td> 
   <td>21458:3351431;123273479:31526;1628665:3233941;...</td> 
   <td>1</td> 
   <td>20140312</td> 
  </tr> 
  <tr> 
   <th>92</th> 
   <td>696527486</td> 
   <td>37269469522</td> 
   <td>50011993</td> 
   <td>28</td> 
   <td>21458:118564374;13023209:547499553;122218042:3...</td> 
   <td>1</td> 
   <td>20140718</td> 
  </tr> 
  <tr> 
   <th>93</th> 
   <td>643153890</td> 
   <td>17954181229</td> 
   <td>50003700</td> 
   <td>28</td> 
   <td>123273479:41376163;21475:135183931;1628665:323...</td> 
   <td>1</td> 
   <td>20140718</td> 
  </tr> 
  <tr> 
   <th>94</th> 
   <td>362976947</td> 
   <td>39676108316</td> 
   <td>50012375</td> 
   <td>50022520</td> 
   <td>1628665:29796;1628665:29799;21967:29774;21967:...</td> 
   <td>1</td> 
   <td>20140718</td> 
  </tr> 
  <tr> 
   <th>95</th> 
   <td>1097191176</td> 
   <td>39095838474</td> 
   <td>50015841</td> 
   <td>28</td> 
   <td>1628665:3233941;1628665:3233942;1628665:323393...</td> 
   <td>1</td> 
   <td>20150203</td> 
  </tr> 
  <tr> 
   <th>96</th> 
   <td>1107237181</td> 
   <td>18979330679</td> 
   <td>121382039</td> 
   <td>50014815</td> 
   <td>21458:3371752;13023209:282182273;21475:3779036...</td> 
   <td>1</td> 
   <td>20150203</td> 
  </tr> 
  <tr> 
   <th>97</th> 
   <td>1090130969</td> 
   <td>38473204110</td> 
   <td>50012364</td> 
   <td>122650008</td> 
   <td>21458:30992;1628665:29778;1628665:29799;22007:...</td> 
   <td>1</td> 
   <td>20140604</td> 
  </tr> 
  <tr> 
   <th>98</th> 
   <td>373997473</td> 
   <td>24898348642</td> 
   <td>50012442</td> 
   <td>50008168</td> 
   <td>1628665:29778;22009:29800;122217965:3227750;12...</td> 
   <td>1</td> 
   <td>20140604</td> 
  </tr> 
  <tr> 
   <th>99</th> 
   <td>59135448</td> 
   <td>20494104463</td> 
   <td>50012375</td> 
   <td>50022520</td> 
   <td>21458:7902780;13023209:43969797;2397831:165611...</td> 
   <td>1</td> 
   <td>20140929</td> 
  </tr> 
 </tbody> 
</table>

os.getcwd()

'D:\\Jupyter\\notebook\\Python数据清洗实战\\数据'

# 保存csv文件
    # index=False 表示索引行不写入csv文件
    baby.to_csv('a1.csv', encoding='utf-8', index=False)