我有一個(gè)如下所示的數(shù)據(jù)框+---+-------------+---------+---------------+---------------+---------+------+--------------------------+-----+----------+| | Pregnancies | Glucose | BloodPressure | SkinThickness | Insulin | BMI | DiabetesPedigreeFunction | Age | Outcome |+---+-------------+---------+---------------+---------------+---------+------+--------------------------+-----+----------+| 0 | 6 | 148.0 | 72.0 | 35.0 | 125.0 | 33.6 | 0.627 | 50 | 1 || 1 | 1 | 85.0 | 66.0 | 29.0 | 125.0 | 26.6 | 0.351 | 31 | 0 || 2 | 8 | 183.0 | 64.0 | 29.0 | 125.0 | 23.3 | 0.672 | 32 | 1 || 3 | 1 | 89.0 | 66.0 | 23.0 | 94.0 | 28.1 | 0.167 | 21 | 0 || 4 | 0 | 137.0 | 40.0 | 35.0 | 168.0 | 43.1 | 2.288 | 33 | 1 |+---+-------------+---------+---------------+---------------+---------+------+--------------------------+-----+----------+看了每個(gè)變量的箱線圖后,我發(fā)現(xiàn)它們中有異常值。所以在每一列中,除了Outcome我想替換該特定列的值greater than 95 percentile with value at 75 percentile和值less than 5 percentile with 25 percentile例如,在Glucose高于 95 個(gè)百分位的列值中,我想用Glucose列的75 個(gè)百分位的值替換它們我怎樣才能用熊貓過(guò)濾器和百分位函數(shù)來(lái)做到這一點(diǎn)對(duì)此的任何幫助將不勝感激
Pandas 替換每列中的某些值
哆啦的時(shí)光機(jī)
2021-08-17 10:09:43