title: Python - Subset data between two datetime
body: <p>I'm trying to subset a dataset to include rows between two dates. However, when I this function:</p>
  
  <pre><code>data_norm[(data_norm['publication_date'] &gt; '2016-09-01') &amp; (data_norm['publication_date'] &lt;= '2016-09-30')]
  </code></pre>
  
  <p>I get this:</p>
  
  <pre><code>Empty DataFrame
  Columns: [categories, company, contents, id, levels, locations, model_type, name, publication_date, refs, short_name, tags, type]
  Index: []
  </code></pre>
  
  <p>My guess is that the dates in my subset function differs from the data. This is the data:</p>
  
  <pre><code>0   2017-01-30 21:28:12.102749
  1   2017-01-30 21:24:32.670365
  2   2016-12-29 18:56:37.000000
  3   2017-01-13 12:10:55.000000
  4   2017-01-30 21:28:33.180670
  Name: publication_date, dtype: datetime64[ns]
  </code></pre>
  
  <p>Any idea(s)?</p>