Ignore/skip first row of csv with filter

Question

Is it possible to ignore or skip the first row in a CSV file with filter?

filtered = filter(lambda p: celery == p[7],reader)
csv.writer(open(filename, 'w',newline=''), delimiter=',').writerows(filtered)

I'm trying to read and filter only the 7th row containing the word celery but because the filter keeps reading the header stuff it messes up the line under it.

                                                          Stuff                                                                                                   
Apple Pear Orange Cracker Honey Cheese Grape Bread Tomato Celery Lettuce Carrot
Apple Pear Orange Cracker Honey Cheese Grape Bread Tomato Celery Lettuce Carrot
Apple Pear Orange Cracker Honey Cheese Grape Bread Tomato Celery Lettuce Carrot

I think because it can't find celery it just cuts off the line under it?

ge Cracker Honey Cheese Grape Bread Tomato Celery Lettuce Carrot
Apple Pear Orange Cracker Honey Cheese Grape Bread Tomato Celery Lettuce Carrot
Apple Pear Orange Cracker Honey Cheese Grape Bread Tomato Celery Lettuce Carrot

score 1 · Accepted Answer · answered May 23 '16 at 18:36

1

Just add next before you construct filtered:

Retrieve the next item from the iterator by calling its next() method. If default is given, it is returned if the iterator is exhausted, otherwise StopIteration is raised.

Example:

next(reader, None) # skips a line - default set to None
filtered = filter(lambda p: celery == p[7],reader)

answered May 23 '16 at 18:36

Reut Sharabani

30,449
6
70
88

Thank you, how would I insert it into this? `reader =(csv.reader(open(r'{1}\{0}\{0}.csv'.format(man_year,queue)),delimiter=',')` – iOSecure May 23 '16 at 18:41
1

Just add `next(reader, None)` after you construct a reader to exhaust one line. – Reut Sharabani May 23 '16 at 18:42

Ignore/skip first row of csv with filter

1 Answers1