IQR to remove outlier

np.random.seed(33454)
stepframe = pd.DataFrame({'a': np.random.randint(1, 200, 20), 
                          'b': np.random.randint(1, 200, 20),
                          'c': np.random.randint(1, 200, 20)})

stepframe[stepframe > 150] *= 10
print (stepframe)

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

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

print (df)
      a    b     c
1   109   50   124
3   137   60  1990
4    19  138   100
5    86   83   143
6    55   23    58
7    78  145    18
8   132   39    65
9    37  146  1970
13   67  148  1880
15  124  102    21
16   93   61    56
17   84   21    25
19   34   52   126

Source: stackoverflow.com

Similar codes

0 vote199 views1 answer
Run django using nssm
Python
4 votes209 views2 answers
Levenshtein distance
Python
6 votes292 views1 answer
Button in flask
Python Flask
2 votes187 views1 answer
Lexicographic order python
Python
25 votes186 views3 answers
Ndarray to list
Python
0 vote234 views1 answer
If the value is not in dict return default
Python
7 votes247 views1 answer
Python if else short version
Python
-3 votes201 views1 answer
ValueError: With n_samples=0, test_size=0.2 and train_size=None, the resulting train set will be empty. Adjust any of the aforementioned parameters.
Python
3 votes235 views1 answer
How set dely in python
Python
4 votes199 views1 answer
String pick the first 2 characters python
Python