用Pandas读取深度嵌套的xml

import xml.etree.ElementTree as ET
import pandas as pd

# 读取XML文件
tree = ET.parse('path/to/xml/file.xml')
root = tree.getroot()

# 定义一个递归函数，将XML转换为字典
def parse_xml_element(element):
    result = {}
    if element.text:
        result[element.tag] = element.text
    for child in element:
        child_data = parse_xml_element(child)
        if child.tag in result:
            if type(result[child.tag]) is list:
                result[child.tag].append(child_data)
            else:
                result[child.tag] = [result[child.tag], child_data]
        else:
            result[child.tag] = child_data
    return result

# 将XML转换为字典，并构建DataFrame
data = [parse_xml_element(child) for child in root]
df = pd.DataFrame(data)

# 打印结果
print(df)