从CSV文件创建字典?我正在尝试从CSV文件创建一个字典。CSV文件的第一列包含唯一的键,第二列包含值。CSV文件的每一行表示字典中唯一的键值对。我试着用csv.DictReader和csv.DictWriter类,但我只能知道如何为每一行生成一个新字典。我想要一本字典。下面是我试图使用的代码:import csvwith open('coors.csv', mode='r') as infile:
reader = csv.reader(infile)
with open('coors_new.csv', mode='w') as outfile:
writer = csv.writer(outfile)
for rows in reader:
k = rows[0]
v = rows[1]
mydict = {k:v for k, v in rows}
print(mydict)当我运行上面的代码时,我会得到一个ValueError: too many values to unpack (expected 2)..如何从CSV文件创建一个字典?谢谢。
3 回答
手掌心
TA贡献1942条经验 获得超3个赞
with open('coors.csv', mode='r') as infile: reader = csv.reader(infile) with open('coors_new.csv', mode='w') as outfile: writer = csv.writer(outfile) mydict = {rows[0]:rows[1] for rows in reader}
mydict = dict((rows[0],rows[1]) for rows in reader)
婷婷同学_
TA贡献1844条经验 获得超8个赞
csv.DictReader
.
input_file = csv.DictReader(open("coors.csv"))
for row in input_file: print row
dictobj = csv.DictReader(open('coors.csv')).next()
添加回答
举报
0/150
提交
取消