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. - 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| +----+----+----------------+