Python Parse CSV Correctly

by

You should use the csv module:

import csv
reader = csv.reader(['1997,Ford,E350,"Super, luxurious truck"'], skipinitialspace=True)
for r in reader:
    print r

output:

['1997', 'Ford', 'E350', 'Super, luxurious truck']

More Related Contents:

  1. sort csv by column
  2. Simple CSV to XML Conversion – Python
  3. Parsing a pipe-delimited file in Python
  4. create a loop inside a loop in python
  5. How to insert a space delimited text file into mysql using Python? [closed]
  6. How do I parse a string to a float or int?
  7. Extracting an attribute value with beautifulsoup
  8. How to use Stanford Parser in NLTK using Python
  9. Writing a pandas DataFrame to CSV file
  10. How to write to a CSV line by line?
  11. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  12. Equation parsing in Python
  13. Python/Json:Expecting property name enclosed in double quotes
  14. Extracting a URL in Python
  15. sscanf in Python
  16. Save results to csv file with Python
  17. Using numpy.genfromtxt to read a csv file with strings containing commas
  18. Split string on commas but ignore commas within double-quotes?
  19. Read CSV file with comma within fields in Python
  20. How to keep leading zeros in a column when reading CSV with Pandas?
  21. Writing Python lists to columns in csv
  22. Reading rows from a CSV file in Python
  23. Math Expression Evaluation
  24. CSV new-line character seen in unquoted field error
  25. Read CSV into a dataFrame with varying row lengths using Pandas
  26. How do you replace all the occurrences of a certain character in a string?
  27. Easiest way to read csv files with multiprocessing in Pandas
  28. json reading error json.decoder.JSONDecodeError: Invalid \escape
  29. pandas read csv with extra commas in column
  30. Python: Writing Nested Dictionary to CSV

Leave a Comment