Skip to content

Potential performance issue: Unreliable performance of pd.read_excel in pandas 1.2.4 #545

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
TendouArisu opened this issue Feb 16, 2025 · 0 comments

Comments

@TendouArisu
Copy link

Issue Description:

Hello.
I have discovered a performance degradation in the pd.read_excel function of pandas version 1.2.4 when pd.read_excel read_excel trailing blank rows and columns. And I notice that requirements.txt, shows that it depends on pandas version 1.2.4. I am not sure whether this performance problem in pandas will affect this repository. I found some discussions on GitHub related to this issue, including #41167 and #41227.
I also found that tools/excel_tools.py used the influenced api. There may be more files used the influenced api.

Suggestion

I would recommend considering an upgrade to a different version of pandas > 1.2.4 or exploring other solutions to optimize the performance.
Any other workarounds or solutions would be greatly appreciated.
Thank you!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant