Why is the Python CSV reader ignoring double-quoted fields?

by

If you look at the dialect that you’re using, you’ll notice that the excel dialect is
configured as follows:

class excel(Dialect):
    """Describe the usual properties of Excel-generated CSV files."""
    delimiter=","
    quotechar="""
    doublequote = True
    skipinitialspace = False
    lineterminator="\r\n"
    quoting = QUOTE_MINIMAL

Notice that skipinitialspace is set to False. Just pass that into your reader.
Oh and by the way, all the fields you’ve passed in are already the defaults when
using the excel dialect, which is the default dialect parameter passed to csv.reader

So, I would re-write your code like so:

>>> with open(inPath) as fp:
>>>     reader = csv.reader(fp, skipinitialspace=True)
>>>     for row in reader:
>>>         print row,
>>>         print len(row)
['hello', 'this is row 1', 'foo1'] 3
['hello', 'this is row 2', 'foo2'] 3
['goodbye', 'this, is row 3', 'foo3'] 3

More Related Contents:

  1. A simple maths operation on a CSV column using python [closed]
  2. How to write a python code which copies a unique column from an output file to a .csv file
  3. How can I convert JSON to CSV?
  4. Skip the headers when editing a csv file using Python
  5. How to add a new column to a CSV file?
  6. Skip rows during csv import pandas
  7. How to avoid Python/Pandas creating an index in a saved csv?
  8. datetime dtypes in pandas read_csv
  9. Python CSV error: line contains NULL byte
  10. How do I convert this list of dictionaries to a csv file?
  11. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  12. sort csv by column
  13. Compare two CSV files and search for similar items
  14. Pandas read csv file with float values results in weird rounding and decimal digits
  15. Why does csvwriter.writerow() put a comma after each character?
  16. How to delete columns in a CSV file?
  17. Precision lost while using read_csv in pandas
  18. Python Pandas: How to read only first n rows of CSV files in?
  19. Prevent pandas read_csv treating first row as header of column names
  20. Modify an existing Excel file using Openpyxl in Python
  21. How to avoid pandas creating an index in a saved csv
  22. Pythonically add header to a csv file
  23. Pandas – write Multiindex rows with to_csv
  24. How can I merge 200 CSV files in Python?
  25. How can I use io.StringIO() with the csv module?
  26. How to Pretty Print a CSV file in Python
  27. how to skip blank line while reading CSV file using python
  28. Python 3 CSV file giving UnicodeDecodeError: ‘utf-8’ codec can’t decode byte error when I print
  29. Plot NetworkX Graph from Adjacency Matrix in CSV file
  30. How can I stop Python’s csv.DictWriter.writerows from adding empty lines between rows in Windows?

Leave a Comment