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

snowflake.snowpark.functions.equal_nan¶

snowflake.snowpark.functions.equal_nan(e: ColumnOrName) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.3.0/src/snowflake/snowpark/functions.py#L940-L952)¶

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