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

5 votes287 views4 answers
Python get last key in dict
Python
2 votes274 views1 answer
Returns the smallest positive integer python
Python
0 vote271 views1 answer
Showing specific columns pandas
Python
18 votes283 views6 answers
Pd.set_option('display.max_columns' none)
Python
22 votes282 views4 answers
Python is float
Python
7 votes266 views2 answers
Python duplicate file
Python
0 vote287 views1 answer
Plt tight layout
Python
27 votes264 views6 answers
Get all file in folder Python
Python
0 vote235 views1 answer
How to sort subset of rows in pandas df
Python
0 vote260 views1 answer
How to check for empty dataframe
Python