snowflake.snowpark.functions.percent_rank¶

snowflake.snowpark.functions.percent_rank() → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.6.1/src/snowflake/snowpark/functions.py#L5956-L5985)¶

Returns the relative rank of a value within a group of values, specified as a percentage ranging from 0.0 to 1.0.

Example::

CopyExpand

>>> from snowflake.snowpark.window import Window
>>> df = session.create_dataframe(
...     [
...         [1, 2, 1],
...         [1, 2, 3],
...         [2, 1, 10],
...         [2, 2, 1],
...         [2, 2, 3],
...     ],
...     schema=["x", "y", "z"]
... )
>>> df.select(percent_rank().over(Window.partition_by("x").order_by(col("y"))).alias("result")).show()
------------
|"RESULT"  |
------------
|0.0       |
|0.5       |
|0.5       |
|0.0       |
|0.0       |
------------

Show lessSee more

Scroll to top