从多个字典写入单个CSV文件

如果所有字典的大小相同，则可以使用zip它们并行地对其进行迭代。如果它们的大小不相等，并且您希望迭代填充到最长的字典，则可以使用itertools.zip_longest

例如：

import csv
from itertools import zip_longest

e = {'Jay':10,'Ray':40}
c = {'Google':5000}

def writeData():
    with open('employee_file20.csv', mode='w') as csv_file:
        fieldnames = ['emp_name','age','company_name','size']
        writer = csv.writer(csv_file)
        writer.writerow(fieldnames)

        for employee, company in zip_longest(e.items(), c.items()):
            row = list(employee)
            row += list(company) if company is not None else ['', '']  # Write empty fields if no company

            writer.writerow(row)

writeData()

如果字典大小相等，则更简单：

import csv

e = {'Jay':10,'Ray':40}
c = {'Google':5000, 'Yahoo': 3000}

def writeData():
    with open('employee_file20.csv', mode='w') as csv_file:
        fieldnames = ['emp_name', 'age', 'company_name', 'size']
        writer = csv.writer(csv_file)
        writer.writerow(fieldnames)

        for employee, company in zip(e.items(), c.items()):
            writer.writerow(employee + company)

writeData()

一点注意事项：如果使用Python3，将对字典进行排序。Python2中不是这种情况。因此，如果您使用Python2，则应使用collections.OrderedDict而不是标准字典。