/Python/How to sort values of pandas dataframe for iqr

How to sort values of pandas dataframe for iqr

    def mod_outlier(df):
        df1 = df.copy()
        df = df._get_numeric_data()


        q1 = df.quantile(0.25)
        q3 = df.quantile(0.75)

        iqr = q3 - q1

        lower_bound = q1 -(1.5 * iqr) 
        upper_bound = q3 +(1.5 * iqr)


        for col in col_vals:
            for i in range(0,len(df[col])):
                if df[col][i] < lower_bound[col]:            
                    df[col][i] = lower_bound[col]

                if df[col][i] > upper_bound[col]:            
                    df[col][i] = upper_bound[col]    


        for col in col_vals:
            df1[col] = df[col]

        return(df1)

Source: stackoverflow.com

Similar codes

62 votes176 views5 answers
How to pick a random number in a list python
Python
1 vote209 views1 answer
How to iteratively create a grid within a bigger grid in python
Python
0 vote188 views3 answers
Python unittest mock
Python
0 vote193 views1 answer
Swift bool to string
Python
0 vote199 views2 answers
How to close a flask web server with python
Python
0 vote209 views1 answer
Tkinter file dialog multiple file types
Python
16 votes213 views2 answers
Select rows from dataframe pandas
Python
0 vote215 views1 answer
Django router multiple pk
Python Django
4 votes176 views1 answer
How to convert types of variablesin python
Python
0 vote187 views1 answer
Networkx node attribute from a dataframe
Python