CODEWITHSUNDEEP
pythoncsvquotesdouble-quotes
samsamara
samsamara

Reputation: 4750

Using python csv writer without quotations

I'm trying to write a list of strings like below to a file separated by the given delimiter.

res = [u'123', u'hello world']

When I try splitting by TAB like below it gives me the correctly formatted string. 

writer = csv.writer(sys.stdout, delimiter="\t")
writer.writerow(res)

gives --> 123   hello world

But when I try to split by space using delimiter=" ", it gives me the space but with quotation marks like below. 

123 "hello world"

How do I remove quotation marks. So that when I use space as the delimiter I should get 123 hello world.

EIDT: when I try using the escapechar it doesn't make any double quotes. But everywhere in my testdata it appears a space, it makes it double.

Upvotes: 20

Views: 46304

Answers (4)

Noaha
Noaha

Reputation: 21

What worked for me was using a regular writer, not the csv.writer, and simply use your delimiter in between columns ('\t' in my case):

with open(target_path, 'w', encoding='utf-8') as fd:
     # some code iterating over a pandas daftaframe called mydf     
     # create a string out of column 0, '\t' (tab delimiter) and column 1:
     output = mydf.loc[i][0] + '\t' + mydf.loc[i][1] +'\n'
     # write that output string (line) to the file in every iteration
     fd.write(output)

It might not be the "correct" way but it definitely kept the original lines in my project, which included many strings and quotations.

Upvotes: 2

John Mee
John Mee

Reputation: 52333

Do you need the csv lib? Just join the strings...

>>> res = [u'123', u'hello'] 
>>> print res
[u'123', u'hello']
>>> print " ".join(res)
123 hello

Upvotes: 4

Peter DeGlopper
Peter DeGlopper

Reputation: 37364

Quoting behavior is controlled by the various quoting arguments provided to the writer (or set on the Dialect object if you prefer to do things that way). The default setting is QUOTE_MINIMAL, which will not produce the behavior you're describing unless a value contains your delimiter character, quote character, or line terminator character. Doublecheck your test data - [u'123', u'hello'] won't produce what you describe, but [u'123', u' hello'] would.

You can specify QUOTE_NONE if you're sure that's the behavior you want, in which case it'll either try to escape instances of your delimiter character if you set an escape character, or raise an exception if you don't.

Upvotes: 14

Dair
Dair

Reputation: 16240

You can set the csv.writer to quote nothing with quoting=csv.QUOTE_NONE for example:

import csv
with open('eggs.csv', 'wb') as csvfile:
    spamwriter = csv.writer(csvfile, delimiter=' ',
                            escapechar=' ', quoting=csv.QUOTE_NONE)
    spamwriter.writerow(['Spam'] * 5 + ['Baked Beans'])
    spamwriter.writerow(['Spam', 'Lovely Spam', 'Wonderful Spam'])

Produces:

Spam Spam Spam Spam Spam Baked  Beans
Spam Lovely  Spam Wonderful  Spam

If you do QUOTING_NONE you also need and escape character.

Upvotes: 28

Related Questions