title: Pandas series between two date time files
body: <p>My question is about using Pandas time series.</p>
  
  <p>I have one file(Spots) that has pandas time series for a month's data with 7.5 seconds range.
  Example : </p>
  
  <pre><code>2016-11-01 00:00:00,0
  2016-11-01 00:00:07.500000,1
  2016-11-01 00:00:15,2
  2016-11-01 00:00:22.500000,3
  2016-11-01 00:00:30,4
  </code></pre>
  
  <p>The other file(Target) has just time information . </p>
  
  <p>Example:</p>
  
  <pre><code>2016-11-01 00:00:05
  2016-11-01 00:00:07
  2016-11-01 00:00:23
  2016-11-01 00:00:25
  </code></pre>
  
  <p>I want to check which spot does the target date time belong to:
  Output in above example :</p>
  
  <pre><code>2016-11-01 00:00:00,0 '\t' count of targets in this spot = 2
  2016-11-01 00:00:07.500000,1 '\t' count of targets in this spot = 0
  2016-11-01 00:00:15,2 '\t' count of targets in this spot = 0
  2016-11-01 00:00:22.500000,3 '\t' count of targets in this spot = 0
  2016-11-01 00:00:30,4 '\t' count of targets in this spot = 2
  </code></pre>
  
  <p>Thank you so much in advance. Kinda let me know if this is clear otherwise I can try to explain more.</p>