我有一行：row = {'A':'valueA', 'B':'valueB', 'C':'valueC'}基本上我想打開一個(gè)新csv文件并在其列中寫入每個(gè)值，例如 ---------------------------| A | B | C | ---------------------------| ValueA | ValueB | ValueC | ---------------------------我正在這樣做：def OandWtonew(filename, row):with open('Ouput1.csv', 'wt') as csvfile: fileout = csv.writer(csvfile, delimiter=' ', quotechar='|', quoting=csv.QUOTE_MINIMAL) fileout.writerow(row)但我得到的輸出是： --------------------------------------------| A | B | C | --------------------------------------------| 'A':'valueA' | 'B':'valueB' | 'C':'valueC'| --------------------------------------------
3 回答
一只斗牛犬
TA貢獻(xiàn)1784條經(jīng)驗(yàn) 獲得超2個(gè)贊
由于數(shù)據(jù)是字典，因此csv.DictWriter()可能是最直接的方法。只需確保標(biāo)頭值列表按原始順序排列即可，在這種情況下，這sorted()可能是最簡(jiǎn)單的：
with open('Ouput1.csv', 'wt') as csvfile:
fieldnames = sorted(row.keys()) # needs to be the first line in correct order
writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
writer.writeheader()
writer.writerow(row) # writes corresponding value for key in header
森林海
TA貢獻(xiàn)2011條經(jīng)驗(yàn) 獲得超2個(gè)贊
row是 類型dict。從文檔：
import csv
with open('names.csv', 'w') as csvfile:
fieldnames = ['first_name', 'last_name']
writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
writer.writeheader()
writer.writerow({'first_name': 'Baked', 'last_name': 'Beans'})
writer.writerow({'first_name': 'Lovely', 'last_name': 'Spam'})
writer.writerow({'first_name': 'Wonderful', 'last_name': 'Spam'})
添加回答
舉報(bào)
0/150
提交
取消