Python之dataframe修改异常值—按行判断值是否大于平均值的指定倍数，如果是则用左右值替换

 serise用数字下标索引

 

 

import pandas as pd

data = {'hah':[1,2,9],
       '数量':[3,2,5],
       '价格':[10,9,8]}
df = pd.DataFrame(data)
df

import numpy as np
def panduan(x):
    x_mean = np.mean(x)
    print(x_mean)
    for i in range(0,len(x)):
        print(x[i])
        if x[i] > x_mean*2:
            if i==0:
                x[i] = x_mean
            elif i==(len(x)-1):
                x[i] = x_mean
            else:
                x[i] = (x[i-1]+x[i+1])/2
    return x 

df = df.apply(lambda x:panduan(x),axis=1)