Perform ascending sorting of data while placing null values at the end in PySpark

PySpark @

In the realm of big data processing with PySpark, handling null values efficiently during sorting operations is crucial. The asc_nulls_last function in PySpark is a tool designed to address this challenge. This article dives deep into the nuances of asc_nulls_last, exploring its advantages and demonstrating its use through a practical example.

Understanding asc_nulls_last

The asc_nulls_last function in PySpark is used within the orderBy or sort methods. It allows for ascending sorting of data while placing null values at the end. This is particularly useful in scenarios where null values are present and need to be treated distinctly from non-null values.



Advantages of using asc_nulls_last

Enhanced data integrity: By keeping null values at the end, it ensures that meaningful data is prioritized in sorting.

Flexibility in data analysis: Offers more control over how null values are handled in sorted datasets.

Improved readability: Makes it easier to analyze datasets by pushing null values out of the immediate focus.

Use case: Customer data management


Consider a dataset of customer information where we need to sort customers based on their last purchase date. However, some customers may not have made any purchases yet, leading to null values in the purchase date column.


To sort the customer data in ascending order of their last purchase date while ensuring that customers with no purchases (null values) are listed at the end.

Sample Data Creation

First, let’s create a sample dataset with customer names and their last purchase dates.

from pyspark.sql import SparkSession
from pyspark.sql.functions import col
from pyspark.sql.types import StringType, DateType
# Initialize Spark Session
spark = SparkSession.builder.appName("asc_nulls_last_example").getOrCreate()
# Sample data
data = [("Sachin", "2023-01-10"),
        ("Ram", "2023-02-15"),
        ("Raju", None),
        ("David", "2023-03-20"),
        ("Wilson", None)]
# Define schema
schema = ["Name", "LastPurchaseDate"]
# Create DataFrame
df = spark.createDataFrame(data, schema)
# Convert string to date
df = df.withColumn("LastPurchaseDate", col("LastPurchaseDate").cast(DateType()))

Applying asc_nulls_last

Now, we’ll use asc_nulls_last to sort the data.

from pyspark.sql.functions import asc_nulls_last
# Sorting using asc_nulls_last
sorted_df = df.orderBy(asc_nulls_last("LastPurchaseDate"))
# Show the sorted data


The output will display customers sorted by their last purchase date in ascending order, with customers having no purchase date (null values) at the end.

|  Name|LastPurchaseDate|
|Sachin|      2023-01-10|
|   Ram|      2023-02-15|
| David|      2023-03-20|
|  Raju|            NULL|
|Wilson|            NULL|

Spark important urls to refer

  1. Spark Examples
  2. PySpark Blogs
  3. Bigdata Blogs
  4. Spark Interview Questions
  5. Official Page

Author: user