计算pandas数据帧中两个cols之间的时间差(秒)

import pandas as pd

# 创建一个示例数据帧
data = {'col1': ['2022-01-01 12:00:00', '2022-01-01 12:30:00', '2022-01-01 13:00:00'],
        'col2': ['2022-01-01 12:05:00', '2022-01-01 12:40:00', '2022-01-01 13:10:00']}
df = pd.DataFrame(data)

# 将cols转换为datetime类型
df['col1'] = pd.to_datetime(df['col1'])
df['col2'] = pd.to_datetime(df['col2'])

# 计算时间差（秒）
df['time_diff'] = (df['col2'] - df['col1']).dt.total_seconds()

# 打印结果
print(df)

                 col1                col2  time_diff
0 2022-01-01 12:00:00 2022-01-01 12:05:00      300.0
1 2022-01-01 12:30:00 2022-01-01 12:40:00      600.0
2 2022-01-01 13:00:00 2022-01-01 13:10:00      600.0