> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/7.6/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/7.6/data-center/data-preparation-beta-release/data-preparation-workspace/transforms/numbers.md). # Numbers ![](https://4128708524-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FD18OAzm864lo8XOm22SV%2Fimage.png?alt=media\&token=c736536f-74f6-4da6-8ea1-328da3eac94f) ## **Remove Fractional Part** It removes the fractional part from the numerical column. The float column is converted into the integer data type. The ***Remove Fractional Part*** transform is applied on the ***expense*** column.
As a result, a new column gets added to the dataset after removing the fractional part from the selected column:
## **Round Value using Ceil Mode** It replaces the number with a greater integer value if the number is between two integers values. The transformed value can replace the existing column value or can be added as a new column. The ***Round value using ceil mode*** transform is applied to the ***ctc*** column,
A new column gets added with the set round off value using ceil mode:
## **Round Value using Down Mode** It rounds the number down to a specified digit or gives the specified number of decimals without any change in value. The transformed value can replace the existing column value or can be added as a new column. The ***Round Value using Down Mode*** transform has been applied to ***ctc*** column,
A new column gets added to the dataset with the round off values using the down mode on the ***ctc*** column data:
## **Round Value using Floor Mode** It replaces a number with the lesser integer value, if the number is between two integer value, or it rounds the number down to the nearest multiple of Specified significance. It does not consider whether the next digit is 5 or less than or greater than 5. The transformed value can replace the existing column value or can be added as a new column. The ***Round Value using Floor Mode*** transform has been applied to the ***ctc*** column,
As a result, a new column gets added to the dataset with the round off values of the ***ctc*** column data by using the floor mode:
## **Round Value using Half-up mode** It replaces a number with the next integer value if its next digit is 5 or greater than 5. The transformed value can replace the existing column value or can be added as a new column. The ***Round Value using Half-up mode*** transform is applied to the ***ctc*** column as displayed below:
As a result, a new column gets added to the dataset with the round off values of the ***ctc*** column data by using the half-up mode:
## **Max** It gives the maximum value from the selected columns row-wise. The selected column should be numerical and more than one. The ***Max*** transform is applied to the ***revenue*** column as displayed below:
As a result, a new column gets added to the dataset with the ***maximum*** values of the ***revenue*** column data:
## **Negate** It complements the sing of a numeric value. If the value is positive, then a negative value comes and vice-versa. The ***Negate*** transform is applied to the ***revenue*** column as displayed below:
As a result, a new column gets added to the dataset with the ***negative*** values of the ***revenue*** column data:
## **Min** It gives the minimum value from the selected columns row-wise. The selected column should be numerical and more than one. The ***Min*** transform is applied to the ***revenue*** column as displayed below:
As a result, a new column gets added to the dataset with the ***minimum*** values of the ***revenue*** column data:
## **Mean** It gives the average value of the selected columns row-wise. The selected column should be numerical and more than one. The ***Mean*** transform is applied to the ***revenue*** column as displayed below:
As a result, a new column gets added to the dataset with the ***mean*** values of the ***revenue*** column data:
## **Number Names** It converts the value of the selected column into words. The column must be of integer type. **Use with:** It gives the users an option to convert words into either western format or Indian format. The ***Number Names*** transform is applied to the ***revenue*** column as displayed below (used with the ***Western*** option:
As a result, a new column gets added to the dataset with the ***Number Names*** of the ***revenue*** column data: