title: python pandas dataframe add column with values while reading excel file
body: <p>Is there a way that I can add column with certain value while reading excel file using python pandas?</p>
  
  <p>Now I have two steps, but I need to do it more than 30 files so I want to find elegant way to do it!</p>
  
  <pre><code>1) df_2007 = pd.read_excel('may2007_dl.xls')
  2) df_2007['year'] = 2007
  </code></pre>
  
  <p>Thanks.</p>