q1 = df['column'].quantile(0.25) q3 = df['column'].quantile(0.75) iqr = q3 - q1 df.loc[df['column'] > (q3 + 1.5 * iqr) | df['column'] < (q1 - 1.5 * iqr), 'column'] = df['column'].mean()