Skip to content

read_excel documentation does not mention names keyword #11468

Closed
@PBrockmann

Description

@PBrockmann

http://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_excel.html
does not mention the keyword "names"

import pandas as pd
df = pd.read_excel('yourfile.xls', header=None, names=['Attribut', 'Value'])

is equivalent but simpler to

df = pd.read_excel(file, sheetname='Metadata', header=None)
df.columns = ['Attribut', 'Value']

names keyword is defined as in read_csv
names: List of column names to use as column names. To replace header existing in file, explicitly pass header=0.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions