Delete outliers in pandas

cols = ['col_1', 'col_2'] # one or more

Q1 = df[cols].quantile(0.25)
Q3 = df[cols].quantile(0.75)
IQR = Q3 - Q1

df = df[~((df[cols] < (Q1 - 1.5 * IQR)) |(df[cols] > (Q3 + 1.5 * IQR))).any(axis=1)]

Source: stackoverflow.com

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

Delete outliers in pandas

Q1 = df.quantile(0.25)
Q3 = df.quantile(0.75)
IQR = Q3 - Q1

df = df[~((df < (Q1 - 1.5 * IQR)) |(df > (Q3 + 1.5 * IQR))).any(axis=1)]

Source: stackoverflow.com

Similar codes

5 votes212 views2 answers
Get_object_or_404 django
Python Django
0 vote166 views1 answer
Python show interpreter path
Python
95 votes220 views6 answers
Check if string contains python
Python
0 vote229 views1 answer
Credential not provided when i try to sign up a new user django
Python Django
0 vote169 views1 answer
Load Data From JSON PYQT5
Python
3 votes157 views1 answer
How to set index pandas
Python
-1 vote170 views1 answer
Show dataframe pandas python
Python
50 votes189 views1 answer
How to find item in list python without indexnig
Python
0 vote185 views1 answer
Odoo order by xml rpc
Python
2 votes183 views2 answers
How to convert csv into list
Python