snowflake.snowpark.functions.round¶

snowflake.snowpark.functions.round(e: Union[Column, str], scale: Union[Column, str, int, float] = 0) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.16.0/src/snowflake/snowpark/functions.py#L2477-L2499)¶

Returns rounded values from the specified column.

Example:

CopyExpand

>>> df = session.create_dataframe([[1.11], [2.22], [3.33]], schema=["a"])
>>> df.select(round(col("a")).alias("result")).show()
------------
|"RESULT"  |
------------
|1.0       |
|2.0       |
|3.0       |
------------

Show lessSee more

Scroll to top