从Pandas Dataframe中的值创建XML值

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

# 创建一个示例的Pandas Dataframe
data = {'Name': ['Alice', 'Bob', 'Charlie'],
        'Age': [25, 30, 35],
        'City': ['New York', 'London', 'Tokyo']}
df = pd.DataFrame(data)

# 转换Dataframe为字典形式
df_dict = df.to_dict(orient='records')

# 创建XML根元素
root = ET.Element('Data')

# 遍历字典，创建XML元素并添加到根元素中
for row in df_dict:
    record = ET.SubElement(root, 'Record')
    for key, value in row.items():
        element = ET.SubElement(record, key)
        element.text = str(value)

# 将XML元素转换为字符串形式的XML值
xml_value = ET.tostring(root).decode()
print(xml_value)