“Line contains NULL byte” in CSV reader (Python)

by

I’ve solved a similar problem with an easier solution:

import codecs
csvReader = csv.reader(codecs.open('file.csv', 'rU', 'utf-16'))

The key was using the codecs module to open the file with the UTF-16 encoding, there are a lot more of encodings, check the documentation.

More Related Contents:

  1. create a loop inside a loop in python
  2. Writing a pandas DataFrame to CSV file
  3. How to write to a CSV line by line?
  4. Python out of memory on large CSV file (numpy)
  5. Writing a dictionary to a csv file with one line for every ‘key: value’
  6. Creating a dictionary from a CSV file
  7. xls to csv converter
  8. Python 2 CSV writer produces wrong line terminator on Windows
  9. How to remove duplicates from a csv file
  10. pandas read_csv and filter columns with usecols
  11. import text to pandas with multiple delimiters
  12. Error: Unsupported format, or corrupt file: Expected BOF record
  13. portable way to write csv file in python 2 or python 3
  14. Streaming large training and test files into Tensorflow’s DNNClassifier
  15. How do you split reading a large csv file into evenly-sized chunks in Python?
  16. Python read csv – BOM embedded into the first key
  17. python pandas read_csv delimiter in column data
  18. How to skip the headers when processing a csv file using Python?
  19. Converting images to csv file in python
  20. convert csv file to list of dictionaries
  21. Why does CSV file contain a blank line in between each data line when outputting with Dictwriter in Python [duplicate]
  22. module ‘pandas’ has no attribute ‘read_csv
  23. Python CSV: Remove quotes from value
  24. Conditional row read of csv in pandas
  25. Load CSV to Pandas MultiIndex DataFrame
  26. How to count top 10 most common values in a dict in python
  27. Why is the Python CSV reader ignoring double-quoted fields?
  28. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?
  29. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path
  30. How Postgresql COPY TO STDIN With CSV do on conflic do update?

Leave a Comment