Write a list into csv in python

Question

I want to write a list into a csv file in python. This is a subset of my input list.

rows= ([u'Feng Ming', u'Cao', u'China Samsung Telecom', u'Beijing', u'', u'CHINA'], 
    [u'Naftali', u'Chayat', u'Alvarion Ltd.', u'Tel Aviv', u'', u'ISRAEL'],
    [u'R\xe9mi', u'Chayer', u'Harris Corporation', u'Dollard-Des-Ormeaux', u'PQ', u'CANADA'])

However, when I am using the code

with open("output.csv", "wb") as f:
    writer = csv.writer(f)
    writer.writerows(rows)

Its showing error because of the character "R\xe9mi". Any lead to solve this problem will be appreciated. Thanks

Are you using Python 2.x?

Rory Daulton
– Rory Daulton

2017-08-05 12:07:15 +00:00
Commented Aug 5, 2017 at 12:07 — Rory Daulton
– Rory Daulton, Commented Aug 5, 2017 at 12:07

Md. Rezwanul Haque · Accepted Answer · 2017-08-05 11:49:52Z

1

You have to add import unicodecsv as csv to do this task.

import unicodecsv as csv
rows= [u'Feng Ming', u'Cao', u'China Samsung Telecom', u'Beijing', u'', u'CHINA'], [u'Naftali', u'Chayat', u'Alvarion Ltd.', u'Tel Aviv', u'', u'ISRAEL'], [u'R\xe9mi', u'Chayer', u'Harris Corporation', u'Dollard-Des-Ormeaux', u'PQ', u'CANADA']

with open("output.csv", "wb") as f:
    writer = csv.writer(f)
    writer.writerows(rows)

output.csv :

Feng Ming,Cao,China Samsung Telecom,Beijing,,CHINA
Naftali,Chayat,Alvarion Ltd.,Tel Aviv,,ISRAEL
Rémi,Chayer,Harris Corporation,Dollard-Des-Ormeaux,PQ,CANADA

answered Aug 5, 2017 at 11:49

Md. Rezwanul Haque

2,9487 gold badges35 silver badges49 bronze badges

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

Comments

Ricardo · Accepted Answer · 2017-08-05 11:37:08Z

0

Just use unicodecsv

pip install unicodecsv

import unicodecsv as csv
# Your code

edited Aug 5, 2017 at 11:37

answered Aug 5, 2017 at 11:27

Ricardo

5975 silver badges16 bronze badges

Collectives™ on Stack Overflow

Write a list into csv in python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related