title: Python Pandas: I'm unable to set second row as column headers
body: <p>I have an .xlsx file whose format is similar to... (Note that the first row is descriptive and not meant to be the column headers. Headers are on row 2)</p>
  
  <pre><code>SHEET SUBJECT, Listings for 2010,,,,
  Date, Name, Name_2, Abr, Number,         &lt;--- I want this as column headers
  12/01/2010, Company Name, Somecity, Chi, 36,
  12/02/2010, Company Name, Someothercity, Nyc, 156,
  </code></pre>
  
  <p>So when I do <code>this_df = pd.read_excel('filename.xlsx')</code> I get <code>SHEET SUBJECT</code> and <code>Listings for 2010</code> followed by a series of unnamed column headers. Expected, not what I want.</p>
  
  <p>And when I do <code>this_df.columns = this_df.iloc[1]</code>, assuming I'll get the column headers set from the row at index 1, it instead gives me the data values from the row at index 2. </p>
  
  <p>What am I missing? Thanks.</p>