Outliers removal

Outliers removal pandas

df = pd.DataFrame(np.random.randn(100, 3))

from scipy import stats
df[(np.abs(stats.zscore(df)) < 3).all(axis=1)]

Source: stackoverflow.com

Outlier removal

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()

Outliers removal

#Removing outliers first then skewness
from scipy.stats import zscore
z=abs(zscore(df))
print(z.shape)
df=df[(z<3).all(axis=1)]
df.shape

Similar codes

0 vote159 views1 answer
No python 3.10 installation was detected
Python
0 vote183 views1 answer
Django get latest object
Python Django
-2 votes197 views1 answer
Python merge list no duplicates
Python
2 votes170 views1 answer
From Crypto.Cipher import AES ModuleNotFoundError: No module named 'Crypto'
Python
1 vote158 views1 answer
Python Enemy NPC CLass
Python
24 votes160 views2 answers
Python for loop one line
Python
0 vote171 views1 answer
Python - convert a list column into miltiple columns
Python
4 votes228 views6 answers
Eval function in python
Python
0 vote182 views1 answer
How to search for a data in excel pandas
Python
0 vote174 views1 answer
Multi-line comments Python Example
Python