在datetime和Pandas之间转换Timestamp对象 [英] Converting between datetime and Pandas Timestamp objects
本文介绍了在datetime和Pandas之间转换Timestamp对象的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有以下内容:
> date1
时间戳('2014-01-23 00:00:00',tz =无)
> date2
datetime.date(2014,3,26)
,我在这个答案,我可以使用 pandas.to_datetime()
从时间戳
到 datetime
对象,但似乎不起作用:
> pd.to_datetime(date1)
时间戳('2014-01-23 00:00:00',tz =无)
为什么?如何在这两种格式之间进行转换?
解决方案
您可以使用to_pydatetime方法更加明确:
在[11]中:ts = pd.Timestamp('2014-01-23 00:00:00',tz = None)
/ pre>
在[12]中:ts.to_pydatetime()
Out [12]:datetime.datetime(2014,1,23,0,0)
它也可以在DatetimeIndex上使用:
在[ 13]:rng = pd.date_range('1/10/2011',periods = 3,freq ='D')
在[14]中:rng.to_pydatetime()
出[14]:
数组([datetime.datetime(2011,1,10,0,0),
datetime.datetime(2011,1,1 11,0,0),
datetime .datetime(2011,1,12,0,0)],dtype = object)
I have the following:
> date1 Timestamp('2014-01-23 00:00:00', tz=None) > date2 datetime.date(2014, 3, 26)
and I read on this answer that I could use
pandas.to_datetime()
to convert fromTimestamps
todatetime
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?
解决方案You can use the to_pydatetime method to be more explicit:
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)
It's also available on a DatetimeIndex:
In [13]: rng = pd.date_range('1/10/2011', periods=3, freq='D') In [14]: rng.to_pydatetime() Out[14]: array([datetime.datetime(2011, 1, 10, 0, 0), datetime.datetime(2011, 1, 11, 0, 0), datetime.datetime(2011, 1, 12, 0, 0)], dtype=object)
这篇关于在datetime和Pandas之间转换Timestamp对象的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文