snowflake.snowpark.functions.regr_count¶

snowflake.snowpark.functions.regr_count(y: Union[Column, str], x: Union[Column, str]) → Column[source]¶

Returns the number of non-null number pairs in a group.

Example:

>>> df = session.create_dataframe([[1, 10, 11], [1, 20, 22], [1, 25, None], [2, 30, 35]], schema=["k", "v", "v2"])
>>> df.group_by("k").agg(regr_count(col("v"), col("v2")).alias("regr_count")).collect()
[Row(K=1, REGR_COUNT=2), Row(K=2, REGR_COUNT=1)]

Copy