How to round up a DataFrame in pandas

Overview

The round() function in pandas is used to round up a DataFrame to a specified number of decimal places.

Syntax

The round() function takes the syntax shown below:

DataFrame.round(decimals=0, *args, **kwargs)
Syntax for the round() function in Pandas

Parameter value

The round() function takes the following optional parameter values:

  • decimals: This takes an int value specifying the number of decimal places to round the values of the DataFrame.
  • *args, **kwargs: These are additional keywords that have no effect on the function but might be accepted for compatibility with the NumPy library.

Return value

The round() function returns a DataFrame holding the rounded values of the columns of the DataFrame.

Example

# A code to illustrate the round() functio in Pandas



# importing the pandas library

import pandas as pd



# creating a dataframe

df = pd.DataFrame([(.521, .132), (.019, .675), (.666, .033), (.555, .4489)],

                  columns=['col_1', 'col_2'])

print("Before dataframe")

print(df) # printing the dataframe

print("After dataframe")

# rounding up the values of the dataframe to 2 decimal places

print(df.round(2))

Explanation

  • Line 4: We import the pandas library.
  • Lines 7–8: We create a DataFrame, df.
  • Line 10: We print the DataFrame, df.
  • Line 13: We round the values of the DataFrame to 2 decimal places.
Free AI Mock Interviews
Coding Interview
Coding PatternsFree Interview
Gain insights and practical experience with coding patterns through targeted MCQs and coding problems, designed to match and challenge your expertise level.
System Design
You TubeFree Interview
Learn to design a video streaming platform like YouTube by tackling functional and non-functional requirements, core components, and high-level to detailed design challenges.

Free Resources

License: Creative Commons-Attribution-ShareAlike 4.0 (CC-BY-SA 4.0)