只保留时间增量中的 hh:mm:ss [英] Keeping just the hh:mm:ss from a time delta

问题描述

我有一列 timedeltas，其中列出了 here.我希望 Pandas 表中的输出来自:

I have a column of timedeltas which have the attributes listed here. I want the output in my pandas table to go from:

1 day, 13:54:03.0456

到:

13:54:03

如何从此输出中删除日期?

How can I drop the date from this output?

推荐答案

您可以使用 dt.seconds 获取一天中的秒数，然后将其传递给 pd.Timedelta:

You could get seconds of the day with dt.seconds and then pass that to pd.Timedelta:

from pandas import Series, date_range
from datetime import timedelta
td = Series(date_range('20130101',periods=4)) - Series(date_range('20121201',periods=4))
td[2] += timedelta(minutes=5,seconds=3)

In [321]: td
Out[321]: 
0   31 days 00:00:00
1   31 days 00:00:00
2   31 days 00:05:03
3   31 days 00:00:00
dtype: timedelta64[ns]

In [322]: td.dt.seconds.apply(lambda x: pd.Timedelta(seconds=x))
Out[322]: 
0   00:00:00
1   00:00:00
2   00:05:03
3   00:00:00
dtype: timedelta64[ns]

这篇关于只保留时间增量中的 hh:mm:ss的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！