Skip to content

BUG: Read Excel Unnamed Empty Columns #40976

Closed
@ghost

Description

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugIO Excelread_excel, to_excelNeeds InfoClarification about behavior needed to assess issue

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions