从pandas数据框创建单个XML文件

import pandas as pd
from xml.etree.ElementTree import Element, SubElement, ElementTree

data = {'Name': ['John', 'Mike', 'Sarah'],
        'Age': [25, 30, 28],
        'City': ['New York', 'London', 'Paris']}
df = pd.DataFrame(data)

root = Element('Data')

for index, row in df.iterrows():
    item = SubElement(root, 'Item')
    name = SubElement(item, 'Name')
    name.text = row['Name']
    age = SubElement(item, 'Age')
    age.text = str(row['Age'])
    city = SubElement(item, 'City')
    city.text = row['City']

tree = ElementTree(root)
tree.write('data.xml')