CODEWITHSUNDEEP
pythoncsvquotation-marks
David
David

Reputation: 605

Python CSV : field containing quotation mark at the beginning

I am trying to read a CSV file containing a line like following:

test,"test,"test,test,test,test

There is a problem with the quotation marks (There are six fields, but they are retrieved as five fields, as "test,"test is read as a single field).

I have tried modifying the entry as follows, but I still can't retrieve the quotation mark:

test,""test,""test,test,test,test  # quotation marks disappear when the entry is read.

test,\"test,\"test,test,test,test  # backslashes are also retrieved; escaping doesn't seem to work.

I'm reading CSV file this way:

info_source = csv.reader(open('.info.csv'), skipinitialspace=True)

for row in ling_info_source:
    data = row[1].strip()
    ...

Upvotes: 3

Views: 5063

Answers (2)

Janne Karila
Janne Karila

Reputation: 25197

You can add the quoting=csv.QUOTE_NONE argument to reader()

Upvotes: 3

Sven Marnach
Sven Marnach

Reputation: 601451

By default " is the quoting character of Python's csv module. Use

csv.reader(open('.info.csv'), skipinitialspace=True, quotechar=None)

to disable this default. The example you gave will result in the record

['test', '"test', '"test', 'test', 'test', 'test']

Upvotes: 3

Related Questions