Pandas Convert Timestamp to datetime date

Question

I have a pandas column of Timestamp data  In  27   train  Original Quote Date   6   Out 27   Timestamp  2013-12-25 00 00 00     How can check equivalence of these objects to datetime date objects of the type  datetime date 2013  12  25

User · Answer

Assume time column is in timestamp integer msec format

1 day = 86400000 ms

Here you go:

day_divider = 86400000

df['time'] = df['time'].values.astype(dtype='datetime64[ms]') # for msec format

df['time'] = (df['time']/day_divider).values.astype(dtype='datetime64[D]') # for day format

User · Answer

As of pandas 0 20 3  use  to pydatetime   to convert any pandas DateTimeIndex instances to Python datetime datetime

User · Answer

Use the  date method   In  11   t   pd Timestamp  2013-12-25 00 00 00    In  12   t date   Out 12   datetime date 2013  12  25   In  13   t date      datetime date 2013  12  25  Out 13   True     To compare against a DatetimeIndex  i e  an array of Timestamps   you ll want to do it the other way around   In  21   pd Timestamp datetime date 2013  12  25   Out 21   Timestamp  2013-12-25 00 00 00    In  22   ts   pd DatetimeIndex  t    In  23   ts    pd Timestamp datetime date 2013  12  25   Out 23   array   True   dtype bool

User · Answer

You can convert a datetime date object into a pandas Timestamp like this      usr bin env python3   coding  utf-8  import pandas as pd import datetime    create a datetime data object d time   datetime date 2010  11  12     create a pandas Timestamp object t stamp   pd to datetime  2010 11 12      cast  datetime timestamp  as Timestamp object and compare d time2t stamp   pd to datetime d time     print to double check print d time  print t stamp  print d time2t stamp     since the conversion succeds this prints  True  print d time2t stamp    t stamp

[python] Pandas: Convert Timestamp to datetime.date

Examples related to python

Examples related to datetime

Examples related to pandas

Examples related to timestamp