Python: Concatenate 3 lists into csv file?

Question

I have three lists:

name = ['rob', 'mike', 'bob'] age = ['19, '32', '88'] id = ['aaa', 'bbb', 'ccc']

Is there a way to concatenate these vertically and get a CSV as below?

rob, 19, aaa mike, 32, bbb bob, 88, ccc

Answer 1

You can utilize csv module and zip to do this.

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

Output:

Answer 2

By using pandas

import pandas as pd 
pd.DataFrame({'name':name,'age':age,'id':id}).to_csv('your.csv')