时间戳-如何使用groupby计算以秒为单位的时间差

import pandas as pd

# 创建一个包含时间戳的DataFrame
data = {'timestamp': [1627833600, 1627833601, 1627833603, 1627833605, 1627833608]}
df = pd.DataFrame(data)

# 将时间戳转换为日期时间格式
df['timestamp'] = pd.to_datetime(df['timestamp'], unit='s')

# 计算每个时间戳与前一个时间戳的时间差
df['time_diff'] = df.groupby(pd.Grouper(freq='S'))['timestamp'].diff()

# 输出结果
print(df)

            timestamp       time_diff
0 2021-08-02 00:00:00             NaT
1 2021-08-02 00:00:01 0 days 00:00:01
2 2021-08-02 00:00:03 0 days 00:00:02
3 2021-08-02 00:00:05 0 days 00:00:02
4 2021-08-02 00:00:08 0 days 00:00:03