title: ValueError: time data- does not match format - Pandas
body: <p>I know this question has been asked many times and there are many <a href="https://stackoverflow.com/questions/25015711/time-data-does-not-match-format">answers</a>. I followed the previous threads, still not getting my answer. 
  When I did this, without <code>errors= coerce</code></p>
  
  <pre><code>df['DATE'] = pd.to_datetime(df['Date'], format= "%d-%b-%Y %H:%M:%S")
  </code></pre>
  
  <p>I get an error:</p>
  
  <blockquote>
    <p>ValueError: time data '26-Aug-17 10:11:29' does not match format '%d-%b-%Y %H:%M:%S' (match)</p>
  </blockquote>
  
  <p>As you can see, I think I have the right format. But still it gives error.</p>
  
  <p>When I do with <code>errors= coerce</code> according to <a href="https://stackoverflow.com/questions/41501726/convert-string-date-time-to-pandas-datetime">this</a> post, </p>
  
  <pre><code>df['DATE'] = pd.to_datetime(df['Date'], format= "%d-%b-%Y %H:%M:%S", `errors= coerce`)
  </code></pre>
  
  <p>This runs fine, but I get <code>NaT</code> in my <code>DATE</code> column. For example, like this,</p>
  
  <pre><code>        Date                    X           DATE    
    0    26-Aug-17 10:11:29    95.617378      NaT
    1    26-Aug-17 11:11:29    93.617378      NaT
    2    26-Aug-17 12:11:29    91.617378      NaT
    3    26-Aug-17 13:11:29    90.000000      NaT
  </code></pre>
  
  <p>I have the format correct and still can not find why am I getting this error. Any thoughts will be helpful. </p>