如何在Python中迭代xml并将其保存到dataframe中？

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

def parse_xml_to_dataframe(xml_file):
    # 解析XML文件
    tree = ET.parse(xml_file)
    root = tree.getroot()

    data = []
    # 迭代XML的每个子元素
    for child in root:
        # 提取所需的数据
        row = {}
        row['tag'] = child.tag
        row['text'] = child.text
        row['attributes'] = child.attrib
        data.append(row)

    # 将数据转换为DataFrame
    df = pd.DataFrame(data)
    return df

# 读取XML文件并解析为DataFrame
xml_file = 'path/to/your/xml/file.xml'
df = parse_xml_to_dataframe(xml_file)

# 打印DataFrame
print(df)

pip install pandas