Possible Duplicate: When processing CSV data, how do I ignore the first line of data?
I am using python to open CSV file. I am using formula loop but I need to skip the first row because it has header.
So far I remember was something like this but it is missing something: I wonder if someone knows the code for what I am trying to do.
for row in kidfile:
if row.firstline = false: # <====== Something is missing here.
continue
if ......
There are many ways to skip the first line. In addition to those said by Bakuriu, I would add:
with open(filename, 'r') as f:
next(f)
for line in f:
and:
with open(filename,'r') as f:
lines = f.readlines()[1:]
The best way of doing this is skipping the header after passing the file object to the csv module:
with open('myfile.csv', 'r', newline='') as in_file:
reader = csv.reader(in_file)
# skip header
next(reader)
for row in reader:
# handle parsed row
This handles multiline CSV headers correctly.
Older answer:
Probably you want something like:
firstline = True
for row in kidfile:
if firstline: #skip first line
firstline = False
continue
# parse the line
An other way to achive the same result is calling readline before the loop:
kidfile.readline() # skip the first line
for row in kidfile:
#parse the line
next function is a much more concise approach.csvreader.next() Return the next row of the reader’s iterable object as a list, parsed according to the current dialect.
reader.__next__(), which should be called by using next(reader)
csv_data.__next__()for 3.x andcsv_data.next()for 2.x. More details are stackoverflow.com/a/63096202/10961238