List to CSV in Python

Question

I am creating a CSV from a list of values. CSV File gets created but the csv is formed as a single column. Actually it should be multiple rows with multiple columns, instead it forms as a multiple rows with a single column. I am using the following code

from random import choice
import csv
fileObject = csv.writer(open('Insurance.csv','w'),dialect='excel',delimiter=' ')
for i in range(0,175):
    current_list = list(choice(master_list))
    fileObject.writerows(current_list)
    current_list = []

Thanks

interjay · Accepted Answer · 2010-04-19 11:15:15Z

6

If your intent is to write 175 rows, you need to use:

fileObject.writerow(current_list)

instead of writerows. writerows is used when you have a list of rows (a list of lists), and in this case you have a single row.

answered Apr 19, 2010 at 11:15

interjay

111k22 gold badges278 silver badges264 bronze badges

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

Comments

Little Bobby Tables · Accepted Answer · 2010-04-19 11:16:49Z

1

Are you sure about this delimiter? If my memory serves, the delimiter in a CSV file should be a comma (hence the name, Comma-Separated Values), and not a space.

answered Apr 19, 2010 at 11:16

Little Bobby Tables

5,3812 gold badges41 silver badges51 bronze badges

Collectives™ on Stack Overflow

List to CSV in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related