title: '>=' not supported between instances of 'datetime.datetime' and 'datetime.time'
body: <p>There is already a question with the same title but I couldn't find an answer to my problem.. I am comparing times (in hour : minutes : seconds format) in a column to a set time (08:00:00) and having some issues. </p>
  
  <p>I have imported some data from excel into a pandas dataframe. Some of the columns contain times. Their format in the dataframe is "object".
  I started by creating a new dataframe containing only the data where  the times in the column "Starttime" are higher than 08:00:00 like this :</p>
  
  <pre><code>OSR_start_OH = pd.DataFrame()
  
  OSR_start_OH = df[df['Starttime'] &gt;= datetime.time(8,0,0)]
  </code></pre>
  
  <p>It works perfectly.</p>
  
  <p>But then I try doing the exact same thing with another column "Finishtime" :</p>
  
  <pre><code>OSR_finish_OH = pd.DataFrame()
  
  OSR_finish_OH = df[df['Finishtime'] &gt;= datetime.time(8,0,0)]
  </code></pre>
  
  <p>And I get the error message  <code>'&gt;=' not supported between instances of 'datetime.datetime' and 'datetime.time'</code> </p>
  
  <p>I don't understand because the data in "Finishtime" column is in the same format as in "Starttime". In fact it is in datetime.time and not datetime.datetime :</p>
  
  <p>The output for : <code>df['Finishtime'][3]</code> </p>
  
  <p>is :    <code>datetime.time(20, 0)</code></p>
  
  <p>Also, I can compare different cells in the "Finishtime" column using '>=' :</p>
  
  <p>The output for : <code>df['Finishtime'][3] &gt;= df['Finishtime'][10]</code></p>
  
  <p>is : <code>True</code></p>
  
  <p>Edit : This is some of the data showing the date on "Finishtime" column for 00:00:00 times.</p>
  
  <pre><code>       Startdate    Starttime   Finishdate  Finishtime
  
  350   2018-06-06      12:00:00  2018-06-06  15:00:00
  
  351   2018-06-06      15:00:00  2018-06-06  19:18:17
  
  352   2018-06-05      00:00:00  2018-06-06  14:47:54
  
  353   2018-06-05      22:00:00  2018-06-05  1900-01-01 00:00:00
  
  354   2018-06-05      00:00:00  2018-06-06  15:19:21
  
  355   2018-06-05      22:00:00  2018-06-05  1900-01-01 00:00:00
  
  356   2018-06-06      02:00:00  2018-06-06  14:48:45
  
  357   2018-06-06      21:48:16  2018-06-06  02:00:00
  </code></pre>
  
  <p>Edit 2: this is what I get after trying 
  <code>df['Finishtime'].apply(lambda x: datetime.time(x.hour, x.minute, x.second))</code></p>
  
  <pre><code>   Startdate    Starttime   Finishdate  Finishtime
  350 2018-06-06  12:00:00    2018-06-06  15:00:00
  351 2018-06-06  15:00:00    2018-06-06  19:18:17
  352 2018-06-05  00:00:00    2018-06-06  14:47:54
  353 2018-06-05  22:00:00    2018-06-05  1900-01-01 00:00:00
  354 2018-06-05  00:00:00    2018-06-06  15:19:21
  355 2018-06-05  22:00:00    2018-06-05  1900-01-01 00:00:00
  356 2018-06-06  02:00:00    2018-06-06  14:48:45
  357 2018-06-06  21:48:16    2018-06-06  02:00:00
  </code></pre>
  
  <p>So the same as above</p>
  
  <p>Any help is very welcome, Thanks!</p>