>>> 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"), col("z"))).alias("result")).sort("result").show()
------------
|"RESULT" |
------------
|0.0 |
|0.0 |
|0.5 |
|1.0 |
|1.0 |
------------