将多个字典写入csv文件？[重复]

使用csv模块并列出理解：

import csvdict1 = {0: 33.422, 1: 39.2308, 2: 30.132}dict2 = {0: 42.2422, 1: 43.342, 2: 42.424}dict3 = {0: 13.422, 1: 9.2308, 2: 20.132}dict4 = {0: 32.2422, 1: 23.342, 2: 32.424}dicts = dict1, dict2, dict3, dict4with open('my_data.csv', 'wb') as ofile:    writer = csv.writer(ofile, delimiter='t')    writer.writerow(['ID', 'dict1', 'dict2', 'dict3', 'dict4'])    for key in dict1.iterkeys():        writer.writerow([key] + [d[key] for d in dicts])

请注意，默认情况下字典是无序的，因此，如果您希望键以升序排列，则必须对键进行排序：

for key in sorted(dict1.iterkeys(), key=lambda x: int(x)):    writer.writerow([key] + [d[key] for d in dicts])

如果需要处理无法确定所有字典具有相同键的情况，则需要更改一些小内容：

with open('my_data.csv', 'wb') as ofile:    writer = csv.writer(ofile, delimiter='t')    writer.writerow(['ID', 'dict1', 'dict2', 'dict3', 'dict4'])    keys = set(d.keys() for d in dicts)    for key in keys:        writer.writerow([key] + [d.get(key, None) for d in dicts])