Removing the first line of CSV file

Question

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

@jfs: How could this question be a duplicate of one that was asked _after_ it was? — martineau, Mar 27 '19 at 14:41

Padraic Cunningham · Accepted Answer · 2019-03-28T20:44:51.830

27

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)

edited Mar 28 '19 at 20:44

answered May 12 '14 at 17:54

Padraic Cunningham

176,452
29
245
321

score 1 · Answer 2 · answered May 12 '14 at 17:51

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 anyone's reading this now, it's `next(read)` now – chung Jan 28 '22 at 21:52 — chung, Jan 28 '22 at 21:52

score 1 · Answer 3 · edited May 23 '17 at 12:02

1

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.

edited May 23 '17 at 12:02

Community

1
1

answered Jan 11 '17 at 03:45

Yep_It's_Me

4,494
4
43
66

1

In Python3 you can call `next(f)` instead. – vaer-k Jan 25 '17 at 22:54
@vrjr why is `next(f)` better than `f.readline()`? – Yep_It's_Me Jan 30 '17 at 00:06
I don't know that it's better, and I didn't claim that. But you said that py3 file line objects dont have a next method, which is true, but you didn't mention that they added the next function and that it could be used instead. – vaer-k Jan 30 '17 at 00:17
Good point. I've updated my answer to include that. Thanks :) – Yep_It's_Me Jan 30 '17 at 03:12
`readline` does the job – Yuchen May 15 '17 at 21:17

score 0 · Answer 4 · answered May 12 '14 at 17:48

0

Are you opening it and re-saving it with the same name?

Otherwise, you could read it in without reading in the first line and writing to a new file without that line.

answered May 12 '14 at 17:48

mauve

2,707
1
20
34

loopbackbee · Answer 5 · 2014-05-12T17:50:48.827

-1

edited May 12 '14 at 17:50

answered May 12 '14 at 17:45

loopbackbee

21,962
10
62
97

As an additional hint, files get read in as iterables, and you can use `next(name_of_iterable)` to get through one iteration. – Adam Smith May 12 '14 at 17:48
@squiguy: The `csv` module should not be needed here except in the rare case that the header row has embedded newlines that need to be parsed. – Steven Rumbalski May 12 '14 at 17:54

Removing the first line of CSV file

5 Answers5

Linked