title: Converting multiple date formats into one format python
body: <p>The date variable in my data is in multiple formats like 
  DD/MM/YYYY
  D/MM/YY
  DD/M/YYYY
  12/8/2017
  27/08/17
  8/9/2017
  10/9/2017
  15/09/17..</p>
  
  <p>I need to change these multiple formats into one single format like DD/MM/YYYY</p>
  
  <p>Tried to create a parsing function</p>
  
  <pre><code>def parse_date(date):
  if date == '':
      return None
  else:
      return dt.strptime(date, '%d/%m/%y').date()
  </code></pre>
  
  <p>and when I apply this function to my dataset, it throws me the following error.. </p>
  
  <p>"ValueError                                Traceback (most recent call last)
   in ()
  ----> 1 data.Date = data.Date.apply(parse_date)</p>
  
  <p><a href="https://i.stack.imgur.com/RiAT3.png" rel="nofollow noreferrer">Unconverted Data Remains Error</a>
  ValueError: unconverted data remains: 17"</p>
  
  <p>How can I solve the unconverted data remains error?</p>