pyspark.sql.functions.xpath_float

pyspark.sql.functions.xpath_float(xml, path)

Returns a float value, the value zero if no match is found, or NaN if a match is found but the value is non-numeric.

New in version 3.5.0.

See also

pyspark.sql.functions.from_xml()

pyspark.sql.functions.schema_of_xml()

pyspark.sql.functions.to_xml()

pyspark.sql.functions.xpath()

pyspark.sql.functions.xpath_boolean()

pyspark.sql.functions.xpath_double()

pyspark.sql.functions.xpath_int()

pyspark.sql.functions.xpath_long()

pyspark.sql.functions.xpath_number()

pyspark.sql.functions.xpath_short()

pyspark.sql.functions.xpath_string()

Examples

>>> from pyspark.sql import functions as sf
>>> df = spark.createDataFrame([('<a><b>1</b><b>2</b></a>',)], ['x'])
>>> df.select(sf.xpath_float(df.x, sf.lit('sum(a/b)'))).show()
+------------------------+
|xpath_float(x, sum(a/b))|
+------------------------+
|                     3.0|
+------------------------+