You are viewing documentation about an older version (1.9.0). View latest version

snowflake.snowpark.functions.equal_nan¶

snowflake.snowpark.functions.equal_nan(e: Union[Column, str]) → Column[source]¶

Return true if the value in the column is not a number (NaN).

Example:

>>> import math
>>> df = session.create_dataframe([1.1, math.nan, 2.3], schema=["a"])
>>> df.select(equal_nan(df["a"]).alias("equal_nan")).collect()
[Row(EQUAL_NAN=False), Row(EQUAL_NAN=True), Row(EQUAL_NAN=False)]

Copy