Read and Write CSV files including unicode with Python 2.7

by

Another alternative:

Use the code from the unicodecsv package …

https://pypi.python.org/pypi/unicodecsv/

>>> import unicodecsv as csv
>>> from io import BytesIO
>>> f = BytesIO()
>>> w = csv.writer(f, encoding='utf-8')
>>> _ = w.writerow((u'é', u'ñ'))
>>> _ = f.seek(0)
>>> r = csv.reader(f, encoding='utf-8')
>>> next(r) == [u'é', u'ñ']
True

This module is API compatible with the STDLIB csv module.

More Related Contents:

  1. How can I use io.StringIO() with the csv module?
  2. UnicodeDecodeError when reading CSV file in Pandas with Python
  3. (unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape [duplicate]
  4. Writing a Python list of lists to a csv file
  5. Reading a huge .csv file
  6. How to remove \xa0 from string in Python?
  7. Skip the headers when editing a csv file using Python
  8. how to import csv data into django models
  9. Python parse CSV ignoring comma with double-quotes
  10. Python – ‘ascii’ codec can’t decode byte
  11. How to convert a string to utf-8 in Python
  12. General Unicode/UTF-8 support for csv files in Python 2.6
  13. How to read Unicode input and compare Unicode strings in Python?
  14. portable way to write csv file in python 2 or python 3
  15. Use Multiple Character Delimiter in Python Pandas read_csv
  16. Get unicode code point of a character using Python
  17. Python DictWriter writing UTF-8 encoded CSV files
  18. Error “(unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape” [duplicate]
  19. Why does ENcoding a string result in a DEcoding error (UnicodeDecodeError)?
  20. Python Pandas – Read csv file containing multiple tables
  21. Python returns length of 2 for single Unicode character string
  22. How to count top 10 most common values in a dict in python
  23. Get data from Twitter using Tweepy and store in csv file
  24. UnicodeDecodeError when reading CSV file in Pandas
  25. How do I install PyCrypto on Windows?
  26. Python 2 CSV writer produces wrong line terminator on Windows
  27. Changing the options of a OptionMenu when clicking a Button
  28. Checking fuzzy/approximate substring existing in a longer string, in Python?
  29. Python the same char not equals
  30. Read random lines from huge CSV file

Leave a Comment