snowflake.snowpark.functions.equal_nan¶

snowflake.snowpark.functions.equal_nan(e: ColumnOrName) → Column[source]¶

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

Example:

CopyExpand

>>> 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)]

Show lessSee more

Scroll to top