title: Grabbing the time stamp in a csv using Pandas
body: <p>I have a csv that I want to read into a pandas dataframe and analyze. One column is called 'Date', and can be easily turned into a datetime type using:</p>
  
  <pre><code>pd.to_datetime(df.Datum, format='%Y%m%d')
  </code></pre>
  
  <p>However that column doesn't contain the time associated with the row. The time (for some unknown reason) is contained within a string in another column, equivalent to a 'comment' column. A sample entry in the 'comment' column looks similar to the following string:</p>
  
  <pre><code>'Passnumber:123 19-05-2016 21:58 Transactie:123A12 Term:AABBC'
  </code></pre>
  
  <p>I want to extract the time before the word 'Transactie', which in this case is 21:58. Is that possible to do in pandas, or do I need to a more general regex package?</p>