How to add data into csv file from different lists without using pandas?

Question

i have taken 6 different input from users and have stored them in 6 different lists. Now my question is how can I add those 6 lists in 6 different columns in csv file without using pandas? I would be forever grateful for your help?

Answer 1

As done here: Write dictionary of lists to a CSV file

I would suggest saving all the lists into a dictionary with the keys being the headings wanted for the csv and then save it to csv as done in the answer withing that question.

Answer 2

d = {"key1": [1,2,3], "key2": [4,5,6], "key3": [7,8,9]}
with open("test.csv", "wb") as outfile:
writer = csv.writer(outfile)
writer.writerow(d.keys())
writer.writerows(zip(*d.values()))

Answer 3

I don't normally give an answer unless the OP has already made an attempt at a solution. But since there have been a couple of answers, I will offer mine:

First, according to the the documentation, the file should be opened in a very specific way, i.e. as a text file and specifying newline='') to ensure that each line in the output is terminated with the \r\n as required by the CSV specification.

import csv

column_headers = [
    'header1', 'header2', 'header3', 'hedader4', 'header5', 'header6'
]

column1 = ['a1', 'a2']
column2 = ['b1', 'b2']
column3 = ['c1', 'c2']
column4 = ['d1', 'd2']
column5 = ['e1', 'e2']
column6 = ['f1', 'f2']

with open('test.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow(column_headers) # if you want column headers
    writer.writerows(zip(column1, column2, column3, column4, column5, column6))