How do I split a line by commas, but ignore commas within quotes Python [duplicate]

by

If you want to read lines from a CSV file, use Python’s csv module from the standard library, which will handle the quoted comma separated values.

Example

# cat test.py
import csv
with open('some.csv') as f:
    reader = csv.reader(f)
    for row in reader:
        print(row)

# cat some.csv
"114111","Planes,Trains,and Automobiles","50","BOOK"

# python test.py

['114111', 'Planes,Trains,and Automobiles', '50', 'BOOK']
[]

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. Inline CSV File Editing with Python
  14. What does ‘killed’ mean when processing a huge CSV with Python, which suddenly stops?
  15. How to *actually* read CSV data in TensorFlow?
  16. Deleting rows with Python in a CSV file
  17. pyqt – populating QTableWidget with csv data
  18. Use python requests to download CSV
  19. Pandas read_csv dtype leading zeros
  20. pandas.read_csv from string or package data
  21. CSV reader behavior with None and empty string
  22. pandas read csv with extra commas in column
  23. Converting a csv file into a list of tuples with python
  24. ValueError: not enough values to unpack (expected 11, got 1)
  25. how to specify the datetime format in read_csv
  26. How to upload a CSV file in FastAPI and convert it into JSON?
  27. Convert nested JSON to CSV file in Python
  28. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  29. ValueError: x and y must be the same size
  30. Python: Writing Nested Dictionary to CSV

Leave a Comment