字典如下:(
adiv={'100156': [['180', '153']], '100045': [['203', '203'], ['203', '76']],
'100059': [['183', '187'], ['187', '187']],
'100162': [['61', '91'], ['61', '213'], ['61', '119']]}
)
我的操作:
with open(待写入文件.csv','w',newline='') as f_output:
csv_output=csv.writer(f_output)
csv_output.writerow(['列名1','列名2'])
for key in adiv.keys():
csv_output.writerow([key]+adiv[key])
得到结果如下,并不是我想要的格式:
with open(待写入文件.csv','w',newline='') as f_output:
csv_output=csv.writer(f_output)
csv_output.writerow(['列名1','列名2'])
for key in adiv.keys():
for item in adiv[key]:
csv_output.writerow([key,item])
import csv
adiv={'100156': [['180', '153']],
'100045': [['203', '203'], ['203', '76']],
'100059': [['183', '187'], ['187', '187']],
'100162': [['61', '91'], ['61', '213'], ['61', '119']]}
with open(r"待写入文件.csv", 'w', encoding='utf-8', newline='') as f:
cc = csv.writer(f, )
cc.writerow(["列1", '列2'])
for k, v in adiv.items():
if isinstance(v[0], list):
for j in v:
cc.writerow([k, j])