Writing Python lists to columns in csv

Question

I have 5 lists, all of the same length, and I'd like to write them to 5 columns in a CSV. So far, I can only write one to a column with this code:

with open('test.csv', 'wb') as f:     writer = csv.writer(f)     for val in test_list:         writer.writerow([val]) 

If I add another for loop, it just writes that list to the same column. Anyone know a good way to get five separate columns?

Answer 1

Change them to rows:

rows = zip(list1, list2, list3, list4, list5) 

Then just:

import csv  with open(newfilePath, "w") as f:     writer = csv.writer(f)     for row in rows:         writer.writerow(row) 

Answer 2

The following code writes python lists into columns in csv

import csv from itertools import zip_longest list1 = ['a', 'b', 'c', 'd', 'e'] list2 = ['f', 'g', 'i', 'j'] d = [list1, list2] export_data = zip_longest(*d, fillvalue = '') with open('numbers.csv', 'w', encoding="ISO-8859-1", newline='') as myfile:       wr = csv.writer(myfile)       wr.writerow(("List1", "List2"))       wr.writerows(export_data) myfile.close() 

The output looks like this