将多个xml属性提取到pandas数据帧

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

tree = ET.parse('file.xml')  # 替换为实际的XML文件路径
root = tree.getroot()

data = []
for element in root.iter('item'):  # 替换为实际的XML元素名称
    attribute1 = element.get('attribute1')  # 替换为实际的属性名称
    attribute2 = element.get('attribute2')  # 替换为实际的属性名称
    attribute3 = element.get('attribute3')  # 替换为实际的属性名称
    
    data.append([attribute1, attribute2, attribute3])

df = pd.DataFrame(data, columns=['attribute1', 'attribute2', 'attribute3'])