snowflake.snowpark.functions.asc_nulls_first¶

snowflake.snowpark.functions.asc_nulls_first(c: Union[Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.47.0/src/snowflake/snowpark/functions.py#L7978-L7995)¶

Returns a Column expression with values sorted in ascending order (null values sorted before non-null values).

Example:

CopyExpand

>>> df = session.create_dataframe([None, 3, 2, 1, None], schema=["a"])
>>> df.sort(asc_nulls_first(df["a"])).collect()
[Row(A=None), Row(A=None), Row(A=1), Row(A=2), Row(A=3)]

Show lessSee more

Scroll to top