How to write List of lists in csv file in python

Question

I have a list of lists and I want to write it in csv file Example list:

data=[['serial', 'name', 'subject'],['1', 'atul','tpa'],['2', 'carl','CN'].......]

data[0] should be column names everything else is row wise data

Please suggest me a way to do this.

Answer 1

This is trivial with the csv module:

with open('output.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerows(data)

You already have the header in data as the first row; you can write all rows in one go with the writer.writerows() method. That's all there is to it, really.

Answer 2

I get the following error when I include newline='': TypeError: 'newline' is an invalid keyword argument for this function.

This is what I used and worked fine for me.

csv_file = open("your_csv_file.csv", "wb")
writer = csv.writer(csv_file)
writer.writerows(clean_list)