title: Remove header row in Excel using pandas
body: <p>I have an Excel file with merge header that I read as dataframe using pandas. It looks like this after <code>pd.read_excel()</code>:</p>
  
  <pre><code>Unnamed: 0     Pair    Unnamed: 1      Type      ...  Unnamed: 23
  cabinet_name   group     pair          caller_id ...  result
  value1         value1    value1        value1    ...  value1
  value2         value2    value2        value2    ...  value2
  </code></pre>
  
  <p>So it's like I have two header rows. One is the row with Unnamed and the other is my desired header row.</p>
  
  <p>This is my desired output:</p>
  
  <pre><code>cabinet_name   group     pair          caller_id ...  result
  value1         value1    value1        value1    ...  value1
  value2         value2    value2        value2    ...  value2
  </code></pre>
  
  <p>I am trying to remove the <strong>row</strong> with <code>Unnamed</code>:</p>
  
  <pre><code>df.drop(df.index[[0]])
  </code></pre>
  
  <p>and also using <code>header=None</code> in <code>pd.read_excel('file.xlsx, header=None)'</code></p>
  
  <p>But all of what I found did not return my expected output. I searched on how to delete <strong>rows</strong> with <code>Unnamed</code> but all I found was deleting <strong>columns</strong>.</p>
  
  <p>I also tried</p>
  
  <pre><code>df.drop(df.head(0))
  </code></pre>
  
  <p>but it returned me:</p>
  
  <pre><code>KeyError: '[\'Unnamed: 0\' \'Pair'\ ... \'Unnamed: 23\']'
  </code></pre>
  
  <p>Any best way to do it? </p>