Skip to content

BUG: Read Excel Unnamed Empty Columns #40976

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

Closed
ghost opened this issue Apr 16, 2021 · 2 comments
Closed

BUG: Read Excel Unnamed Empty Columns #40976

ghost opened this issue Apr 16, 2021 · 2 comments
Labels
Bug IO Excel read_excel, to_excel Needs Info Clarification about behavior needed to assess issue

Comments

@ghost
Copy link

ghost commented Apr 16, 2021

Before I upgraded to Pandas v1.2.3, read_excel would sometimes create empty columns, titled "Unnamed: x". But after upgrading, it always creates empty unnamed columns and several of them. It seems like there should be a default such that empty columns that Pandas wants to call Unnamed don't show when reading in Excel. Or that the read excel reverts to the old version (pre v1.2.3) where it wasn't as bad and unnamed empty columns weren't always being created.

@ghost ghost added Bug Needs Triage Issue that has not been reviewed by a pandas team member labels Apr 16, 2021
@ghost ghost changed the title BUG: Read Excel BUG: Read Excel Unnamed Empty Columns Apr 16, 2021
@phofl
Copy link
Member

phofl commented Apr 16, 2021

Please provied something reproducible

@phofl phofl added the Needs Info Clarification about behavior needed to assess issue label Apr 16, 2021
@rhshadrach rhshadrach added IO Excel read_excel, to_excel and removed Needs Triage Issue that has not been reviewed by a pandas team member labels Apr 20, 2021
@MarcoGorelli
Copy link
Member

thanks for the report - closing for now, will reopen if you can address the above comment

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug IO Excel read_excel, to_excel Needs Info Clarification about behavior needed to assess issue
Projects
None yet
Development

No branches or pull requests

3 participants