需求:需要将间隔为1小时的数据通过线性插值转为以5分钟为间隔的数据
思路:利用pandas,先进行重采样,再进行线性插值即可,最后将数据以表格形式输出。
#Copyright (c) 2021 XiaoxiaoLiang. All rights reserved.
import pandas as pd
df = pd.read_excel(r"D:\Testnumber\PM10day.xlsx",sheet_name='PM10')
df.index = pd.period_range('2021/6/1 8:00:00',freq="H",periods=11)
#重采样
df = df.resample('5min',convention='start').asfreq()
#线性插值
df = df.interpolate()
print(df)
#输出表格
writer = pd.ExcelWriter('D:\Testnumber\PM10results8.xlsx')
df.to_excel(writer)
writer.save()
writer.close()
一切文章皆为原创,转载请注明来源@小小梁的实验室