title: Filter an existing dataframe to only include rows with a date value between two values in Python
body: <p>I am trying to create a table from an existing table where only rows with date values between two numbers (43919 and 43989 aka March 29 and June 6 2020) are included. I'm doing this from an existing dataframe &quot;county_timeseries_covid&quot; and trying to create a new dataframe &quot;filtered_table&quot;</p>
  <p>When I do the following, it creates a new table where all values are null except for those meeting the date requirement. But, I want the rows to be excluded rather than have null values:</p>
  <pre><code>filter1 = county_timeseries_covid[&quot;date&quot;] &gt;= 43919
  filter2 = county_timeseries_covid[&quot;date&quot;] &lt;  43989
  
  filtered_table = county_timeseries_covid.where(filter1 &amp; filter2)
  </code></pre>
  <p>I've also tried the following, but this returns an empty table:</p>
  <pre><code>filter1 = county_timeseries_covid[&quot;date&quot;] &gt;= 43919
  filter2 = county_timeseries_covid[&quot;date&quot;] &lt;  43989
  
  filtered_table = county_timeseries_covid.where(filter1 &amp; filter2, inplace = True)
  </code></pre>
  <p>I've also tried the following, but it returns an error:</p>
  <pre><code>filtered_table = county_timeseries_covid.where(county_timeseries_covid[&quot;date&quot;] &gt;= 43933 
                                                              , county_timeseries_covid[&quot;date&quot;] &lt; 44003)
  </code></pre>
  <p>How do I do this??? It seems so simple, but I can't find the answer despite a lot of googling.</p>