pandas删除异常值

107 阅读 0 评论 71 点赞

我是靠谱客的博主深情柜子，这篇文章主要介绍pandas删除异常值，现在分享给大家，希望可以做个参考。

pandas初步删除明显错误的值，对数据做初步清洗

复制代码

def del_error_data(self, data):
data = data[data.IAS.between(0, 70, inclusive=True)]
data = data[data.Throttle.between(0, 115, inclusive=True)]
data = data[data.Rev.between(1, 6200, inclusive=True)]
data = data[data.AirBoxPres.between(0, 1500, inclusive=True)]
data = data[data.AmbientPres.between(300, 1100, inclusive=True)]
data = data[data.AirBoxTemp.between(-40, 96, inclusive=True)]
data = data[data.ServoLevel.between(0, 110, inclusive=True)]
data = data[data.SetPres.between(0, 1500, inclusive=True)]
data = data[data.AdjTemp.between(0, 1500, inclusive=True)]
data = data[data.CHT2.between(-40, 120, inclusive=True)]
data = data[data.CHT3.between(-40, 120, inclusive=True)]
data = data[data['Oil Temp'].between(-40, 130, inclusive=True)]
data = data[data['Inlet Temp'].between(-40, 50, inclusive=True)]
data = data[data['Oil Press'].between(0, 7, inclusive=True)]
data = data[data.EGT1.between(0, 950, inclusive=True)]
data = data[data.EGT2.between(0, 950, inclusive=True)]
data = data[data.EGT3.between(0, 950, inclusive=True)]
data = data[data.EGT4.between(0, 950, inclusive=True)]
return data

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

def del_error_data(self, data):
data = data[data.IAS.between(0, 70, inclusive=True)]
data = data[data.Throttle.between(0, 115, inclusive=True)]
data = data[data.Rev.between(1, 6200, inclusive=True)]
data = data[data.AirBoxPres.between(0, 1500, inclusive=True)]
data = data[data.AmbientPres.between(300, 1100, inclusive=True)]
data = data[data.AirBoxTemp.between(-40, 96, inclusive=True)]
data = data[data.ServoLevel.between(0, 110, inclusive=True)]
data = data[data.SetPres.between(0, 1500, inclusive=True)]
data = data[data.AdjTemp.between(0, 1500, inclusive=True)]
data = data[data.CHT2.between(-40, 120, inclusive=True)]
data = data[data.CHT3.between(-40, 120, inclusive=True)]
data = data[data['Oil Temp'].between(-40, 130, inclusive=True)]
data = data[data['Inlet Temp'].between(-40, 50, inclusive=True)]
data = data[data['Oil Press'].between(0, 7, inclusive=True)]
data = data[data.EGT1.between(0, 950, inclusive=True)]
data = data[data.EGT2.between(0, 950, inclusive=True)]
data = data[data.EGT3.between(0, 950, inclusive=True)]
data = data[data.EGT4.between(0, 950, inclusive=True)]
return data