Description
Pandas version checks
-
I have checked that this issue has not already been reported.
-
I have confirmed this bug exists on the latest version of pandas.
-
I have confirmed this bug exists on the main branch of pandas.
Reproducible Example
import pandas as pd
file = pd.read_excel("/Users/alex/Desktop/BrokenExcel.xlsx", sheet_name=None, header=1)Issue Description
Loading the attached file produces an exception and crashes in 1.5.0 but worked in 1.4.3.
venv/bin/python /Users/alex/Library/Application Support/JetBrains/PyCharm2022.2/scratches/scratch_5.py
Traceback (most recent call last):
File "venv/lib/python3.9/site-packages/pandas/io/parsers/python_parser.py", line 701, in _next_line
line = self._check_comments([self.data[self.pos]])[0]
IndexError: list index out of range
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "venv/lib/python3.9/site-packages/pandas/io/parsers/python_parser.py", line 386, in _infer_columns
line = self._next_line()
File "venv/lib/python3.9/site-packages/pandas/io/parsers/python_parser.py", line 714, in _next_line
raise StopIteration
StopIteration
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/Users/alex/Library/Application Support/JetBrains/PyCharm2022.2/scratches/scratch_5.py", line 2, in <module>
file = pd.read_excel("/Users/alex/Desktop/BrokenExcel.xlsx", sheet_name=None, header=1)
File "venv/lib/python3.9/site-packages/pandas/util/_decorators.py", line 211, in wrapper
return func(*args, **kwargs)
File "venv/lib/python3.9/site-packages/pandas/util/_decorators.py", line 317, in wrapper
return func(*args, **kwargs)
File "venv/lib/python3.9/site-packages/pandas/io/excel/_base.py", line 491, in read_excel
data = io.parse(
File "venv/lib/python3.9/site-packages/pandas/io/excel/_base.py", line 1711, in parse
return self._reader.parse(
File "venv/lib/python3.9/site-packages/pandas/io/excel/_base.py", line 867, in parse
parser = TextParser(
File "venv/lib/python3.9/site-packages/pandas/io/parsers/readers.py", line 1870, in TextParser
return TextFileReader(*args, **kwds)
File "venv/lib/python3.9/site-packages/pandas/io/parsers/readers.py", line 1442, in __init__
self._engine = self._make_engine(f, self.engine)
File "venv/lib/python3.9/site-packages/pandas/io/parsers/readers.py", line 1747, in _make_engine
return mapping[engine](f, **self.options)
File "venv/lib/python3.9/site-packages/pandas/io/parsers/python_parser.py", line 123, in __init__
) = self._infer_columns()
File "venv/lib/python3.9/site-packages/pandas/io/parsers/python_parser.py", line 396, in _infer_columns
raise ValueError(
ValueError: Passed header=[1], len of 1, but only 1 lines in file
Process finished with exit code 1
Expected Behavior
Loading of the Excel file (as in 1.4.3)
Installed Versions
INSTALLED VERSIONS
commit : 87cfe4e
python : 3.9.13.final.0
python-bits : 64
OS : Darwin
OS-release : 21.6.0
Version : Darwin Kernel Version 21.6.0: Mon Aug 22 20:17:10 PDT 2022; root:xnu-8020.140.49~2/RELEASE_X86_64
machine : x86_64
processor : i386
byteorder : little
LC_ALL : None
LANG : None
LOCALE : en_US.UTF-8
pandas : 1.5.0
numpy : 1.23.3
pytz : 2022.1
dateutil : 2.8.2
setuptools : 62.6.0
pip : 22.2.2
Cython : None
pytest : 7.1.3
hypothesis : None
sphinx : None
blosc : None
feather : None
xlsxwriter : None
lxml.etree : 4.9.1
html5lib : None
pymysql : None
psycopg2 : None
jinja2 : 3.1.2
IPython : None
pandas_datareader: None
bs4 : None
bottleneck : None
brotli : None
fastparquet : None
fsspec : None
gcsfs : None
matplotlib : None
numba : None
numexpr : None
odfpy : None
openpyxl : 3.0.10
pandas_gbq : None
pyarrow : None
pyreadstat : None
pyxlsb : None
s3fs : None
scipy : 1.9.0
snappy : None
sqlalchemy : None
tables : None
tabulate : None
xarray : None
xlrd : None
xlwt : None
zstandard : None
tzdata : None