python csv module error

Question

When I use Pythons csv module, it shows me

"delimiter" must be an 1-character string"

My code is like this

 sep = ","
 srcdata = cStringIO.StringIO(wdata[1])
 data = csv.reader(srcdata, delimiter=sep)

wdata[1] is a string source.

How do I fix this problem?

You should accept Mahmoud's answer -- click on the checkmark near it. — Ethan Furman
– Ethan Furman, Commented Nov 21, 2011 at 21:16

Mahmoud Abdelkader · Accepted Answer · 2011-04-11 18:06:53Z

31

You most likely have from __future__ import unicode_literals at the top of your module or you are using python 3.x+ You need to do something like this:

sep=b","  # notice the b before the "
srcdata=cStringIO.StringIO(wdata[1])
data = csv.reader(srcdata,delimiter=sep)

This tells Python that you want to represent "," as a byte string instead of a unicode literal.

answered Apr 11, 2011 at 18:06

Mahmoud Abdelkader

25.3k5 gold badges44 silver badges57 bronze badges

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

1 Comment

sbaechler Over a year ago

I now get TypeError: delimiter must be set under Python 3.3 and "delimiter" must be a 1-character string under Python 3.2.

Collectives™ on Stack Overflow

python csv module error

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related