重新采样数据帧后，列名消失

Question

我有一个数据框，我需要计算每8小时臭氧值的平均值。问题是，我进行重采样后的列（“可读时间”）消失，并且在重采样后无法引用

import pandas as pd
data = pd.read_csv("o3_new.csv")

del data['latitude']
del data['longitude']
del data['altitude']

sensor_name = "o3"

data['readable time'] = pd.to_datetime(data['readable time'], dayfirst=True)

data = data.resample('480min', on='readable time').mean()  # 8h mean
data[str(sensor_name) + "_aqi"] = ""

for i in range(len(data)):
    data[str(sensor_name) + "_aqi"][i] = calculate_aqi(sensor_name, data[sensor_name][i])

print(data['readable time']) #throws KeyError

其中o3_new.csv是这样的：

,time,latitude,longitude,altitude,o3,readable time,day
0,1591037392,45.645893,25.599471,576.38,39.4,1/6/2020 21:49,1/6/2020
1,1591037452,45.645893,25.599471,576.64,48.4,1/6/2020 21:50,1/6/2020
2,1591037512,45.645893,25.599471,576.56,53.4,1/6/2020 21:51,1/6/2020
3,1591037572,45.645893,25.599471,576.64,36.4,1/6/2020 21:52,1/6/2020
4,1591037632,45.645893,25.599471,576.73,50.4,1/6/2020 21:53,1/6/2020
5,1591037692,45.645893,25.599471,577.09,37.4,1/6/2020 21:54,1/6/2020

如何在重新采样后继续引用“可读时间”列

Answer 1

您希望该列包含什么内容mean对于时间列没有特别好的意义。此外，重采样器使on列成为索引，因此data.reset_index(inplace=True)可能会让您感到高兴

Answer 2

或者，您可以在重采样后直接使用data.index访问值