pyspark.sql.functions.asc_nulls_last

pyspark.sql.functions.asc_nulls_last(col: ColumnOrName) → pyspark.sql.column.Column

Returns a sort expression based on the ascending order of the given column name, and null values appear after non-null values.

New in version 2.4.0.

Changed in version 3.4.0: Supports Spark Connect.

Parameters

colColumn or str

target column to sort by in the ascending order.

Returns

Column

the column specifying the order.

Examples

>>> df1 = spark.createDataFrame([(0, None),
...                              (1, "Bob"),
...                              (2, "Alice")], ["age", "name"])
>>> df1.sort(asc_nulls_last(df1.name)).show()
+---+-----+
|age| name|
+---+-----+
|  2|Alice|
|  1|  Bob|
|  0| null|
+---+-----+

pyspark.sql.functions.asc_nulls_first pyspark.sql.functions.desc