关于#python字典写入csv#的问题:csv_output.writerow(['列名1','列名2'])

字典如下:(
adiv={'100156': [['180', '153']], '100045': [['203', '203'], ['203', '76']],
'100059': [['183', '187'], ['187', '187']],
'100162': [['61', '91'], ['61', '213'], ['61', '119']]}

img


想将它存入csv且格式如下:

img

我的操作:

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])

得到结果如下,并不是我想要的格式:

img


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])