从原点和偏移创建DatetimeIndex

Question

我想把一组秒转换成适合数据帧的索引

我想我在寻找dt.total_seconds()操作的逆运算，就像Accessing total_seconds() in pandas data column的https://stackoverflow.com/a/36156620/1653571答案一样

给出：

t0="2010-10-01 00:00:00 UTC"
seconds = [0,1,2,3,5,7,11,13]

我想要这样的东西：

ii = pd.DatetimeIndex( ???(t0,seconds))

Answer 1

将seconds列表转换为Timedelta，并执行一点datetime算法

# origin           + offset
pd.to_datetime(t0) + pd.to_timedelta(seconds, unit='s')

DatetimeIndex(['2010-10-01 00:00:00+00:00', '2010-10-01 00:00:01+00:00',
               '2010-10-01 00:00:02+00:00', '2010-10-01 00:00:03+00:00',
               '2010-10-01 00:00:05+00:00', '2010-10-01 00:00:07+00:00',
               '2010-10-01 00:00:11+00:00', '2010-10-01 00:00:13+00:00'],
              dtype='datetime64[ns, UTC]', freq=None)