title: How to assign column variable 'Date' with date value from file name (Pandas)
body: <p>I have the following file name....</p>
  
  <pre><code>Filename = ('../BSOS Supplier Sales (01289), 02.04.2018 - 08.04.2018 (X).xlsx')
  </code></pre>
  
  <p>I want to 
  1) Read the file into a df and 
  2) assign a new Column variable "Date" with the date captured in the above filename (02.04.2018 - 08.04.2018</p>
  
  <p>How can this be done using pd.read_excel(Filename)?</p>