title: Comparison between datetime and datetime64[ns] in pandas
body: <p>I'm writing a program that checks an excel file and if today's date is in the excel file's date column, I parse it</p>
  
  <p>I'm using:</p>
  
  <pre><code>cur_date = datetime.today()
  </code></pre>
  
  <p>for today's date. I'm checking if today is in the column with:</p>
  
  <pre><code>bool_val = cur_date in df['date'] #evaluates to false
  </code></pre>
  
  <p>I do know for a fact that today's date is in the file in question. The dtype of the series is datetime64[ns]</p>
  
  <p>Also, I am only checking the date itself and not the timestamp afterwards, if that matters. I'm doing this to make the timestamp 00:00:00:</p>
  
  <pre><code>cur_date = datetime.strptime(cur_date.strftime('%Y_%m_%d'), '%Y_%m_%d')
  </code></pre>
  
  <p>And the type of that object after printing is datetime as well</p>