title: Merge with the nearest minute using pandas
body: <p>I simply want to merge two dataframes within ±1 min interval. </p>
  
  <p>Here name_df with the sample data set:</p>
  
  <pre><code>Name    Date
  A       2/19/2019 17:16:15
  B       2/19/2019 17:19:46
  C       2/19/2019 17:23:03
  </code></pre>
  
  <p>Another dateframe job_df:</p>
  
  <pre><code>Job         Datestamp
  Engineer    2/19/2019  17:15:56 
  Dancer      2/19/2019  17:19:27 
  Singer      2/19/2019  17:22:44 
  </code></pre>
  
  <p>Here is what I tried to implement but this method misses some rows that went over the other side of the 1 minute(e.g &lt;30 sec rounds down, >30 rounds up):</p>
  
  <pre><code>name_df['Date&amp;Time'] = name_df['Date&amp;Time'].dt.round('1min')
  job_df['Date&amp;Time'] = job_df['Date&amp;Time'].dt.round('1min')
  
  merged_df = pd.merge(name_df, job_df, on='Date&amp;Time')
  </code></pre>
  
  <p>Any help on this is greatly appreciated!</p>