要将表格数据保存到XML文件,可以使用以下方法:
xml.etree.ElementTree
来创建XML文件并保存数据。import xml.etree.ElementTree as ET
import csv
def save_to_xml(file_name, data):
root = ET.Element("data")
for row in data:
entry = ET.SubElement(root, "entry")
for key, value in row.items():
field = ET.SubElement(entry, key)
field.text = str(value)
tree = ET.ElementTree(root)
tree.write(file_name)
# 示例数据
data = [
{"name": "John", "age": 25, "city": "New York"},
{"name": "Emily", "age": 30, "city": "Los Angeles"},
{"name": "David", "age": 35, "city": "Chicago"}
]
# 保存数据到XML文件
save_to_xml("data.xml", data)
pandas
来读取表格数据并将其保存为XML文件。import pandas as pd
def save_to_xml(file_name, data):
df = pd.DataFrame(data)
df.to_xml(file_name, root_name="data", row_name="entry")
# 示例数据
data = [
{"name": "John", "age": 25, "city": "New York"},
{"name": "Emily", "age": 30, "city": "Los Angeles"},
{"name": "David", "age": 35, "city": "Chicago"}
]
# 保存数据到XML文件
save_to_xml("data.xml", data)
这些方法都可以将表格数据保存为XML文件,选择适合你的项目需求的方法即可。