How to eliminate out outliers in a dataframe

0 votes
I want to find and replace outliers - values greater than (mean+/-2 STd) with mean. What logic should I use for this?
Jul 16, 2019 in Python by Ramya
2,154 views

1 answer to this question.

0 votes
There are various ways we can replace the outliers it depends on the type of data you have, suppose you have some data with one of the columns has values 1,2,3,6,3,2,4,987 Now if you see most of the values are very much close to each other but there is one value which is too large in this case we use standard scaler or min-max scaler to normalize it since for this column range is very high, you can also replace the outliers by applying a condition if value is greater than the mean value of the column then replace it by mean value but standard scaler recommend when your data size is very big,
answered Jul 16, 2019 by Dinesh

Related Questions In Python

–1 vote
2 answers
0 votes
1 answer

How to find if a value exists in Pandas dataframe?

Try this:​ for name in df['Name']: ...READ MORE

answered Apr 8, 2019 in Python by Tina
12,650 views
+1 vote
1 answer

How to find the index of a particular value in a dataframe?

First, use the dataframe to match the ...READ MORE

answered Apr 8, 2019 in Python by Esha
281,809 views
0 votes
1 answer
0 votes
2 answers
+1 vote
2 answers

how can i count the items in a list?

Syntax :            list. count(value) Code: colors = ['red', 'green', ...READ MORE

answered Jul 7, 2019 in Python by Neha
• 330 points

edited Jul 8, 2019 by Kalgi 4,463 views
0 votes
1 answer
+5 votes
6 answers

Lowercase in Python

You can simply the built-in function in ...READ MORE

answered Apr 11, 2018 in Python by hemant
• 5,790 points
4,119 views
0 votes
1 answer

How to eliminate out outliers in a dataframe?

There are various ways we can replace ...READ MORE

answered Jul 24, 2019 in Python by Shri
681 views
0 votes
1 answer

How to convert a Pandas GroupBy object to DataFrame in Python

g1 here is a DataFrame. It has a hierarchical index, ...READ MORE

answered Nov 12, 2018 in Python by Nymeria
• 3,560 points
34,465 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP