python with pandas: select column with multi header

Question

I read an xlsx file with two headers into a panda dataframe. Now I fail to select a row according to header 1 or two.

Googeling my probelm did not bring up an answer which worked, so I try it here

My Excel looks like this:

Here you see an excerpt of the test excel:

Now I read the excel file into pandas like this:

df = pd.read_excel('XLsample.xlsx', sheet_name=0, header=[0,1], index_col=0)

How can I read a column dependent on header 0 or 1 ? I mean something like this:

persons = df[header[1]]['Name']

numbers = df[header[0]]['int']

thx for your support

jezrael · Accepted Answer · 2018-05-28 08:31:39Z

3

persons = df.xs('Name', axis=1, level=1)

numbers = df.xs('int', axis=1, level=0)

answered May 28, 2018 at 8:31

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you very much! That is what I was looking for!