title: Python pandas read excel - create index from two columns
body: <p>I regularly face an issue when I have an excel file which looks like the following:</p>
  
  <pre><code> Date     ,      Hour
  
   2015-12-15 ,      1    
  </code></pre>
  
  <p>(Please note that this data are read from excel so the date is in excel whatever format)</p>
  
  <p>Now I tried:</p>
  
  <pre><code>df2=pd.read_excel(name, sheetname=0,skiprows=17, parse_dates="Date")
  df2["test"]=df2.apply(lambda val: val["Date"]+timedelta(hours=int(df2["Hour"])-1))
  </code></pre>
  
  <p>However, here I get the error:</p>
  
  <pre><code>KeyError: 'Date', ' occured at index Date'
  </code></pre>
  
  <p>My df2 have the following types:</p>
  
  <pre><code>Date:  datetime64
  Hour:  object
  </code></pre>
  
  <p>In addition I tried:</p>
  
  <pre><code>df2.set_index(df2["Date"]+df2["Hour"])
  </code></pre>
  
  <p>but without success.</p>
  
  <p>Does anybody has a clue how to avoid this error, or how to get an index column in the following format:</p>
  
  <pre><code>2015-12-15 00:00:00
  </code></pre>