Round numbers¶
Round decimal numbers in one or several columns using round, floor, or ceil.
Options¶
Column
Apply rounding to numbers in the following:
A single column
An explicit list of columns
All columns matching a regex pattern
All columns
Rounding mode
Select how to round numbers:
Round: Round the number to the specified significant digit.
Floor: Round the number down, or toward zero.
Ceil: Round the number up, or away from zero.
Significant digits
Control the precision of the number. 1234.5
with 2 significant digits is 1200
. Using 0 means the number is unbounded and keeps all significant digits.
Decimal places
How many numbers to show after the decimal point. 1.234
with 1 decimal place is 1.2
. Using 0 rounds to the integer; -2 rounds to the hundreds.