title: How to convert two different date formats from a pandas dataframe column into same format?
body: <p>I have two different date formats in a pandas column such as - <code>DD-MM-YYYY</code> and <code>MM/DD/YYYY</code> and I want to convert them into the same format.</p>
  
  <p>I tried using the code - </p>
  
  <pre><code>data['SALE DATE'] = pd.to_datetime(data['SALE DATE']).dt.strftime('%m/%d/%Y')
  </code></pre>
  
  <p>but this converts the dates into 
  <code>DD/MM/YYYY</code> and <code>MM/DD/YYYY</code> into the output - data['SALE DATE']</p>
  
  <p><a href="https://i.stack.imgur.com/PAZ56.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PAZ56.png" alt="enter image description here"></a></p>
  
  <p>I want a python solution to overcome this problem. Any leads will be very helpful.</p>