asc
Returns a sort expression for the target column in ascending order. This function is used in sort and orderBy functions. Supports Spark Connect.
Syntax
Python
from pyspark.sql import functions as dbf
dbf.asc(col=<col>)
Parameters
Parameter | Type | Description |
|---|---|---|
|
| Target column to sort by in the ascending order. |
Returns
pyspark.sql.Column: The column specifying the sort order.
Examples
Example 1: Sort DataFrame by 'id' column in ascending order.
Python
from pyspark.sql import functions as dbf
df = spark.createDataFrame([(4, 'B'), (3, 'A'), (2, 'C')], ['id', 'value'])
df.sort(dbf.asc("id")).show()
Output
+---+-----+
| id|value|
+---+-----+
| 2| C|
| 3| A|
| 4| B|
+---+-----+
Example 2: Use asc in orderBy function to sort the DataFrame.
Python
from pyspark.sql import functions as dbf
df = spark.createDataFrame([(4, 'B'), (3, 'A'), (2, 'C')], ['id', 'value'])
df.orderBy(dbf.asc("value")).show()
Output
+---+-----+
| id|value|
+---+-----+
| 3| A|
| 4| B|
| 2| C|
+---+-----+