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
Jul 24 in Python by Lohit
52 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 24 by Shri

Related Questions In Python

0 votes
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 in Python by Tina
3,310 views
0 votes
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 in Python by Esha
1,097 views
0 votes
1 answer
+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 6 in Python by Neha
• 330 points

edited Jul 8 by Kalgi 399 views
+4 votes
6 answers
0 votes
1 answer

How to eliminate out outliers in a dataframe?

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

answered Jul 16 in Python by Dinesh
274 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,520 points
9,117 views