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 vote215 views1 answer
Add a new categorical column to an existing table python
Python
1 vote265 views2 answers
Django unique_together
Python Django
3 votes174 views1 answer
Pandas groupby column count distinct values
Python
0 vote205 views1 answer
Reference other libraries in library
Python
13 votes199 views5 answers
Prime number program in python using function
Python
0 vote197 views1 answer
Add up all the numbers in each row and output that number output the grand total of all rows
Python
1 vote180 views1 answer
Python months between two dates
Python
21 votes269 views6 answers
Python avg
Python
6 votes225 views2 answers
Docker flask
Python Flask
0 vote260 views2 answers
Fibbonachi python
Python