删除CSV文件的第一行 [英] Removing the first line of CSV file

查看:1674
本文介绍了删除CSV文件的第一行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

如何删除python中CSV文件的第一行,CSV文件的前几行是:

 域名,ItemID,拍卖类型,剩余时间,价格,出价,域年龄,交通,估价价
TICKETFINE.COM,134774365,投标,05/09 / (PDT),$ 100,0,0,0,$ 0
CREATINGMY.COM,134774390,投标,05/09/2014 08:00 AM(PDT),$ 500,0,0,0,$ 0
WPTHEMEHELP.COM,134774444,Bid,05/09/2014 08:00 AM(PDT),$ 45,1,0,0,$ 0
APK-ZIPPY.COM,134774445,Bid,05/09/2014 08:00 AM(PDT),$ 10,0,0,0,$ 0
FAMILYBUZZMARKETING.COM,134689583,投标,05/09/2014 08:00 AM(PDT),$ 90,0,0,0, $ 0
AMISRAGAS.COM,134689584,Bid,05/09/2014 08:00 AM(PDT),$ 35,0,0,0,$ 0
$ p>

解决方案

  b $ b with open(updated_test.csv,'w')as f1:
f.next()#skip header line
for line in f:
f1.write )


How would I remove the first line of a CSV file in python, the first few lines of my CSV file are:

Domain Name, ItemID, Auction Type, Time Left, Price, Bids, Domain Age, Traffic,ValuationPrice
TICKETFINE.COM,134774365,Bid,05/09/2014 08:00 AM (PDT),$100,0,0,0,$0
CREATINGMY.COM,134774390,Bid,05/09/2014 08:00 AM (PDT),$500,0,0,0,$0
WPTHEMEHELP.COM,134774444,Bid,05/09/2014 08:00 AM (PDT),$45,1,0,0,$0
APK-ZIPPY.COM,134774445,Bid,05/09/2014 08:00 AM (PDT),$10,0,0,0,$0
FAMILYBUZZMARKETING.COM,134689583,Bid,05/09/2014 08:00 AM (PDT),$90,0,0,0,$0
AMISRAGAS.COM,134689584,Bid,05/09/2014 08:00 AM (PDT),$35,0,0,0,$0

解决方案

with open("test.csv",'r') as f:
    with open("updated_test.csv",'w') as f1:
        f.next() # skip header line
        for line in f:
            f1.write(line)

这篇关于删除CSV文件的第一行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆