title: Pandas: Reading excel files when the first row is NOT the column name Excel Files
body: <p>I am using pandas to read an excel file. It doesn't have column name but it continues to read the first row as the column name. </p>
  
  <p>Following is the excel file that is being read. </p>
  
  <pre><code>data1   0.994676
  data2   0.994588
  data3   0.99488
  data4   0.994483
  data5   0.994312
  data6   0.993823
  data7   0.993575
  data8   0.994231
  data9   0.993838
  data10  0.994007
  data11  0.994328
  data12  0.993503
  data13  0.99342
  data14  0.992729
  data15  0.993013
  data16  0.993049
  data17  0.993133
  data18  0.99262
  </code></pre>
  
  <p>I'm reading the 2nd column using the following code.
  import pandas as pd</p>
  
  <pre><code>df=pd.ExcelFile('C:/Users/JohnDoe/Desktop/080718_output.xlsx', header=None, index_col=False).parse('Data_sheet')
  y=df.iloc[0:17,1]
  </code></pre>
  
  <p>The following is the y.</p>
  
  <pre><code>In[38]:y
  Out[38]: 
  0     0.994588
  1     0.994880
  2     0.994483
  3     0.994312
  4     0.993823
  5     0.993575
  6     0.994231
  7     0.993838
  8     0.994007
  9     0.994328
  10    0.993503
  11    0.993420
  12    0.992729
  13    0.993013
  14    0.993049
  15    0.993133
  16    0.992620
  Name: 0.994676, dtype: float64
  </code></pre>
  
  <p>It skips the first data because the first row is being used as a column name..
  Any idea on how I can improve this?</p>
  
  <p>Edit: 'header=False' to 'header=None'. Both cases give the same outcome.</p>