如何将字典导入到csv [英] How to import dictionary to csv

问题描述

我必须将数据从字典导出到csv.词典包含列表.我试图做这样的出口

I have to export data from dictionary to csv. Dictionary contains lists. I tried to do export like this

with open("info.csv", 'w',newline='')as csvfile:
header = ['Club', 'Stadium']
writer = csv.DictWriter(csvfile, fieldnames=header)
writer.writeheader()
writer.writerow(info)

但是结果是

 Club          Stadium
 ['Arsenal,    ['Emirates',
 'AFC', etc.]  'Villia park',etc.]

我想要这个

Club         Stadium
Arsenal      Emirates
AFC          Villia park

我该怎么办?

推荐答案

您可以像这样完成自己想做的事情.

You can accomplish what you want doing it like this.

import csv

with open('info.csv', 'w', newline='') as f:
    header = info.keys()
    writer = csv.DictWriter(f, fieldnames=header)
    writer.writeheader()
    for pivoted in zip(*info.values()):  # here we take both lists and pivot them
        writer.writerow(dict(zip(header, pivoted))) # pivoted is a 2 element tuple

我经常使用 pandas ，它基本上是一个单一的选择，但是对于您的需求来说可能是一个过大的选择.

I often use pandas and it's basically a oneliner with it, but it might be an overkill for your needs.

import pandas as pd
df = pd.DataFrame(info).to_csv('info.csv', index=False)

如果通常不需要使用 pandas ，最好使用内置的 csv 模块.

If you don't need to use pandas in general, better stick with built-in csv module.

这篇关于如何将字典导入到csv的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！