round function

The round function returns each value of the column, of continuous type, rounded up or down, depending on their last digits after the decimal separator:

  • If the last digit after the decimal separator considered is less than 5, then the value is rounded down;

  • If the last digit after the decimal separator considered is more than or equal to 5, then the value is rounded up.


Parameters

round(column)

Parameter

Description

column

The attribute used to evaluate the nearest integer value. Its type must be numeral. The column parameter is mandatory.


Example

The following example uses the Top Hits Spotify dataset.

This example isn’t based on a real scenario, it only explains how to use the function.

Description

Screenshot

In this example, we want to add a column which contains the round of the writing score attribute’s values.

Add a new column and type the following formula: round($"tempo")