
        
        
            
                
                
                    import pandas as pd
df = pd.DataFrame({"A":[1.05,2.42],"B":[3.45,4.9]})
df
                
            
               A     B
0  1.05  3.45
1  2.42  4.90

Single column

To round only column "A" to the nearest integer:


        
        
            
                
                
                    df.round({"A":0})
                
            
                 A     B
0  1.0  3.45
1  2.0  4.90

To round column "B" to the nearest tenth, supply 1 as the argument:


        
        
            
                
                
                    df.round({"B":1})
                
            
                  A    B
0  1.05  3.4
1  2.42  4.9

WARNING

Numbers ending in 5 will be rounded down. Here we see 3.45 in column "B" was rounded down to 3.4 instead of rounding up.

Entire DataFrame

Consider the following DataFrame:


        
        
            
                
                
                    import pandas as pd
df = pd.DataFrame({"A":[1.05,2.42],"B":[3.45,4.9]})
df
                
            
               A     B
0  1.05  3.45
1  2.42  4.90

To round the entire DataFrame to the nearest integer:


        
        
            
                
                
                    df.round()
                
            
               A    B
0  1.0  3.0
1  2.0  5.0

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!