pyspark.sql.functions.equal_null#

pyspark.sql.functions.equal_null(col1, col2)[source]#

Returns same result as the EQUAL(=) operator for non-null operands, but returns true if both are null, false if one of them is null.

New in version 3.5.0.

Parameters

col1Column or column name
col2Column or column name

Examples

>>> from pyspark.sql import functions as sf
>>> df = spark.createDataFrame([(None, None,), (1, 9,)], ["a", "b"])
>>> df.select('*', sf.equal_null(df.a, df.b)).show()
+----+----+----------------+
|   a|   b|equal_null(a, b)|
+----+----+----------------+
|NULL|NULL|            true|
|   1|   9|           false|
+----+----+----------------+

>>> df.select('*', sf.equal_null('a', 'b')).show()
+----+----+----------------+
|   a|   b|equal_null(a, b)|
+----+----+----------------+
|NULL|NULL|            true|
|   1|   9|           false|
+----+----+----------------+