You can use the following basic syntax to round the values in a single column of a pandas DataFrame:
df.my_column = df.my_column.round()
The following example shows how to use this syntax in practice.
Example: Round a Single Column in Pandas DataFrame
Suppose we have the following pandas DataFrame that contains information about various athletes:
import pandas as pd #create DataFrame df = pd.DataFrame({'athlete': ['A', 'B', 'C', 'D', 'E', 'F'], 'time': [12.443, 15.8, 16.009, 5.06, 11.075, 12.9546], 'points': [5, 7, 7, 9, 12, 9]}) #view DataFrame print(df) athlete time points 0 A 12.4430 5 1 B 15.8000 7 2 C 16.0090 7 3 D 5.0600 9 4 E 11.0750 12 5 F 12.9546 9
We can use the following code to round each value in the time column to the nearest integer:
#round values in 'time' column of DataFrame
df.time = df.time.round()
#view updated DataFrame
print(df)
athlete time points
0 A 12.0 5
1 B 16.0 7
2 C 16.0 7
3 D 5.0 9
4 E 11.0 12
5 F 13.0 9
Each value in the time column has been rounded to the nearest integer.
For example:
- 12.443 has been rounded to 12.
- 15.8 has been rounded to 16.
- 16.009 has been rounded to 16.
And so on.
To round the values in a column to a specific number of decimal places, simply specify that value in the round() function.
For example, we can use the following code to round each value in the time column to two decimal places:
#round values in 'time' column to two decimal places
df.time = df.time.round(2)
#view updated DataFrame
print(df)
athlete time points
0 A 12.44 5
1 B 15.80 7
2 C 16.01 7
3 D 5.06 9
4 E 11.08 12
5 F 12.95 9
Each value in the time column has been rounded to two decimal places.
For example:
- 12.443 has been rounded to 12.44.
- 15.8 has been rounded to 15.80.
- 16.009 has been rounded to 1601.
And so on.
Also note that the values in the other numeric column, points, have remained unchanged.
Additional Resources
The following tutorials explain how to perform other common operations in pandas:
How to Print Pandas DataFrame with No Index
How to Show All Rows of a Pandas DataFrame
How to Check dtype for All Columns in Pandas DataFrame