Python parse CSV ignoring comma with double-quotes

by

This should do:

lines=""'"AAA", "BBB", "Test, Test", "CCC"
           "111", "222, 333", "XXX", "YYY, ZZZ"'''.splitlines()
for l in  csv.reader(lines, quotechar=""", delimiter=",",
                     quoting=csv.QUOTE_ALL, skipinitialspace=True):
    print l
>>> ['AAA', 'BBB', 'Test, Test', 'CCC']
>>> ['111', '222, 333', 'XXX', 'YYY, ZZZ']

More Related Contents:

  1. Writing a Python list of lists to a csv file
  2. Reading a huge .csv file
  3. Skip the headers when editing a csv file using Python
  4. Read and Write CSV files including unicode with Python 2.7
  5. portable way to write csv file in python 2 or python 3
  6. Use Multiple Character Delimiter in Python Pandas read_csv
  7. How can I use io.StringIO() with the csv module?
  8. Python Pandas – Read csv file containing multiple tables
  9. How to count top 10 most common values in a dict in python
  10. Get data from Twitter using Tweepy and store in csv file
  11. Can you make that thats code run in python 2.7 from 3.5 [closed]
  12. Cannot find module cv2 when using OpenCV
  13. Unable to locate element of credit card number using selenium python
  14. Reading rows from a CSV file in Python
  15. Read file with timeout in Python
  16. Module imports and __init__.py
  17. Strip white spaces from CSV file
  18. python_2_unicode_compatible error
  19. What does backward-slash b do in Python?
  20. ‘frozenset’ object is not callable
  21. How to filter a DataFrame column of lists for those that contain a certain item
  22. Run process with realtime output to a Tkinter GUI
  23. How to display charts in Spyder
  24. How to add a new column to the beginning of the rows of a CSV file?
  25. The ‘pip==7.1.0’ distribution was not found and is required by the application
  26. What does the slice() function do in Python?
  27. Python Parse CSV Correctly
  28. start index at 1 for Pandas DataFrame
  29. Any way to get one process to have a write lock and others to just read on parallel?
  30. Google Search Web Scraping with Python

Leave a Comment