Converting between datetime and Pandas Timestamp objects

Question

I have the following:

> date1

Timestamp('2014-01-23 00:00:00', tz=None)

> date2

datetime.date(2014, 3, 26)

and I could use pandas.to_datetime() to convert from Timestamps to datetime objects, but it doesn't seem to work:

> pd.to_datetime(date1)   

Timestamp('2014-01-23 00:00:00', tz=None)

Why? How can I convert between these two formats?

Answer 1

You can simply use the to_pydatetime function to be more explicit, refer the following code:

In [11]: ts = pd.Timestamp('2014-01-23 00:00:00', tz=None)

In [12]: ts.to_pydatetime()

Out[12]: datetime.datetime(2014, 1, 23, 0, 0)

If you want to learn more about Pandas then visit this Python Course designed by the industrial experts.