解析XML并转换为CSV python

import xml.etree.ElementTree as ET
import csv

# 解析XML文件
tree = ET.parse('data.xml')
root = tree.getroot()

# 创建CSV文件
csv_file = open('data.csv', 'w')
csv_writer = csv.writer(csv_file)

# 写入CSV表头
header = ['Name', 'Age', 'Email']
csv_writer.writerow(header)

# 遍历XML数据并写入CSV文件
for person in root.findall('person'):
    name = person.find('name').text
    age = person.find('age').text
    email = person.find('email').text
    csv_writer.writerow([name, age, email])

# 关闭CSV文件
csv_file.close()

import xmltodict
import csv

# 读取XML文件
with open('data.xml') as xml_file:
    xml_data = xml_file.read()

# 解析XML数据为字典
data_dict = xmltodict.parse(xml_data)

# 创建CSV文件
csv_file = open('data.csv', 'w')
csv_writer = csv.writer(csv_file)

# 写入CSV表头
header = ['Name', 'Age', 'Email']
csv_writer.writerow(header)

# 遍历字典数据并写入CSV文件
for person in data_dict['root']['person']:
    name = person['name']
    age = person['age']
    email = person['email']
    csv_writer.writerow([name, age, email])

# 关闭CSV文件
csv_file.close()