如何将xmlToDataframe折叠到一行中

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

def xmlToDataframe(xml_data):
    # 解析XML数据
    root = ET.fromstring(xml_data)

    # 定义列名
    columns = ['Column1', 'Column2', 'Column3']

    # 创建空的DataFrame
    df = pd.DataFrame(columns=columns)

    # 迭代XML元素
    for element in root:
        # 提取所需数据
        data1 = element.find('Element1').text
        data2 = element.find('Element2').text
        data3 = element.find('Element3').text

        # 构建数据行
        row = [data1, data2, data3]

        # 合并子元素
        for sub_element in element.findall('SubElement'):
            sub_data = sub_element.text
            row.append(sub_data)

        # 添加数据行到DataFrame
        df.loc[len(df)] = row

    return df

# 测试数据
xml_data = '''
<Root>
    <Element>
        <Element1>Data1</Element1>
        <Element2>Data2</Element2>
        <Element3>Data3</Element3>
        <SubElement>SubData1</SubElement>
        <SubElement>SubData2</SubElement>
    </Element>
    <Element>
        <Element1>Data4</Element1>
        <Element2>Data5</Element2>
        <Element3>Data6</Element3>
        <SubElement>SubData3</SubElement>
        <SubElement>SubData4</SubElement>
    </Element>
</Root>
'''

# 调用xmlToDataframe函数
df = xmlToDataframe(xml_data)
print(df)