
        
        
            
                
                
                    df = pd.DataFrame({"A":[2,4,6,8],"B":[5,6,7,8]})
df
                
            
               A  B
0  2  5
1  4  6
2  6  7
3  8  8

Column-wise

To compute the 25th percentile of each column:


        
        
            
                
                
                    df.quantile(0.25)
                
            
            A    3.50
B    5.75
Name: 0.25, dtype: float64

By default the quantile(~) method computes percentiles column-wise.

Row-wise

To compute the 50th percentile of each row:


        
        
            
                
                
                    df.quantile(q=0.5, axis=1)
                
            
            0    3.5
1    5.0
2    6.5
3    8.0
Name: 0.5, dtype: float64

By specifying axis=1 we compute the 50th percentile by row.

Multiple percentiles

To get the values at the 50th and 75th percentiles for each column:


        
        
            
                
                
                    df.quantile([0.5, 0.75])   # returns a DataFrame
                
            
                    A     B
0.50  5.0  6.50
0.75  6.5  7.25

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!