Merk
Tilgang til denne siden krever autorisasjon. Du kan prøve å logge på eller endre kataloger.
Tilgang til denne siden krever autorisasjon. Du kan prøve å endre kataloger.
Evaluates a list of conditions and returns one of multiple possible result expressions. If otherwise() is not invoked, None is returned for unmatched conditions. Supports Spark Connect.
Syntax
from pyspark.databricks.sql import functions as dbf
dbf.when(condition=<condition>, value=<value>)
Parameters
| Parameter | Type | Description |
|---|---|---|
condition |
pyspark.sql.Column |
A boolean Column expression. |
value |
Any | A literal value, or a Column expression. |
Returns
pyspark.sql.Column: column representing when expression.
Examples
from pyspark.databricks.sql import functions as dbf
df = spark.range(3)
df.select("*", dbf.when(df['id'] == 2, 3).otherwise(4)).show()
+---+------------------------------------+
| id|CASE WHEN (id = 2) THEN 3 ELSE 4 END|
+---+------------------------------------+
| 0| 4|
| 1| 4|
| 2| 3|
+---+------------------------------------+