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:
next(f) # skip header line
for line in f:
f1.write(line)
For anyone else caught up this error:
AttributeError: '_io.TextIOWrapper' object has no attribute 'next' python
In Python3 a text file object doesn't have a next()
function.
So you can't call f.next()
.
Instead you should use f.readline()
as specified in this answer.
Or you can use the built-in next(f)
which @vrjr mentioned in the comment, and is shown in this answer.
This is what I do when I want to skip reading the first line of a CSV.
All that has to be done is call the next()
function of the CSV object, in this case - read
, and then the pointer to the reader will be on the next line.
import csv
try:
read = csv.reader(f)
read.next() # Skip the first 'title' row.
for r in read:
# Do something
finally:
# Close files and exit cleanly
f.close()
Hope this is pretty clean an simple for your purposes!
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With