How to parse tsv file with python?

Just use the csv module. It knows about all the possible corner cases in CSV files like new lines in quoted fields. And it can delimit on tabs.

with open("file.tsv") as fd:
    rd = csv.reader(fd, delimiter="\t", quotechar='"')
    for row in rd:
        print(row)

will correctly output:

['111', '222', '333', 'aaa']
['444', '555', '666', 'bb\nb']

Related Posts:

  1. Python Pandas Error tokenizing data
  2. python csv2libsvm.py: AttributeError: ‘_csv.reader’ object has no attribute ‘next’
  3. TypeError: list indices must be integers or slices, not str
  4. IndexError: too many indices for array
  5. IndexError: too many indices for array
  6. Writing a pandas DataFrame to CSV file
  7. Writing a pandas DataFrame to CSV file
  8. IndexError: too many indices for array
  9. ValueError : I/O operation on closed file
  10. Pandas: ValueError: cannot convert float NaN to integer
  11. csv.Error: iterator should return strings, not bytes
  12. Python – Reading and writing csv files with utf-8 encoding
  13. Python Error io.UnsupportedOperation: not readable
  14. load csv into 2D matrix with numpy for plotting
  15. Dump a NumPy array into a csv file
  16. (unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape
  17. Is there a way to include commas in CSV columns without breaking the formatting?
  18. How to load a tsv file into a Pandas DataFrame?
  19. Difference between writerow() and writerows() methods of Python csv module
  20. Create a .csv file with values from a Python list
  21. Convert XML to CSV file
  22. TypeError: list indices must be integers or slices, not str
  23. Convert from CSV to array in Python
  24. ValueError: cannot index with vector containing NA / NaN values
  25. (unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape
  26. Creating a dictionary from a csv file?
  27. Python import csv to list
  28. ValueError: x and y must be the same size
  29. OSError: Initializing from file failed on csv in Pandas
  30. append new row to old csv file python
  31. “extra data after last expected column” while trying to import a csv file into postgresql
  32. Writing a dictionary to a csv file with one line for every ‘key: value’
  33. Python CSV error: line contains NULL byte
  34. In Java, what is the “char” for a tab and how do I pass through a “Charset”?
  35. Python CSV Error: sequence expected
  36. AttributeError: ‘float’ object has no attribute ‘split’4
  37. How to add pandas data to an existing csv file?
  38. convert csv file to list of dictionaries
  39. _csv.Error: field larger than field limit (131072)
  40. CSV new-line character seen in unquoted field error
  41. Writing Python lists to columns in csv
  42. Error in Reading a csv file in pandas[CParserError: Error tokenizing data. C error: Buffer overflow caught – possible malformed input file.]
  43. How to read a CSV file from a URL with Python?
  44. How to import a csv-file into a data array?
  45. WordPress.com Stats stats_get_csv with custom field?
  46. How to import .csv file with descriptions to a gallery in media?
  47. Updating Custom Posts via CSV Import
  48. CSV import stopped working when I upgraded to WP 3.5.2
  49. How to add to the PYTHONPATH in Windows, so it finds my modules/packages?
  50. FileNotFoundError: [WinError 2] The system cannot find the file specified:
  51. Remove all whitespace in a string
  52. What is a “method” in Python?
  53. How to generate all permutations of a list?
  54. Is there a Python equivalent to Ruby’s string interpolation?
  55. Python Progress Bar
  56. Most efficient way to find mode in numpy array
  57. Python error “ImportError: No module named”
  58. How to groupby based on two columns in pandas?
  59. Creating a basic auto clicker in python
  60. What’s the difference between torch.stack() and torch.cat() functions?
  61. How to print to stderr in Python?
  62. proper name for python * operator?
  63. How to do superscripts and subscripts in Jupyter Notebook?
  64. How do I unload (reload) a Python module?
  65. How to exit a loop in Python?
  66. What does axis in pandas mean?
  67. What do >> and << mean in Python?
  68. How to parse a CSV file using PHP
  69. Dynamically growing a python array when assigning to it
  70. “OverflowError: Python int too large to convert to C long” on windows but not mac
  71. Can’t compare naive and aware datetime.now() <= challenge.datetime_end
  72. List of zeros in python
  73. How to remove an element from a list by index
  74. How to add title to subplots in Matplotlib
  75. ‘pip3’ is not recognized as an internal or external command, operable program or batch file
  76. Apply function to each element of a list
  77. print variable and a string in python
  78. can’t remove python pip
  79. AttributeError: ‘list’ object has no attribute ‘replace’ when trying to remove character
  80. ValueError: unsupported pickle protocol: 3, python2 pickle can not load the file dumped by python 3 pickle?
  81. Relative paths in Python
  82. Convert bytes to int?
  83. SQLAlchemy ORDER BY DESCENDING?
  84. ValueError: unsupported pickle protocol: 3, python2 pickle can not load the file dumped by python 3 pickle?
  85. Relative paths in Python
  86. AttributeError(“‘str’ object has no attribute ‘read'”)
  87. Python: count repeated elements in the list
  88. Is there a “do … until” in Python?
  89. Printing variables in Python 3.4
  90. Histogram plotting “AttributeError: max must be larger than min in range parameter.”
  91. Python TypeError: non-empty format string passed to object.__format__
  92. AttributeError: ‘Series’ object has no attribute ‘reshape’
  93. Repeated “Kernel died, restarting” forever
  94. How to clear Tkinter Canvas?
  95. Python official installer missing python27.dll
  96. TypeError: ‘range’ object does not support item assignment
  97. Convert string to variable name in python
  98. Python-like list comprehension in Java
  99. Syntax highlighting in vim for python
  100. How to fetch csv file and show in shortcode

Leave a Comment