snowflake.snowpark.functions.normal¶

snowflake.snowpark.functions.normal(mean: Union[int, float], stddev: Union[int, float], gen: Union[Column, str, int, float])[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.29.0/snowpark-python/src/snowflake/snowpark/functions.py#L11482-L11512)¶

Generates a normally-distributed pseudo-random floating point number with specified mean and stddev (standard deviation).

Example::

CopyExpand

>>> df = session.create_dataframe([1,2,3], schema=["a"])
>>> df.select(normal(0, 1, "a").alias("normal")).collect()
[Row(NORMAL=-1.143416214223267), Row(NORMAL=-0.78469958830255), Row(NORMAL=-0.365971322006404)]

Show lessSee more

Scroll to top