Python :将xml展平为csv，其父标签在子标签中重复

import csv
import xml.etree.ElementTree as ET

def flatten_xml(xml_string):
    root = ET.fromstring(xml_string)
    rows = []
    headers = set()

    for element in root.iter():
        headers.add(element.tag)

    headers = sorted(list(headers))

    for element in root.iter():
        row = {}
        for header in headers:
            row[header] = ""
        row[element.tag] = element.text
        rows.append(row)

    return rows

def write_csv(data, filename):
    with open(filename, 'w', newline='') as csvfile:
        writer = csv.DictWriter(csvfile, fieldnames=data[0].keys())
        writer.writeheader()
        writer.writerows(data)

# 示例用法
xml_string = """
<root>
    <item>
        <name>Apple</name>
        <price>1.99</price>
    </item>
    <item>
        <name>Orange</name>
        <price>0.99</price>
    </item>
</root>
"""

flattened_data = flatten_xml(xml_string)
write_csv(flattened_data, 'output.csv')