title: Convert date from excel file to pandas
body: <p>I'm importing excel file, where the 'Date' column has different ways of writing:</p>
  
  <pre><code>      Date
  13/03/2017
  13/03/2017
  13/03/2017
  13/03/2017
     10/3/17
     10/3/17
      9/3/17
      9/3/17
      9/3/17
      9/3/17
  </code></pre>
  
  <p>Importing to pandas:</p>
  
  <pre><code>df = pd.read_excel('data_excel.xls')
  df.Date = pd.to_datetime(df.Date)
  </code></pre>
  
  <p>results in:</p>
  
  <pre><code>                     Date
                 13/03/2017
  64             13/03/2017
  65             13/03/2017
  66             13/03/2017
  67    2017-10-03 00:00:00
  68    2017-10-03 00:00:00
  69    2017-09-03 00:00:00
  70    2017-09-03 00:00:00
  71    2017-09-03 00:00:00
  72    2017-09-03 00:00:00
  </code></pre>
  
  <p>Which means, pandas did not parse properly date and time:</p>
  
  <pre><code>10/3/17 -&gt; 2017-10-03
  </code></pre>
  
  <p>when I tried to specify the format:</p>
  
  <pre><code>df.Date = pd.to_datetime(df.Date, format='%d%m%Y')
  </code></pre>
  
  <p>got the error:</p>
  
  <pre><code>ValueError: time data u'13/03/2017' does not match format '%d%m%Y' (match)
  </code></pre>
  
  <p><strong>Question:</strong></p>
  
  <p>How to import properly date and times from the excel file to pandas?</p>