title: Python pandas, How could I read excel file without column label and then insert column label?
body: <p>I have lists which I want to insert it as column labels.
  But when I use read_excel of pandas, they always consider 0th row as column label.
  How could I read the file as pandas dataframe and then put the list as column label</p>
  
  <pre><code>  orig_index = pd.read_excel(basic_info, sheetname = 'KI12E00')
  
      0.619159  0.264191  0.438849  0.465287  0.445819  0.412582  0.397366  \
  0   0.601379  0.303953  0.457524  0.432335  0.415333  0.382093  0.382361   
  1   0.579914  0.343715  0.418294  0.401129  0.385508  0.355392  0.355123  
  </code></pre>
  
  <p>Here is my personal list for column name</p>
  
  <pre><code>   print set_index
  [20140109, 20140213, 20140313, 20140410, 20140508, 20140612]
  </code></pre>
  
  <p>And I want to make dataframe as below</p>
  
  <pre><code>    20140109  20140213  20140313  20140410  20140508  20140612
  0   0.619159  0.264191  0.438849  0.465287  0.445819  0.412582  0.397366  \
  1   0.601379  0.303953  0.457524  0.432335  0.415333  0.382093  0.382361   
  2   0.579914  0.343715  0.418294  0.401129  0.385508  0.355392  0.355123
  </code></pre>