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

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的条件吗？

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

使用pandas的条件判断语句取数较为方便。示例代码如下：‘

import pandas as pd 

df =pd.DataFrame({'v':[10,-12,50,36]})
d=df[(df.v>40)|(df.v<-10)]
df=df.drop(d.index)
#     df=df.drop(['v'])
print(df)
‘’‘
v
0  10
3  36
’‘’