Python read csv – BOM embedded into the first key

by

You have to tell open that this is UTF-8 with BOM. I know that works with io.open:

import io

.
.
.
inputFile = io.open("test.csv", "r", encoding='utf-8-sig')
.
.
.

And you have to open the file in text mode, “r” instead of “rb”.

More Related Contents:

  1. Merging two CSV files using Python
  2. A simple maths operation on a CSV column using python [closed]
  3. How to write a python code which copies a unique column from an output file to a .csv file
  4. Skip the headers when editing a csv file using Python
  5. How to add a new column to a CSV file?
  6. Skip rows during csv import pandas
  7. How to avoid Python/Pandas creating an index in a saved csv?
  8. Python CSV error: line contains NULL byte
  9. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  10. sort csv by column
  11. Compare two CSV files and search for similar items
  12. Pandas read csv file with float values results in weird rounding and decimal digits
  13. Why does csvwriter.writerow() put a comma after each character?
  14. How to delete columns in a CSV file?
  15. Precision lost while using read_csv in pandas
  16. Python Pandas: How to read only first n rows of CSV files in?
  17. Modify an existing Excel file using Openpyxl in Python
  18. Writing List of Strings to Excel CSV File in Python
  19. How can I get dictionary key as variable directly in Python (not by searching from value)?
  20. 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?)
  21. Find all CSV files in a directory using Python
  22. Calculate summary statistics of columns in dataframe
  23. Extract csv file specific columns to list in Python
  24. Python – re-ordering columns in a csv
  25. ValueError: not enough values to unpack (expected 11, got 1)
  26. how to specify the datetime format in read_csv
  27. UnicodeDecodeError when reading CSV file in Pandas
  28. How to upload a CSV file in FastAPI and convert it into JSON?
  29. Convert nested JSON to CSV file in Python
  30. ValueError: x and y must be the same size

Leave a Comment