snowflake.snowpark.functions.var_pop¶

snowflake.snowpark.functions.var_pop(e: Union[Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.6.1/src/snowflake/snowpark/functions.py#L995-L1019)¶

Returns the population variance of non-NULL records in a group. If all records inside a group are NULL, a NULL is returned. The population variance of a single row is 0.0.

Example:

CopyExpand

>>> df = session.create_dataframe([1, -1, 1, -1, -1], schema=["a"])
>>> df.select(var_pop(col("a"))).collect()
[Row(VAR_POP("A")=Decimal('0.960000'))]

>>> df = session.create_dataframe([1, None, 2, 3, None, 5, 6], schema=["a"])
>>> df.select(var_pop(col("a"))).collect()
[Row(VAR_POP("A")=Decimal('3.440000'))]

>>> df = session.create_dataframe([None, None, None], schema=["a"])
>>> df.select(var_pop(col("a"))).collect()
[Row(VAR_POP("A")=None)]

>>> df = session.create_dataframe([42], schema=["a"])
>>> df.select(var_pop(col("a"))).collect()
[Row(VAR_POP("A")=Decimal('0.000000'))]

Show lessSee more

Scroll to top