How do I put lines into a list from CSV using python

Question

I am new to Python (coming from PHP background) and I have a hard time figuring out how do I put each line of CSV into a list. I wrote this:

import csv
data=[]
reader = csv.reader(open("file.csv", "r"), delimiter=',')
for line in reader:
   if "DEFAULT" not in line:
      data+=line

print(data)

But when I print out data, I see that it's treated as one string. I want a list. I want to be able to loop and append every line that does not have "DEFAULT" in a given line. Then write to a new file.

that works as well... should have put it in answer. :/

netrox
– netrox

2013-09-17 21:40:32 +00:00
Commented Sep 17, 2013 at 21:40 — netrox
– netrox, Commented Sep 17, 2013 at 21:40

Peter Varo · Accepted Answer · 2013-09-12 16:37:19Z

1

How about this?

import csv

reader = csv.reader(open("file.csv", "r"), delimiter=',')
print([line for line in reader if 'DEFAULT' not in line])

or if it's easier to understand:

import csv

reader = csv.reader(open("file.csv", "r"), delimiter=',')
data = [line for line in reader if 'DEFAULT' not in line]
print(data)

and of course the ultimate one-liner:

import csv
print([l for l in csv.reader(open("file.csv"), delimiter=',') if 'DEFAULT' not in l])

answered Sep 12, 2013 at 16:37

Peter Varo

12.4k7 gold badges60 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I put lines into a list from CSV using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related