Pandas calculate iqr

# Removing the outliers
def removeOutliers(data, col):
    Q3 = np.quantile(data[col], 0.75)
    Q1 = np.quantile(data[col], 0.25)
    IQR = Q3 - Q1
 
    print("IQR value for column %s is: %s" % (col, IQR))
    global outlier_free_list
    global filtered_data
 
    lower_range = Q1 - 1.5 * IQR
    upper_range = Q3 + 1.5 * IQR
    outlier_free_list = [x for x in data[col] if (
        (x > lower_range) & (x < upper_range))]
    filtered_data = data.loc[data[col].isin(outlier_free_list)]
 
 
for i in data.columns:
      if i == data.columns[0]:
      removeOutliers(data, i)
    else:
      removeOutliers(filtered_data, i)
 
  
# Assigning filtered data back to our original variable
data = filtered_data
print("Shape of data after outlier removal is: ", data.shape)

Source: geeksforgeeks.org

Similar codes

0 vote176 views1 answer
Python code to demonstrate inheritance
Python
0 vote194 views1 answer
ImportError: cannot import name 'clock' from 'time' (unknown location)
Python
0 vote199 views1 answer
Django serialize a get object is not iterable
Python Django
6 votes171 views3 answers
Python create environment linux
Python
0 vote179 views1 answer
Show all of a truncated dataframe jupyter"
Python
3 votes174 views1 answer
N unique random numbers in python
Python
0 vote164 views1 answer
How to know if i'm in a virtual environment
Python
0 vote173 views1 answer
Default orange and blue matplotlib
Python
10 votes177 views4 answers
How to know if python is 64 or 32 bit
Python
33 votes145 views4 answers
Sort and reverse list in python
Python