Read CSV file with comma within fields in Python

by

The Python csv module actually does support quoted fields, even by default. Your problem here is that Python by default does not skip the space, so you need to use skipinitialspace=True.

>>> s = StringIO.StringIO('1, "text1,text2", "text3, text4", a, b, c')
>>> list(csv.reader(s, skipinitialspace=True))
[['1', 'text1,text2', 'text3, text4', 'a', 'b', 'c']]

More Related Contents:

  1. How do I create a python code that distinguishes between the capital of a state and the state that the capital has?
  2. How do I read a large csv file with pandas?
  3. How to add pandas data to an existing csv file?
  4. How to ignore the first line of data when processing CSV data?
  5. Create a .csv file with values from a Python list
  6. Change specific value in CSV file via Python
  7. TypeError: a bytes-like object is required, not ‘str’ in python and CSV
  8. _csv.Error: field larger than field limit (131072)
  9. Pandas split column into multiple columns by comma
  10. Remove file after Flask serves it
  11. General Unicode/UTF-8 support for csv files in Python 2.6
  12. Convert commas decimal separators to dots within a Dataframe
  13. Read data from CSV file and transform from string to correct data-type, including a list-of-integer column
  14. Inline CSV File Editing with Python
  15. Python Pandas read_csv skip rows but keep header
  16. Python : Compare two csv files and print out differences
  17. Pandas – Strip white space
  18. Loading UTF-8 file in Python 3 using numpy.genfromtxt
  19. Filter string data based on its string length
  20. Why is pandas.to_datetime slow for non standard time format such as ‘2014/12/31’
  21. UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x96 in position 35: invalid start byte
  22. Simple CSV to XML Conversion – Python
  23. csv.writer writing each character of word in separate column/cell
  24. Pandas ParserError EOF character when reading multiple csv files to HDF5
  25. Python Pandas – Read csv file containing multiple tables
  26. Is there a way to speed up handling large CSVs and dataframes in python?
  27. Pandas read_csv dtype read all columns but few as string
  28. csv: writer.writerows() splitting my string inputs
  29. How can I stop Python’s csv.DictWriter.writerows from adding empty lines between rows in Windows?
  30. How to convert csv to json in python?

Leave a Comment