title: Dealing with different date formats python?
body: <p>I'm using the <code>pd.to_datetime(df['Date'], format=&quot;%d/%m/%Y&quot;)</code> method to try and convert the column to a datetime  column.</p>
  <p>Now, the dates are of the form day/month/year, but in varying different formats, for example:</p>
  <pre><code>5/8/2005
  13/08/05
  4/2/2006
  </code></pre>
  <p>I get an error: <code>time data '13/08/05' does not match format '%d/%m/%Y' (match)</code> when I try and use <code>pd.to_datetime()</code>, and when I remove the formatting, pandas incorrectly transforms the dates.</p>
  <p>How do I deal with this?</p>