Error: Unsupported format, or corrupt file: Expected BOF record

by

If you use read_excel() to read a .csv you will get the error

XLRDError: Unsupported format, or corrupt file: Expected BOF record;

To read .csv one needs to use read_csv(), like this

df1= pd.read_csv("filename.csv")

More Related Contents:

  1. Writing to an Excel spreadsheet
  2. Create a .csv file with values from a Python list
  3. How to write to an Excel spreadsheet using Python?
  4. Python convert csv to xlsx
  5. Pandas: Looking up the list of sheets in an excel file
  6. python xlrd unsupported format, or corrupt file.
  7. xls to csv converter
  8. Reading Excel File using Python, how do I get the values of a specific column with indicated column name?
  9. Get formula from Excel cell with python xlrd
  10. Convert date from excel in number format to date format python [duplicate]
  11. How to obtain sheet names from XLS files without loading the whole file?
  12. IndexError: too many indices for array
  13. Insert row into Excel spreadsheet using openpyxl in Python
  14. Edit existing excel workbooks and sheets with xlrd and xlwt
  15. Identifying Excel Sheet cell color code using XLRD package
  16. Python Pandas – Read csv file containing multiple tables
  17. Importing a CSV file into a sqlite3 database table using Python
  18. how to merge 200 csv files in Python
  19. ImportError: No module named win32com.client
  20. Python csv.reader: How do I return to the top of the file?
  21. Write dictionary of lists to a CSV file
  22. Pandas: ValueError: cannot convert float NaN to integer
  23. ‘utf-8’ codec can’t decode byte 0xa0 in position 4276: invalid start byte
  24. How to copy worksheet from one workbook to another one using openpyxl?
  25. Convert HTML into CSV
  26. How to read SharePoint Online (Office365) Excel files in Python with Work or School Account?
  27. Use Python to Inject Macros into Spreadsheets
  28. Pandas groupby to to_csv
  29. Python 3 CSV file giving UnicodeDecodeError: ‘utf-8’ codec can’t decode byte error when I print
  30. Python3: writing csv files

Leave a Comment