title: Merge three Pandas dataframe between datetime and adding corresponding columns
body: <p>Given two dataframes df1, df2 and df3, how to join them such that df3 timestamps is in between start and end in dataframe df1 and df2.</p>
  <p>I have to merge the Job ID to df3 based whether the df3'Timestamp' is in df1 or df2 'Start time' and 'End Time', and also match the Node(No.</p>
  <p>df1(1230rows*3 columns)</p>
  <pre><code>Node      Start Time      End Time      JobID
  A         00:03:50        00:05:45      12345
  A         00:06:10        00:07:39      56789
  A         00:08:30        00:10:45      34567
  .
  .
  .
  </code></pre>
  <p>df2(1130rows*3 columns)</p>
  <pre><code>Node      Start Time      End Time      JobID
  B         00:02:30        00:07:35      13579
  B         00:08:56        00:09:39      24680
  B         00:10:32        00:13:47      14680
  .
  .
  .
  </code></pre>
  <p>df3(4002rows*3 columns)</p>
  <pre><code>Node      Timestamp     
  A         00:05:42       
  A         00:09:50       
  A         00:11:27       
  B         00:04:48
  B         00:09:59
  B         00:10:32
  .
  .
  .
  .
  </code></pre>
  <p>Expected Output:
  df3(4002rows*3 columns)</p>
  <pre><code>No.       Timestamp       Job ID
  A         00:05:42        12345              
  A         00:09:50        34567       
  A         00:11:27        NaN
  B         00:04:48        13579
  B         00:09:59        NaN
  B         00:10:32        14680
  .
  .
  .
  .
  </code></pre>