python pandas parse date without delimiters 'time data '060116' does not match format '%dd%mm%YY' (match)'
<p>I am trying to parse a date column that looks like the one below,</p>

<pre><code>date
061116
061216
061316
061416
</code></pre>

<p>However I cannot get pandas to accept the date format as there is no delimiter (eg '/'). I have tried this below but receive the error: </p>

<blockquote>
  <p>ValueError: time data '060116' does not match format '%dd%mm%YY' (match)</p>
</blockquote>

<pre><code>pd.to_datetime(df['Date'], format='%dd%mm%YY')
</code></pre>

<p>Your date format is wrong. You have days and months reversed. It should be:</p>

<pre><code> %m%d%Y
</code></pre>

python date datetime pandas time-series