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.