usecols选取指定列rename修改列名round指定有效位数

来源:互联网 发布:顶级域名证书合法吗 编辑:程序博客网 时间:2024/06/07 17:49
"""Created on Tue May  9 20:35:45 2017usecols选取指定列rename 修改列名round 指定有效位数@author: PC"""import pandas as pddata=pd.read_csv(r"D:\datasource\taxi_gps\TaxiRes_2015-05-18.csv",header=None,usecols=[1,2,3,6,7,8])data=data.rename(columns={1:"start_time",2:"start_lon",3:"start_lat",6:"end_time",7:"end_lon",8:"end_lat"})data=data.round({'start_lon': 6, 'start_lat': 6, 'end_lon': 6,'end_lat': 6})data.to_csv(r"D:\datasource\taxi_gps\TaxiGPS_20150518.csv")

0 0