COMPAT: datetime.date comparisons with datetime64[ns]

[jreback]

This should probably work

In [16]: df = pd.DataFrame({'A':[pd.Timestamp('20130101'), np.nan]})

In [17]: df
Out[17]: 
           A
0 2013-01-01
1        NaT

In [18]: pd.Timestamp('20130101').to_pydatetime()>=df.A
Out[18]: 
0     True
1    False
Name: A, dtype: bool

In [20]: pd.Timestamp('20130101').to_pydatetime().date()>=df.A
ValueError: cannot set a Timestamp with a non-timestamp

[jbrockmendel]

What would date(2017, 10, 24) < Timestamp('2017-10-24 17:02') be?

[jreback]

These just need wrapping

In [7]: pd.Timestamp(datetime.date(2017, 10, 24)) < pd.Timestamp('2017-10-24 17:02')
Out[7]: True

[jbrockmendel]

I think the internally consistent thing to do would be to wrap date(2017, 10, 24) with pd.Period(date(2017, 10, 24), 'D')

(the constructor should also be able to infer the freq should be "D", but that is a different issue)

[jreback]

no it’s a Timestamp (conceptually it’s just a shortened datetime)

[jbrockmendel]

(conceptually it’s just a shortened datetime)

That part isn't obvious to me, but conditional on this, then I agree this issue is straightforward.

[TomAugspurger]

FWIW, python raises here

In [4]: datetime.datetime(2017, 1, 1, 12) > datetime.date(2017, 1, 1)
---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-4-c0cf43ef6360> in <module>()
----> 1 datetime.datetime(2017, 1, 1, 12) > datetime.date(2017, 1, 1)

TypeError: can't compare datetime.datetime to datetime.date