reading excel sheet as multiindex dataframe through pd.read_excel()
<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>