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

1 vote98 views1 answer
How to convert string to function name in python
Python
0 vote100 views1 answer
How to get all links from a google search using python
Python
16 votes90 views2 answers
Python removing \n from string
Python
17 votes136 views5 answers
Python add element to array
Python
0 vote99 views1 answer
Reportlab python add font style
Python
1 vote99 views2 answers
Get timestamp from string python
Python
3 votes116 views2 answers
Venv upgrade python
Python
11 votes108 views2 answers
Set os environment variable python
Python
7 votes103 views2 answers
Python cd to directory
Python
1 vote63 views1 answer
Create pyspark session with hive support
Python