sqrt function

The sqrt function returns the square root of each value of the column.


Parameters

sqrt(column)

Parameter

Description

column

The attribute used to evaluate the square root. Its type must be numeral.


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 fill a new column with the square root of the tempo attribute.

Add a new column, then write the following formula: sqrt($"tempo")