Skip to content

BUG? Consistency of column parsing #11357

Open
@chris-b1

Description

@chris-b1

xref #11328

In [100]: df = pd.DataFrame({0: range(5), 1:range(5)})

In [101]: df.to_excel('tmp.xlsx')

In [102]: df.to_csv('tmp.csv')

In [103]: pd.read_excel('tmp.xlsx', index_col=0).columns
Out[103]: Int64Index([0, 1], dtype='int64')

In [106]: pd.read_csv('tmp.csv', index_col=0).columns
Out[106]: Index([u'0', u'1'], dtype='object')

Metadata

Metadata

Assignees

No one assigned

    Labels

    API - ConsistencyInternal Consistency of API/BehaviorBugIO CSVread_csv, to_csvIO Excelread_excel, to_excel

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions