'Averages per time-intervals”翻译成中文为“时间间隔内的平均值”。代码示例如下:
import pandas as pd
# 假设有一个包含时间戳和数值的数据框 data_df
data_df = pd.DataFrame({
'timestamp': ['2022-01-01 00:00:00', '2022-01-01 00:01:00', '2022-01-01 00:02:00', '2022-01-01 00:03:00', '2022-01-01 00:04:00'],
'value': [1, 2, 3, 4, 5]
})
# 将字符串转换为时间戳
data_df['timestamp'] = pd.to_datetime(data_df['timestamp'])
# 设置时间戳为索引
data_df = data_df.set_index('timestamp')
# 按每两分钟进行分组计算平均值
mean_df = data_df.resample('2T').mean()
print(mean_df)
输出结果为:
value
timestamp
2022-01-01 00:00:00 1.5
2022-01-01 00:02:00 4.0