title: DataFrame Selection Within Date Ranges Returns without Rows
body: <p>I am following the commonly recommended process on SO for consolidating a DataFrame to only a sample selection that I plan on using for my analysis, but somewhere in the process of using <code>pd.date_range</code> and the selection between the dates, the data goes missing with the column headers as the only data that exists.</p>
  
  <p>Here are my variables:</p>
  
  <pre><code>custom_date_start = '2018-01-01'
  
  custom_date_end= '2018-10-31'
  
  sheet_date = 'date'
  
  df_clean # raw data table
  </code></pre>
  
  <p>Table briefly described:</p>
  
  <pre><code>display(df_clean.head(3))
  display(df_clean.tail(3))
  
  # output
  
  date    b_clicks    b_leads b_sals
  2   1/1/2018    72  6   5
  3   1/2/2018    232 9   7
  4   1/3/2018    255 23  17
  date    b_clicks    b_leads b_sals
  729 12/29/2019          
  730 12/30/2019          
  731 12/31/2019      
  </code></pre>
  
  <p>Sample selection:</p>
  
  <pre><code>date_range = pd.date_range(custom_date_start, custom_date_end)
  
  print(date_range)
  
  display(df_clean.head(1))
  display(df_clean.tail(1))
  
  df_clean_test = df_clean[(df_clean[sheet_date] &gt; custom_date_start) &amp; (df_clean[sheet_date] &lt;= custom_date_end)]
  
  display(df_clean_test.head(1))
  display(df_clean_test.tail(1))
  
  # output
  
  DatetimeIndex(['2018-01-01', '2018-01-02', '2018-01-03', '2018-01-04',
                 '2018-01-05', '2018-01-06', '2018-01-07', '2018-01-08',
                 '2018-01-09', '2018-01-10',
                 ...
                 '2018-10-22', '2018-10-23', '2018-10-24', '2018-10-25',
                 '2018-10-26', '2018-10-27', '2018-10-28', '2018-10-29',
                 '2018-10-30', '2018-10-31'],
                dtype='datetime64[ns]', length=304, freq='D')
  date    b_clicks    b_leads b_sals # df_clean
  2   1/1/2018    72  6   5
  date    b_clicks    b_leads b_sals # df_clean
  731 12/31/2019          
  date    b_clicks    b_leads b_sals # df_clean_test
  date    b_clicks    b_leads b_sals # df_clean_test
  </code></pre>