在Python 3.x中将多个字典写入多个csv文件

I have been struggling with this for a while now, maybe someone can help. I have a list of dictionaries. Each of these dictionaries should be written to a separate .csv file. How do I do this?

我一直在努力解决这个问题,也许有人可以提供帮助。我有一个词典列表。应将每个字典写入单独的.csv文件中。我该怎么做呢?

What I have so far, which does not work:

到目前为止,我没有做到这一点:

from openpyxl import *
from openpyxl.styles import *
import csv

a = 1
b = 2
c = 3
d = 4
e = 5
f = 6
g = 7
h = 8

one = {'A':a,'B':b}
two = {'C':c,'D':d}
three = {'E':e,'F':f}
four = {'G':g,'H':h}
list = [one,two,three,four]

def main():
    for eachfilename, eachdict in enumerate(list):
        with open(eachfilename, 'w') as csvfile:
            writer = csv.writer(csvfile)
            for line in eachdict: 
                writer.writerow(line)   

main()

In the end I would like to have four .csv files looking like this:

最后我想有四个.csv文件看起来像这样:

File1:

A,a
B,b

File2:

C,c
D,d

File3: ...

2 个解决方案

#1

You have several issues with your code that you need to resolve first.

您的代码有几个问题需要先解决。

Variable names cannot be integers

变量名不能是整数

Variables a, b, c, d, e, f, g, h are all undefined.

变量a,b,c,d,e,f,g,h都是未定义的。

The argument that you pass into csv.writer() must have have write() functionality - in your case it should be a File object. Hence you should use csv.writer(csvfile), not csv.writer(eachfilename).

传递给csv.writer()的参数必须具有write()功能 - 在您的情况下,它应该是File对象。因此,您应该使用csv.writer(csvfile),而不是csv.writer(eachfilename)。

2 个解决方案

#1

更多相关文章

随机推荐