snowflake.snowpark.functions.try_to_double¶

snowflake.snowpark.functions.try_to_double(e: Union[Column, str], fmt: Optional[Union[Column, str]] = None) → Column[source]¶

A special version of TO_DOUBLE that returns NULL instead of raising an error if the conversion cannot be performed. Snowflake’s TRY_TO_DOUBLE only accepts string input.

Example:

>>> df = session.create_dataframe(['12', '11.3', 'abc'], schema=['a'])
>>> df.select(try_to_double(col('a')).as_('ans')).collect()
[Row(ANS=12.0), Row(ANS=11.3), Row(ANS=None)]
>>> df = session.create_dataframe(['12+', '11.3+', 'abc'], schema=['a'])
>>> df.select(try_to_double(col('a'), '999.99MI').as_('ans')).collect()
[Row(ANS=12.0), Row(ANS=11.3), Row(ANS=None)]