在使用pandas的库转换为csv文件之前,通过python指定多个xml文件的列值

我有两个XML文件(*e1report.XML和*e3report.XML)来自模拟运行,必须使用pandas库将其转换为CSV文件。因此,我需要生成列作为表的标题。我不知道如何介绍这两个不同的专栏。这是我的脚本,其中只有一列,而代码必须能够自动获取两列的值。

import glob     
mainpath = r"D:/alimirzaei/app/my_sumo/testforpythontraci/test8/" 
s = glob.glob('{0}/*report.xml'.format(mainpath))
   
import csv
import xml.etree.ElementTree as ET
import pandas as pd

for k in range(len(s)):
    tree = ET.parse(s[k])
    root = tree.getroot()
          
    with open('filename{}.csv'.format(k+1), 'w') as job:
         cols = ['begin', 'end', 'id', 'meanTravelTime','meanOverlapTravelTime', 'meanSpeed', 'meanHaltsPerVehicle', 'meanTimeLoss', 'vehicleSum', 'meanSpeedWithin','meanHaltsPerVehicleWithin', 'meanDurationWithin', 'vehicleSumWithin', 'meanIntervalSpeedWithin', 'meanIntervalHaltsPerVehicleWithin', 'meanIntervalDurationWithin', 'meanTimeLossWithin']
         detectorwriter = csv.writer(job)
         detectorwriter.writerow(cols)
         for i in root:
             values = [i.attrib[j] for j in cols]
             detectorwriter.writerow(values)
    data = pd.read_csv('filename{}.csv'.format(k+1))
    data.to_csv('filename_final{}.csv'.format(k+1), sep = ',', index = False)

最好的