Python list in csv file

Question

I have a question about how to save a list as a CSV file in my way:

If I have a big list with many sub-lists: records = [['a','b','c','d'], ['1','2','3','4'], ......]

and i use this code to generate a csv file:

import csv
create = csv.writer(open(filename, "wb"))
create.writerow(records)

it displays all sub-list in one row and each one is in one cell: ['a','b','c','d'] ['1','2','3','4'].....

However i don't want the square brackets and quotation marks, but want every item in one cell, and only one sub-list per row: a,b,c,d 1,2,3,4

I'm new to python and really know few about the codes. hope u can help me :)

Have you tried to loop on your data and call writerow() for each of them ? — user948581
– user948581, Commented Aug 27, 2012 at 9:41

jfs · Accepted Answer · 2012-08-27 09:44:00Z

2

with open(filename, "wb") as file:
    csv.writer(file).writerows(records)

answered Aug 27, 2012 at 9:44

jfs

417k210 gold badges1k silver badges1.7k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Daniel Lee · Accepted Answer · 2016-08-10 14:46:35Z

1

import csv
create = csv.writer(open(filename, "wb"))
for element in record:
    create.writerow(element)

Should give you what you want.

answered Aug 10, 2016 at 14:46

Daniel Lee

8,1994 gold badges31 silver badges47 bronze badges

UltraInstinct · Accepted Answer · 2012-08-27 09:42:26Z

0

You need to iterate over the records structure. Something like this:

for x in records:
    create.writerow(x)

answered Aug 27, 2012 at 9:42

UltraInstinct

44.6k12 gold badges85 silver badges108 bronze badges