encode special characters python for csv output

Question

How can I get csv.writer.writerow to output á or è and other special characters along the same lines u, n....etc?

I am getting an error UnicodeEncodeError: 'ascii' codec can't encode character u'\xed' in position 37: ordinal not in range(128)

Have tried some of the suggestions in this article with no avail

rowPrinter = []

while x < y:
     print "Data in at Line " + str(x + 1)
     rowPrinter.append([a[x], b[x], c[x]]])
     x = x + 1

x = 0

writer = csv.writer(outcsv, delimiter=',', quotechar='|', quoting=csv.QUOTE_MINIMAL, lineterminator='\n')
writer.writerow(['a', 'b', 'c'])
while x < y:
    print rowPrinter[x]
    writer.writerow(rowPrinter[x])

Padraic Cunningham · Accepted Answer · 2016-04-18 15:11:46Z

0

You need to encode all the data that you are trying to write:

writer.writerow([sub.encode("utf-8") for sub in rowPrinter[x]])

If you have a mixture of data:

writer.writerow([sub.encode("utf-8")  if isinstance(sub, basestring) else sub for sub in rowPrinter[x]])

edited Apr 18, 2016 at 15:11

answered Apr 18, 2016 at 15:00

Padraic Cunningham

181k30 gold badges264 silver badges327 bronze badges

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

4 Comments

Lucas Crostarosa Over a year ago

AttributeError: 'int' object has no attribute 'encode'

Padraic Cunningham Over a year ago

@LucasCrostarosa, so you have a mixture of strings and ints?

Lucas Crostarosa Over a year ago

yea, for example a is an int, b is a timestamp, and c is a string

Padraic Cunningham Over a year ago

Then the edit will work, you only want to encode the strings

Collectives™ on Stack Overflow

encode special characters python for csv output

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related