title: Excel to Pandas DataFrame using first column as index
body: <p>I have a very simple table in Excel that I'm trying to read into a DataFrame</p>
  
  <p><a href="https://i.stack.imgur.com/cukLx.png" rel="noreferrer"><img src="https://i.stack.imgur.com/cukLx.png" alt="Excel data"></a></p>
  
  <p>Code:</p>
  
  <pre><code>from pandas import DataFrame, Series
  import pandas as pd
  
  df = pd.read_excel('params.xlsx', header=[0,1], index_col=None)
  </code></pre>
  
  <p>This results in the following DataFrame:</p>
  
  <p><a href="https://i.stack.imgur.com/44v4J.png" rel="noreferrer"><img src="https://i.stack.imgur.com/44v4J.png" alt="DataFrame"></a></p>
  
  <p>I didn't expect param1.key to become the index, especially after having set <code>index_col=None</code>. Is there a way to get the data into a DataFrame with a generated index instead of the data from the first column?</p>
  
  <p>Update — here's what happens when you try <code>reset_index()</code> to resolve the issue:</p>
  
  <p><a href="https://i.stack.imgur.com/vdX3X.png" rel="noreferrer"><img src="https://i.stack.imgur.com/vdX3X.png" alt="DataFrame after reset_index()"></a></p>
  
  <p>Version info:</p>
  
  <ul>
  <li>Python 3.5.0</li>
  <li>pandas (0.17.1)</li>
  <li>xlrd (0.9.4)</li>
  </ul>