title: How to filter one pandas dataframe dates on the basis of other dataframe
body: <p>I have one dataframe, I need to filter the dates on the basis of start and end date of the other dataframe</p>
  
  <p>example set is given below. What is the best way in pandas to achieve that?</p>
  
  <p>Considering sample dataframes as below, I have included the expected result set</p>
  
  <pre><code>df1 
  
  ID all_date   clicks
  1  2019-08-21   5
  1  2019-08-22   4
  2  2019-07-18   5
  2  2019-07-21   5
  2  2019-07-23   6
  
  df2
  
  ID start_date  end_date
  1  2019-08-21 2019-08-21
  2  2019-07-18 2019-08-21
  </code></pre>
  
  <p>expected output:</p>
  
  <pre><code>df1
  
  ID all_date   clicks
  1  2019-08-21   5
  2  2019-07-18   5
  2  2019-07-21   5
  </code></pre>