title: changing relative times to actual dates in a pandas dataframe
body: <p>I have currently a dataframe I created by scraping google news headlines. One of my columns is "Time", which refers to time of publication of an article.</p>
  
  <p>Unfortunately, for recent articles, google news uses a "relative" date, e.g., 6 hours ago, or 1 day ago instead of Nov 1, 2017. </p>
  
  <p>I really want to convert these relative dates to be consistent with the other entries (so they also say Nov 12, 2017, for example), but I have no idea where to even start on this. </p>
  
  <p>My thoughts are to maybe make a variable which represents todays date, and then do some kind of search through the dataframe for stuff which doesn't match my format, and then to subtract those relative times with the current date. I would also have to make some sort of filter for stuff which has "hours ago" and just have those equal the current date.</p>
  
  <p>I don't really want a solution but rather a general idea of what to read to try to solve this. Am I supposed to try using numpy?</p>
  
  <p>Example of some rows:</p>
  
  <pre><code>     Publication    Time    Headline
  0   The San Diego Union-Tribune     6 hours ago     I am not opposed to new therapeutic modalities...
  1   Devon Live  13 hours ago    If you're looking for a bargain this Christmas...
  15  ABS-CBN News    1 day ago   Now, Thirdy has a chance to do something that ...
  26  New York Times  Nov 2, 2017     Shepherds lead their sheep through the centre ...
  </code></pre>