遍历XML中的特定子节点并使用Python保存到CSV

import xml.etree.ElementTree as ET
import csv

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

csv_columns = ['节点1', '节点2', '节点3']  # 替换为你的特定子节点名称
csv_file = "output.csv"  # 替换为你想要保存的CSV文件名

with open(csv_file, 'w') as csvfile:
    writer = csv.DictWriter(csvfile, fieldnames=csv_columns)
    writer.writeheader()

for node in root.iter('特定子节点'):  # 替换为你的特定子节点名称
    data = {}
    for column in csv_columns:
        data[column] = node.find(column).text if node.find(column) is not None else ''
    with open(csv_file, 'a') as csvfile:
        writer = csv.DictWriter(csvfile, fieldnames=csv_columns)
        writer.writerow(data)

import xml.etree.ElementTree as ET
import csv

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

csv_columns = ['节点1', '节点2', '节点3']  # 替换为你的特定子节点名称
csv_file = "output.csv"  # 替换为你想要保存的CSV文件名

with open(csv_file, 'w') as csvfile:
    writer = csv.DictWriter(csvfile, fieldnames=csv_columns)
    writer.writeheader()

for node in root.iter('特定子节点'):  # 替换为你的特定子节点名称
    data = {}
    for column in csv_columns:
        data[column] = node.find(column).text if node.find(column) is not None else ''
    with open(csv_file, 'a') as csvfile:
        writer = csv.DictWriter(csvfile, fieldnames=csv_columns)
        writer.writerow(data)