Parsing a pipe-delimited file in Python

by

Use the ‘csv’ library.

First, register your dialect:

import csv
csv.register_dialect('piper', delimiter="|", quoting=csv.QUOTE_NONE)

Then, use your dialect on the file:

with open(myfile, "rb") as csvfile:
    for row in csv.DictReader(csvfile, dialect="piper"):
        print row['name']

More Related Contents:

  1. A simple maths operation on a CSV column using python [closed]
  2. How to add a new column to a CSV file?
  3. TypeError: a bytes-like object is required, not ‘str’ in python and CSV
  4. sort csv by column
  5. csv.Error: iterator should return strings, not bytes
  6. portable way to write csv file in python 2 or python 3
  7. Regular expression parsing a binary file?
  8. python pandas read_csv delimiter in column data
  9. Simple CSV to XML Conversion – Python
  10. pandas.read_csv from string or package data
  11. UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x8b in position 1: invalid start byte, while reading csv file in pandas
  12. Pandas ParserError EOF character when reading multiple csv files to HDF5
  13. Read .csv file from URL into Python 3.x – _csv.Error: iterator should return strings, not bytes (did you open the file in text mode?)
  14. Python 3 CSV file giving UnicodeDecodeError: ‘utf-8’ codec can’t decode byte error when I print
  15. How to write List of lists in csv file in python [duplicate]
  16. Python Parse CSV Correctly
  17. Python3: writing csv files
  18. create a loop inside a loop in python
  19. TypeError: Missing 1 required positional argument: ‘self’
  20. How to use Stanford Parser in NLTK using Python
  21. Writing a pandas DataFrame to CSV file
  22. Extracting a URL in Python
  23. Cleanest way to get last item from Python iterator
  24. How to Install and Use TkDnD with Python Tkinter on OSX?
  25. Showing all index values when using multiIndexing in Pandas
  26. CSV new-line character seen in unquoted field error
  27. How do you replace all the occurrences of a certain character in a string?
  28. UnicodeDecodeError in Python when reading a file, how to ignore the error and jump to the next line?
  29. eval fails in list comprehension [duplicate]
  30. Download YouTube video using Python to a certain directory

Leave a Comment