在时间戳列pandas中添加和减去秒列

import pandas as pd

# 创建一个示例DataFrame
data = {
    'timestamp': ['2023-07-01 12:00:00', '2023-07-01 12:01:00', '2023-07-01 12:02:00'],
    'seconds': [10, -5, 30]
}
df = pd.DataFrame(data)

# 将'timestamp'列转换为datetime类型
df['timestamp'] = pd.to_datetime(df['timestamp'])

# 将'seconds'列转换为Timedelta类型
df['seconds_timedelta'] = pd.to_timedelta(df['seconds'], unit='s')

# 添加秒数
df['new_timestamp_add'] = df['timestamp'] + df['seconds_timedelta']

# 减去秒数
df['new_timestamp_subtract'] = df['timestamp'] - df['seconds_timedelta']

print(df)

            timestamp  seconds seconds_timedelta           new_timestamp_add           new_timestamp_subtract
0 2023-07-01 12:00:00      10             00:00:10 2023-07-01 12:00:10 2023-07-01 12:00:00
1 2023-07-01 12:01:00      -5             00:00:05 2023-07-01 12:00:55 2023-07-01 12:01:05
2 2023-07-01 12:02:00      30             00:00:30 2023-07-01 12:02:30 2023-07-01 12:01:30