xpath_string

Returns the text contents of the first xml node that matches the XPath expression.

Syntax

from pyspark.sql import functions as sf

sf.xpath_string(xml, path)

Parameters

Parameter	Type	Description
xml	pyspark.sql.Column or str	XML column or column name.
path	pyspark.sql.Column or str	XPath expression.

Examples

from pyspark.sql import functions as sf
df = spark.createDataFrame([('<a><b>b</b><c>cc</c></a>',)], ['x'])
df.select(sf.xpath_string(df.x, sf.lit('a/c'))).show()

+--------------------+
|xpath_string(x, a/c)|
+--------------------+
|                  cc|
+--------------------+