temp = temp[temp[col].isnull()]
abnormal_index = temp.index.tolist()
len(df[df['load'].isnull()].index) ##空缺值个数
df2 = df.reset_index(drop=True)
df.loc[abnormal_index,"abnormal_flag"] = 1
df.loc[:, col].diff()
df["diff"].rolling(window=window - 1).sum()
df.drop(["diff", "roll"], axis=1, inplace=True)
temp.interpolate(method="linear",axis=0,inplace=True) ##axis=0是竖着按行填
df_res[cols]=df_res[cols].interpolate(method="linear",axis=0) ##选择自定义列填充
temp.fillna(method="ffill", axis=0,inplace=True)
temp.fillna(method="bfill", axis=0,inplace=True)
start_date=pd.to_datetime('2020/1/1',format
=
'%Y-%m-%d
)
time_delta=pd.Timedelta(5,unit='d')
start_date.strftime('%Y-%m-%d %H:%M:%S')
output=output.iloc[[i for i in range(2,len(output),3)]] ##按5min间隔转15min
df=pd.merge(df,time,on='date',how='right')
start=df[(df['date'].dt.hour==0) & (df['date'].dt.minute==0)].index[0]
end=df[(df['date'].dt.hour==23) & (df['date'].dt.minute==45)].index[-1]
df=df.iloc[start:end+1:3]