谁能告诉我怎么去除异常点方便

Question

import pandas as pd
df = pd.read_excel(r'C:\Users\1\Desktop\A剖面out\温度A5-10m.xlsx')
data = df['温度A5-10m'].values
for point in range(1, len(data) - 1):
if -10 > data[point] and data[point] > 40:
print(point)
df = df.drop([point])
if abs(data[point - 1] - data[point]) >= 1 and abs(data[point + 1] - data[point]) >= 1:
print(point)
df = df.drop([point])
df.to_excel(r'C:\Users\1\Desktop\新建文件夹\√温度A5-10m.xlsx',index = False)
我这个代码能实现同时两个if的条件吗？

Answer 1

if -10 > data[point] and data[point] > 40:
你第一个判断不对。应该是这样吧。判断在(-10,40)之间
if -10 < data[point] and data[point] < 40: