Python比较平均2列的2个CSV

Question

我想得到2个csv文件中一列的平均值

import csv

master = open('master.csv', 'r')
export = open('export.csv', 'r')

#output
outFile = open ('out.csv', 'w')
csvWriter = csv.writer(outFile, delimiter=',')

# Process input files
csv1 = csv.reader(master, delimiter=',')
csv2 = csv.reader(export, delimiter=',')

# Skip headers
next(csv1)
next(csv2)

for rowExport in csv2:
    # Get each line in MasterList
    rowMaster = next(csv1)

    #output line from Export values
    colA = str(rowMaster[1])
    colB = str(rowExport[5])

    #Average colB is the average of 2 same column in master and export (in master it is in column 2 while column 5 in export)
    if float(rowExport[5])*2 > float(rowMaster[2]):
        colB = str((float(rowExport[5])+float(rowMaster[2])/2))    
    csvWriter.writerow([colA, colB])                                                                                     

master.close()
export.close()
outFile.close()

我只想根据主CSV中的客户端ID获取Docs Queued列的平均值。请参阅附件中的图片

ExportMaster

我得到的是，它将基于行的平均值，它与客户端ID不匹配。因为它是随机排序的 Result