#🔒 I want to remove the Outliers from my df

4 messages · Page 1 of 1 (latest)

clear moon
#

I got this code from chatGPT, but how can i verify that the outliers have actually been removed?

import pandas as pd
import numpy as np

Read the data

df = pd.read_csv('clean_Dataset.csv', delimiter=',')

Function to remove outliers using the IQR method

def remove_outliers_iqr(data):
q1 = np.percentile(data, 25)
q3 = np.percentile(data, 75)
iqr = q3 - q1
lower_bound = q1 - 1.5 * iqr
upper_bound = q3 + 1.5 * iqr
filtered_data = data[(data >= lower_bound) & (data <= upper_bound)]
return filtered_data

Iterate over each numerical column in the DataFrame

for column in df.select_dtypes(include=np.number):
df[column] = remove_outliers_iqr(df[column])

Display the cleaned DataFrame

display(df)

sly nacelleBOT
#

@clear moon

Python help channel opened

Remember to:

  • Ask your Python question, not if you can ask or if there's an expert who can help.
  • Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
  • Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.
sly nacelleBOT
#

@clear moon

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.