Methods to Round Values in Pandas DataFrame
There are various ways to Round Values in Pandas DataFrame so let’s see each one by one:
Let’s create a Dataframe with ‘Data Entry’ Column only:
Code:
Python3
from pandas import DataFrame
import numpy as np
Myvalue = { 'DATA ENTRY' : [ 4.834327 , 5.334477 ,
6.89 , 7.6454 , 8.9659 ]}
df = DataFrame(Myvalue,
columns = [ 'DATA ENTRY' ])
df
|
Output:
Method 1: Using numpy.round().
Syntax: numpy.round_(arr, decimals = 0, out = None)
Return: An array with all array elements being
rounded off, having same type as input.
This method can be used to round value to specific decimal places for any particular column or can also be used to round the value of the entire data frame to the specific number of decimal places.
Example: Rounding off the value of the “DATA ENTRY” column up to 2 decimal places.
Python3
from pandas import DataFrame
import numpy as np
Myvalue = { 'DATA ENTRY' : [ 4.834327 , 5.334477 ,
6.89 , 7.6454 , 8.9659 ]}
df = DataFrame(Myvalue,
columns = [ 'DATA ENTRY' ])
roundplaces = np. round (df[ 'DATA ENTRY' ],
decimals = 2 )
roundplaces
|
Output:
Method 2: Using Dataframe.apply() and numpy.ceil() together.
Syntax: Dataframe/Series.apply(func, convert_dtype=True, args=())
Return: Pandas Series after applied function/operation.
Syntax: numpy.ceil(x[, out]) = ufunc ‘ceil’)
Return: An array with the ceil of each element of float data-type.
These methods are used to round values to ceiling value(smallest integer value greater than particular value).
Example: Rounding off the value of a particular column.
Python3
from pandas import DataFrame
import numpy as np
Myvalue = { 'DATA ENTRY' : [ 4.834327 , 5.334477 ,
6.89 , 7.6454 , 8.9659 ]}
df = DataFrame(Myvalue,
columns = [ 'DATA ENTRY' ])
roundUp = df[ 'DATA ENTRY' ]. apply (np.ceil)
roundUp
|
Output:
Method 3: Using Dataframe.apply() and numpy.floor() together.
Syntax: numpy.floor(x[, out]) = ufunc ‘floor’)
Return: An array with the floor of each element.
These methods are used to round values to floor value(largest integer value smaller than particular value).
Example: Rounding off the value of the “DATA ENTRY” column to its corresponding Floor value.
Python3
from pandas import DataFrame
import numpy as np
Myvalue = { 'DATA ENTRY' :[ 4.834327 , 5.334477 ,
6.89 , 7.6454 , 8.9659 ] }
df = DataFrame(Myvalue,
columns = [ 'DATA ENTRY' ])
rounddown = df[ 'DATA ENTRY' ]. apply (np.floor)
rounddown
|
Output:
Last Updated :
18 Aug, 2020
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...