title: Comparing date column of the csv file to today date
body: <p>I need to compare my large data's date with today date to calculate another column value if the date is more than or less than today.</p>
  
  <p>My code is as below however I'm keep getting error! </p>
  
  <p>I have tried <code>Timestamp.now()</code> but my python 3.6 can not recognise it. </p>
  
  <pre><code>import datetime
  def midspread_calcs():
      for row in df_midspread:
          if df_midspread['Date']&lt;datetime.datetime.now():
             df_midspread['Midspread']= df_midspread.Oldrate*df_midspread.Value
          else:
             df_midspread['Midspread']= df_midspread.Newrate*df_midspread.Value 
  
  result = midspread_calcs()
  </code></pre>