pyspark.sql.functions.xpath_int

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

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

New in version 3.5.0.

Examples

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