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

3 votes161 views3 answers
Python thread with parameters
Python
15 votes157 views3 answers
Python list.pop()
Python
1 vote150 views1 answer
Min max scaler sklearn
Python
0 vote171 views1 answer
Pandas read chunk of csv
Python
0 vote158 views1 answer
How to write a table from 1 to 10 with for loop in fython in 3 lines
Python
0 vote146 views1 answer
Set permissions role discord.py
Python
1 vote153 views1 answer
If a number times a number is true python
Python
0 vote148 views1 answer
How to open ndjson file in python
Python
0 vote172 views1 answer
List comprehension odd numbers python
Python
0 vote165 views1 answer
Jupyter notebook print all rows dataframe
Python