Python:将 3 个列表连接到 csv 文件中？

Question

我有三个列表:

名称 = ['罗布', '迈克', '鲍勃']
年龄 = ['19,'32','88']
id = ['aaa', 'bbb', 'ccc']

有没有办法将它们垂直连接并获得如下所示的 CSV？

抢，19，aaa
迈克，32，bbb
鲍勃，88，ccc


Answer 1

您可以使用csv模块和 zip 来执行此操作。

name = ['rob', 'mike', 'bob']
age = ['19', '32', '88']
id = ['aaa', 'bbb', 'ccc']
import csv
with open('eggs.csv', 'w', newline='') as csvfile:
    spamwriter = csv.writer(csvfile, delimiter=',',
                            quotechar='|', quoting=csv.QUOTE_MINIMAL)

    data = list(zip(name, age, id))
    for row in data:
        row = list(row)
        spamwriter.writerow(row)
print("Program completed")

输出: