如何使用pyspark从xml的每个嵌套节点创建表

from pyspark.sql import SparkSession
from pyspark.sql.functions import explode

spark = SparkSession.builder.appName("XML to DataFrame").getOrCreate()

df = spark.read.format("xml").option("rowTag", "root").load("path/to/xml/file.xml")

df_flat = df.select(explode(df.root).alias("nested_node"))

df_table = df_flat.selectExpr("nested_node._attribute1 as attribute1", "nested_node._attribute2 as attribute2", "nested_node._value as value")
df_table.createOrReplaceTempView("xml_table")