Fallback Default Values with otherwise()

How do we provide a default fallback value when a conditional when() branch evaluates to False?

Intermediate⏱ 2 Minutes⭐ 290 XP

🤔 THE QUESTION

How do we provide a default fallback value when a conditional when() branch evaluates to False?

💡 WHAT IS IT?

otherwise(defaultValue) completes a when() conditional expression by defining the fallback result.

🎯 WHAT IS IT USED FOR?

Preventing null values in categorical classifications and guaranteeing exhaustive business rules.

💻 EXAMPLE

from pyspark.sql.functions import col, when

df = df.withColumn(
    "tier",
    when(col("score") >= 90, "Platinum")
    .otherwise("Standard")
)

Practice typing production-grade PySpark code for Fallback Default Values with otherwise().