/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

0 vote331 views1 answer
Python Entry default text
Python
0 vote252 views1 answer
Update cell in sheet by column name using pandas
Python
1 vote307 views1 answer
Solution TypeError: can’t multiply sequence by non-int of type ‘float’
Python
-1 vote274 views1 answer
Create excel file python
Python
13 votes267 views5 answers
Pandas Set index
Python
2 votes272 views3 answers
Check nan values in a np array
Python
-2 votes263 views1 answer
How to comment out lines of code in python
Python
8 votes283 views2 answers
Python get public ip address
Python
0 vote322 views1 answer
Mad libs game prompt python
Python
-1 vote269 views2 answers
How to decode json python
Python