title: Python - Pandas - Convert YYYYMM to datetime
body: <p>Beginner python (and therefore pandas) user. I am trying to import some data into a pandas dataframe. One of the columns is the date, but in the format "YYYYMM". I have attempted to do what most forum responses suggest:</p>
  
  <pre><code>df_cons['YYYYMM'] = pd.to_datetime(df_cons['YYYYMM'], format='%Y%m')
  </code></pre>
  
  <p>This doesn't work though (<code>ValueError: unconverted data remains: 3</code>). The column actually includes an additional value for each year, with MM=13. The source used this row as an average of the past year. I am guessing <code>to_datetime</code> is having an issue with that.</p>
  
  <p>Could anyone offer a quick solution, either to strip out all of the annual averages (those with the last two digits "13"), or to have <code>to_datetime</code> ignore them?</p>