“BadZipFile: File is not a zip file” – Error popped up all of a sudden

by

Excel XLSX files are zipped, XLS files are not.

I believe this bug is related to a combination of

  1. XLS is not zipped, and
  2. Since python-3.9, the openpyxl module must be used with XLSX files.

This problem is easy to solve by checking which type of Excel file is uploaded and using the appropriate engine to read into Pandas.

By file extension

from pathlib import Path
import pandas as pd

file_path = Path(filename)
file_extension = file_path.suffix.lower()[1:]

if file_extension == 'xlsx':
    df = pd.read_excel(file.read(), engine="openpyxl")
elif file_extension == 'xls':
    df = pd.read_excel(file.read())
elif file_extension == 'csv':
    df = pd.read_csv(file.read())
else:
    raise Exception("File not supported")

By file mimetype

If you happen to have access to the file mimetype, you can perform the following test:

import pandas as pd

if file.content_type == 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet':
    df = pd.read_excel(file.read(), engine="openpyxl")  # XLSX
elif file.content_type == 'application/vnd.ms-excel':
    df = pd.read_excel(file.read())  # XLS
elif file.content_type == 'text/csv':
    df = pd.read_csv(file.read())  # CSV
else:
    raise Exception("File not supported")

More Related Contents:

  1. How to create an empty R vector to add new items
  2. upload file to my dropbox from python script
  3. Netcat implementation in Python
  4. Is MATLAB faster than Python?
  5. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  6. Python regex: matching a parenthesis within parenthesis
  7. Unexpected keyword argument ‘ragged’ in Keras
  8. Generate all subsets of size k (containing k elements) in Python
  9. How to add an attention mechanism in keras?
  10. How to force Sphinx to use Python 3.x interpreter
  11. pydev breakpoints not working
  12. sys.stdin.readline() and input(): which one is faster when reading lines of input, and why?
  13. How to access environment secrets from a Github workflow?
  14. dynamically loading django apps at runtime
  15. Writing code translator from Python to C? [closed]
  16. Merging two tables with millions of rows in Python
  17. Python – logical evaluation order in “if” statement
  18. exec() not working inside function python3.x
  19. Sparse Tensor (matrix) from a dense Tensor Tensorflow
  20. Modify global list inside a function
  21. Creating a custom widget in tkinter
  22. Python intern for non-strings
  23. Generate random locations within a triangular domain
  24. How can two Python objects have same id but ‘is’ operator returns False?
  25. Selecting a range of columns in a dataframe
  26. Calculate RGB value for a range of values to create heat map
  27. Why does numpy.histogram (Python) leave off one element as compared to hist in Matlab?
  28. Redirect to login page if user not logged in using FastAPI-Login package
  29. Inheritance best practice : *args, **kwargs or explicitly specifying parameters [closed]
  30. Map list item to function with arguments

Leave a Comment