Python Pandas – 对 TimeDeltaIndex 做毫秒级频率的 ceil 运算

要对毫秒级频率的 TimeDeltaIndex 做 ceil 运算，使用 TimeDeltaIndex.ceil() 方法，并传入 freq 参数，其值设置为 ‘ms’ 。

首先，导入所需的库：-

import pandas as pd

创建一个 TimeDeltaIndex 对象。我们使用 ‘data’ 参数设置 timedelta 类似的数据:-

tdIndex = pd.TimedeltaIndex(data =['4 day 8h 20min 35us 45ns', '+17:42:19.999999',
'9 day 3h 08:16:02.000055', '+22:35:25.000075'])

显示 TimedeltaIndex:-

print("TimedeltaIndex...\n", tdIndex)

对毫秒级频率的 TimeDeltaIndex 做 ceil 运算。对于毫秒级频率，我们使用“ms”:-

print("\nPerforming Ceil operation with milliseconds frequency...\n",
tdIndex.ceil(freq='ms'))

示例

代码如下:-

import pandas as pd

# Create a TimeDeltaIndex object
# We have set the timedelta-like data using the 'data' parameter
tdIndex = pd.TimedeltaIndex(data =['4 day 8h 20min 35us 45ns', '+17:42:19.999999',
'9 day 3h 08:16:02.000055', '+22:35:25.000075'])

# 显示 TimedeltaIndex
print("TimedeltaIndex...\n", tdIndex)

# 返回 TimeDeltas 的各个组成部分的数据帧
print("\nThe Dataframe of the components of TimeDeltas...\n", tdIndex.components)

# 对毫秒级频率的 TimeDeltaIndex 做 ceil 运算。对于毫秒级频率，我们使用“ms”
print("\nPerforming Ceil operation with milliseconds frequency...\n",
tdIndex.ceil(freq='ms'))

输出

这会产生以下代码:-

TimedeltaIndex...
TimedeltaIndex(['4 days 08:20:00.000035045', '0 days 17:42:19.999999',
'9 days 11:16:02.000055', '0 days 22:35:25.000075'],
dtype='timedelta64[ns]', freq=None)

The Dataframe of the components of TimeDeltas...
   days hours minutes seconds milliseconds microseconds nanoseconds
0    4     8      20      0            0           35           45
1    0    17      42     19          999          999            0
2    9    11      16      2            0           55            0
3    0    22      35     25            0           75            0

Performing Ceil operation with milliseconds frequency...
TimedeltaIndex(['4 days 08:20:00.001000', '0 days 17:42:20',
'9 days 11:16:02.001000', '0 days 22:35:25.001000'],
dtype='timedelta64[ns]', freq=None)