Number Transforms
The Numbers transforms allow users to perform arithmetic, rounding, scaling, and numeric feature engineering on numeric columns in datasets.
Ceiling Columns
Computes the ceiling value of a numeric column—the smallest integer greater than or equal to the input.
Best Situations to Use
Round numeric values up for threshold calculations.
Prepare whole-number datasets from continuous values.
Steps
Select a numeric column.
Open Transforms > Numbers > Ceiling Columns.
Click Submit.
Max
Computes the row-wise maximum across selected numeric columns.
Best Situations to Use
Identify the largest values per row for comparison or aggregation.
Create features representing maximum metrics across multiple measures.
Steps
Select multiple numeric columns.
Open Transforms > Numbers > Max.
Click Submit.
Mean
Computes the row-wise average of selected numeric columns.
Best Situations to Use
Generate average metrics across multiple columns.
Create features for trend analysis or aggregation.
Steps
Select multiple numeric columns.
Open Transforms > Numbers > Mean.
Click Submit.
Min
Computes the row-wise minimum across selected numeric columns.
Best Situations to Use
Identify the smallest values per row for comparison or analysis.
Steps
Select multiple numeric columns.
Open Transforms > Numbers > Min.
Click Submit.
Negate
Flips the sign of numeric values in a column.
Best Situations to Use
Reverse polarity of numeric features.
Standardize the direction of measurements for analysis.
Steps
Select a numeric column.
Open Transforms > Numbers > Negate.
Enable Create New Column (optional).
Provide a New Column Name.
Click Submit.
Number Names
Converts integer values into written word representation, supporting Western or South Asian formats.
Best Situations to Use
Prepare numerical columns for textual reports.
Convert IDs or amounts into words for presentation purposes.
Steps
Select an integer column.
Open Transforms > Numbers > Number Names.
Enable Create New Column.
Select Number Format: Western or South Asian.
Click Submit.
Remove Fractional Part
Removes the decimal part of numeric values, keeping only the integer component.
Best Situations to Use
Convert floats to whole numbers for reporting or aggregation.
Steps
Select a numeric column.
Open Transforms > Numbers > Remove Fractional Part.
Enable Create New Column (optional).
Provide a New Column Name.
Click Submit.
Round Multiple Columns Using Floor Mode
Rounds numeric values down to the nearest integer or specified decimal place.
Best Situations to Use
Round multiple columns consistently downwards for aggregation or normalization.
Steps
Select numeric columns.
Open Transforms > Numbers > Round Multiple Columns Using Floor Mode.
Set Precision.
Click Submit.
Round Value Using Ceil Mode
Rounds numeric values up to the nearest integer or specified decimal place.
Best Situations to Use
Round numbers consistently upwards for thresholds or budgeting calculations.
Steps
Select a numeric column.
Open Transforms > Numbers > Round Value Using Ceil Mode.
Enable Create New Column (optional).
Set Precision.
Click Submit.
Round Value Using Down Mode
Rounds numeric values down without considering decimal fractions for the specified precision.
Best Situations to Use
Floor numeric values to reduce precision for analysis or reporting.
Steps
Select a numeric column.
Open Transforms > Numbers > Round Value Using Down Mode.
Enable Create New Column (optional).
Set Precision.
Click Submit.
Round Value Using Half-up Mode
Rounds numeric values to the nearest integer or specified decimal place using half-up rounding.
Best Situations to Use
Apply conventional rounding to numeric datasets for reporting or feature engineering.
Steps
Select a numeric column.
Open Transforms > Numbers > Round Value Using Half-up Mode.
Enable Create New Column (optional).
Set Precision.
Click Submit.
Last updated