Remove outliers python pandas

#------------------------------------------------------------------------------
# accept a dataframe, remove outliers, return cleaned data in a new dataframe
# see http://www.itl.nist.gov/div898/handbook/prc/section1/prc16.htm
#------------------------------------------------------------------------------
def remove_outlier(df_in, col_name):
    q1 = df_in[col_name].quantile(0.25)
    q3 = df_in[col_name].quantile(0.75)
    iqr = q3-q1 #Interquartile range
    fence_low  = q1-1.5*iqr
    fence_high = q3+1.5*iqr
    df_out = df_in.loc[(df_in[col_name] > fence_low) & (df_in[col_name] < fence_high)]
    return df_out

Source: stackoverflow.com

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

Remove outliers python dataframe

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

Remove outliers python 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

Pandas remove outliers

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

Pandas removing outliers from dataframe

df[(df["col"] >= x ) & (df["col"] <= y )]

but it's more readable to use:

df[df["col"].between(x,y)]

Source: app.dataquest.io

Similar codes

0 vote126 views2 answers
Module 'matplotlib' has no attribute 'xlabel'
Python
0 vote122 views1 answer
How t o add dataframe python
Python
21 votes116 views6 answers
Pygame install
Python
1 vote143 views4 answers
Join tables in django orm
Python
0 vote148 views1 answer
Input function in django
Python Django
0 vote120 views1 answer
Form valid django created by
Python
6 votes158 views3 answers
Pandas to csv without header
Python
-1 vote79 views1 answer
Attributeerror: module 'numpy' has no attribute 'length'
Python
3 votes148 views2 answers
Print first word of a string python and return it
Python
0 vote121 views1 answer
Nlp.Defaults.stop_words.add spacy
Python