從CSV文件創(chuàng)建字典?我正在嘗試從CSV文件創(chuàng)建一個字典。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)當(dāng)我運行上面的代碼時,我會得到一個ValueError: too many values to unpack (expected 2)..如何從CSV文件創(chuàng)建一個字典?謝謝。
3 回答

手掌心
TA貢獻1942條經(jīng)驗 獲得超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)

婷婷同學(xué)_
TA貢獻1844條經(jīng)驗 獲得超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
提交
取消