Python pandas to read an Excel file with more than one row headers

Question

Like the data here, if I have more than one header, how can we read the specific column that I want, thanks!

       machine A       A       B
       date    12-01  12-02   12-01
       number  #1      #2      #2
              0.223   0.224   0.226
              0.333   0.444   0.234
              0.234   0.124   0.456

What is the issue, exactly? Please see How to Ask, help center. — AMC
– AMC, Commented Apr 23, 2020 at 21:44

Renaud · Accepted Answer · 2020-04-23 20:10:23Z

2

You have to use the xs function: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.xs.html

For exemple

print(df.xs('A', level='machine', axis=1))

Or

print(df.xs('#1', level='number', axis=1))

answered Apr 23, 2020 at 20:10

Renaud

2,8172 gold badges12 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

Python pandas to read an Excel file with more than one row headers

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related