Python3从列表(每行都有dict)到csv

你可以用熊猫很好地解决这个问题:

import pandas as pd
df = pd.DataFrame(dict_list)
df.to_csv('output.csv', index=False)

dict_list = [{'field1': 100, 'field2': '10:00', 'field3': 'cherries'}, 
{'field1': 500, 'field2': '6:00', 'field3': "cheese"}, 
{'field1':250, 'field2': '9:00', 'field3': 'beans'}]

   field1 field2    field3
      100  10:00  cherries
      500   6:00    cheese
      250   9:00     beans

with open('myfile', 'wb') as f:
    # assign your headers
    w = csv.DictWriter(f, fieldnames=data[0].keys())
    # write headers
    w.writeheader()
    # write data
    w.writerows(data)

你可以用 DictWriter.writerows 迭代 list

docs 怎样 DictWriter

这是我们的规格 writerows

csvwriter.writerows(行)

在行中写入所有元素(如前所述的行对象的iterable)

这几乎是另一个问题的重复,但是注释系统不适合这么大的代码片段。只需使用for循环在dict列表上迭代,其中另一个问题的答案只保留一行:

with open('myfile', mode='wt', encoding='utf-8') as myfile:
    writer = csv.DictWriter(myfile, data[0].keys())
    writer.writeheader()
    for line in data:
        writer.writerow(line)

writerows 方法并传递整个列表:

with open('myfile', mode='wt', encoding='utf-8') as myfile:
    writer = csv.DictWriter(myfile, data[0].keys())
    writer.writeheader()
    writer.writerows(data)