title: Have two dataframes with dt, How do I get the count of rows in the last 7 days?
body: <pre><code>import pandas as pd 
  
  
  
  l1 = [&quot;2021-11-15&quot;,&quot;2021-11-13&quot;,&quot;2021-11-10&quot;,&quot;2021-05-28&quot;,&quot;2021-06-02&quot;,&quot;2021-06-02&quot;,&quot;2021-11-02&quot;]
  l2 = [&quot;2021-11-11&quot;,&quot;2021-03-02&quot;,&quot;2021-11-05&quot;,&quot;2021-05-20&quot;,&quot;2021-05-01&quot;,&quot;2021-06-01&quot;,&quot;2021-04-08&quot;]
  #convert to dt
  l1=pd.to_datetime(l1)
  l2= pd.to_datetime(l2)
  
  
  #put in df
  df1=pd.DataFrame(l1)
  df2=pd.DataFrame(l2)
  df1.columns = ['0']
  df2.columns = ['0']
  df1=df1.set_index('0')
  df2=df2.set_index('0')
  
  #sort asc
  df1=df1.sort_index()
  df2=df2.sort_index()
  </code></pre>
  <p>How can I get a COUNT from each dataframe based on the number of rows that are within the last 7 days?</p>