异常值处理,如何删除或者是平移

在做数据处理的时候,如何清除如图所示异常数据,或者是将异常数据平移到正常值范围。

img

原始数据如附件。
Time Y_value
0 8.334648319
2.009 8.329447667
4.0164 8.330019174
6.0238 8.34289129
8.0368 8.34339202
10.0635 8.336637077
12.089 8.355545205
14.1151 8.351027679
16.1409 8.353194876
18.1905 8.349835047
20.2565 8.356659675
22.4903 8.358892592
24.5024 8.377242733
26.5096 8.363881022
28.6212 8.354571214
30.676 8.359299621
32.7439 8.363374969
34.8079 8.362663006
36.8725 8.449798133
38.9368 8.434405408
41.0012 8.430839545
43.0668 8.449909139
45.1308 8.452975224
47.3663 8.453654837
49.378 8.446723648
51.3855 8.454996746
53.5261 8.451699388
55.583 8.459266335
57.6362 8.463004345
59.6978 8.454244052
61.7591 8.464615598
63.8212 8.458822891
65.883 8.462481111
67.9446 8.467397386
70.006 8.454201752
72.2393 8.464445966
74.2509 8.465874275
76.2584 8.448554376
78.3682 8.473003777
80.4088 8.472582362
82.4704 8.474627823
84.5319 8.475031195
86.594 8.462816413
88.6553 8.455583189
90.7174 8.466240583
92.7781 8.466799516
95.7166 8.406592032
97.8327 8.411639546
99.8402 8.41325321
101.8477 8.411517995
103.8552 8.421324495
105.8628 8.420075341
107.8704 8.416246012
109.8776 8.423020173
111.8849 8.422538515
113.9279 8.429591872
115.9966 8.427650711
118.2209 8.418470768
120.4049 8.424056329
122.4536 8.43320195
124.5348 8.432419531
126.5956 8.431535378
128.6489 8.436634719
130.6977 8.435494069
132.7599 8.436479427
134.8227 8.437634886
136.8837 8.438616114
138.945 8.429458178
141.0137 8.442832933
143.2364 8.438406372
145.3301 8.438318189
147.3788 8.440760972
149.4399 8.442386633
151.5091 8.445511448
153.5634 8.446685574
155.6253 8.43793231
157.6875 8.443913013
159.7491 8.447627997
161.811 8.444297273
163.8727 8.446133935
165.9401 8.442519513
168.1618 8.447499177
170.2557 8.445812318
172.3038 8.455772574
174.3667 8.44539689
176.4305 8.45410526
178.4898 8.453064565
180.5525 8.455329245
182.6131 8.4519071
184.676 8.459894907
186.7377 8.451253026
188.8002 8.462705698
190.8679 8.454147197
193.0905 8.457469309
195.1979 8.454417781
197.2457 8.456066788
199.3073 8.464551387
201.3694 8.460991383
203.4308 8.460131766
205.4926 8.462923216

如果想弃用那部分异常数据,可以重新做一个数据表df2:
df2 = df [ df.Time<35 or df.Time>93 ]