title: First row to header with pandas
body: <p>I have the following pandas dataframe <code>df</code> :</p>
  
  <pre class="lang-py prettyprint-override"><code>import pandas as pd
  from io import StringIO
  s = '''\
  "Unnamed: 0","Unnamed: 1"   
  Objet,"Unités vendues"  
  Chaise,3
  Table,2
  Tabouret,1
  '''
  df = pd.read_csv(StringIO(s))
  </code></pre>
  
  <p>which looks as:</p>
  
  <pre><code>  Unnamed: 0     Unnamed: 1
  0      Objet  Unités vendues
  1     Chaise                 3
  2      Table                 2
  3   Tabouret                 1
  </code></pre>
  
  <p>My target is to make the first row as header.</p>
  
  <p>I use :</p>
  
  <pre><code>headers = df.iloc[0]
  df.columns = [headers]  
  </code></pre>
  
  <p>However, the "0" appears in index column name (which is normal, because this 0 was in the first row).</p>
  
  <pre><code>0          Objet Unités vendues 
  1         Chaise              3 
  2          Table              2 
  </code></pre>
  
  <p>I tried to delete it in many way, but nothing work :</p>
  
  <p>Neither <code>del df.index.name</code> from <a href="https://stackoverflow.com/questions/29765548/remove-index-name-in-pandas">this post</a></p>
  
  <p>Neither <code>df.columns.name = None</code> from <a href="https://stackoverflow.com/questions/32834785/removing-the-name-of-a-pandas-dataframe-index-after-appending-a-total-row-to-a-d">this post</a> or <a href="https://stackoverflow.com/questions/57738129/how-to-remove-the-index-name-in-pandas-dataframe">this one</a> (which is the same situation)</p>
  
  <p>How can I have this expected output :</p>
  
  <pre><code>           Objet Unités vendues 
  1         Chaise              3 
  2          Table              2 
  </code></pre>