pyspark.sql.Column.otherwise¶

Column.otherwise(value: Any) → pyspark.sql.column.Column[source]¶

Evaluates a list of conditions and returns one of multiple possible result expressions. If Column.otherwise() is not invoked, None is returned for unmatched conditions.

New in version 1.4.0.

Parameters

value: a literal value, or a Column expression.

See also

pyspark.sql.functions.when

Examples

>>> from pyspark.sql import functions as F
>>> df.select(df.name, F.when(df.age > 3, 1).otherwise(0)).show()
+-----+-------------------------------------+
| name|CASE WHEN (age > 3) THEN 1 ELSE 0 END|
+-----+-------------------------------------+
|Alice|                                    0|
|  Bob|                                    1|
+-----+-------------------------------------+

pyspark.sql.Column.name pyspark.sql.Column.over