title: how to convert mix date formats mm-dd-yyyy and yyyy-mm-dd to date in pandas
body: <p>I am reading multiple csv files in pandas each has different date formats</p>
  
  <pre><code>  df1
    Trans_Date              Value
    28-02-2018 02:19:00     123478
    24-02-2018 03:29:00     4456
    21-02-2018 04:22:00     5567
    01-03-2018 02:34:00     435
    02-03-2018 10:19:00     4567
  </code></pre>
  
  <p>I am converting <code>Trans_Date</code> to <code>datetime</code> with following function in pandas</p>
  
  <pre><code> df['Trans_Date'] = pd.to_datetime(df1.Trans_Date)  
  </code></pre>
  
  <p>It's giving me following output</p>
  
  <pre><code>  Trans_Date              Value
    2018-02-28 02:19:00     123478
    2018-02-24 03:29:00     4456
    2018-02-21 04:22:00     5567
    2018-01-03 02:34:00     435
    2018-02-03 10:19:00     4567
  </code></pre>
  
  <p>For last two observations its doing incorrect conversion. I am not able to figure out why.</p>
  
  <p>Help would be appriciated. </p>