pyspark.sql.functions.nullifzero

pyspark.sql.functions.nullifzero(col)

Returns null if col is equal to zero, or col otherwise.

New in version 4.0.0.

Parameters

colColumn or column name

Examples

>>> import pyspark.sql.functions as sf
>>> df = spark.createDataFrame([(0,), (1,)], ["a"])
>>> df.select('*', sf.nullifzero(df.a)).show()
+---+-------------+
|  a|nullifzero(a)|
+---+-------------+
|  0|         NULL|
|  1|            1|
+---+-------------+

>>> df.select('*', sf.nullifzero('a')).show()
+---+-------------+
|  a|nullifzero(a)|
+---+-------------+
|  0|         NULL|
|  1|            1|
+---+-------------+