title: reading excel sheet as multiindex dataframe through pd.read_excel()
body: <p>I'm struggle to read a excel sheet with <code>pd.read_excel()</code>. </p>
  
  <p>My excel table looks like this in it's raw form:</p>
  
  <p><a href="https://i.stack.imgur.com/XOgSs.png" rel="noreferrer"><img src="https://i.stack.imgur.com/XOgSs.png" alt="enter image description here"></a></p>
  
  <p>I expected the dataframe to look like this:</p>
  
  <pre><code>                bar                 baz                 foo
                  one       two       one       two       one       two
                  A         B         C         D         E         F
  baz one         0.085930 -0.848468  0.911572 -0.705026 -1.284458 -0.602760
      two         0.385054  2.539314  0.589164  0.765126  0.210199 -0.481789
      three      -0.352475 -0.975200 -0.403591  0.975707  0.533924 -0.195430
  </code></pre>
  
  <p>is this even possible?</p>
  
  <p>My failed attempt:</p>
  
  <pre><code>xls_file = pd.read_excel(data_file, header=[0,1,2], index_col=None)
  </code></pre>
  
  <p>Link to the raw excel file:</p>
  
  <pre><code>https://www.dropbox.com/s/ek646ab4yb1fvdq/ipsos_excel_tables_type_2_trimed_nosig.xlsx?dl=0
  </code></pre>