Storing list in to csv file using python

Question

I'm trying to store a type list variable in to a csv file using python. Here is what I got after hours on StackOverflow and python documentation:

Code:

row = {'SgDescription': 'some group', 'SgName': 'sku', 'SgGroupId': u'sg-abcdefgh'}
new_csv_file = open("new_file.csv",'wb')
ruleswriter = csv.writer(new_csv_file,dialect='excel',delimiter=',')
ruleswriter.writerows(row)
new_csv_file.close()

Result:

$ more new_file.csv 
S,g,D,e,s,c,r,i,p,t,i,o,n
S,g,N,a,m,e
S,g,G,r,o,u,p,I,d

Can anyone please advice how to store the values to the file like this:

some group,sku,sg-abcdefgh

Thanks a ton!

izak · Accepted Answer · 2016-06-07 11:24:01Z

1

writerows() expects a sequence of sequences, for example a list of lists. You're passing in a dict, and a dict happens to be iterable: It returns the keys of the dictionary. Each key -- a string -- happens to be iterable as well. So what you get is an element of each iterable per cell, which is a character. You got exactly what you asked for :-)

What you want to do is write one row, with the keys in it, and then maybe another with the values, eg:

import csv

row = {
    'SgDescription': 'some group',
    'SgName': 'sku',
    'SgGroupId': u'sg-abcdefgh'
}


with open("new_file.csv",'wb') as f:
    ruleswriter = csv.writer(f)
    ruleswriter.writerows([row.keys(), row.values()])

If order is important, use collections.OrderedDict.

answered Jun 7, 2016 at 11:24

izak

5837 silver badges10 bronze badges

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

1 Comment

Mike Over a year ago

thanks a lot, using the row.values() solved my problem

SparkAndShine · Accepted Answer · 2016-06-07 13:22:27Z

1

Extract your desired data before writing into a csv file,

row = [row['SgDescription'], row['SgName'], row['SgGroupId']]       # ['some group', 'sku', u'sg-abcdefgh']


# write to a csv file
with open("new_file.csv",'wb') as f:
    ruleswriter = csv.writer(f)
    ruleswriter.writerow(row)

PS: if you don't care about the order, just use row.values().

Or use csv.DictWriter,

import csv

row = {'SgDescription': 'some group', 'SgName': 'sku', 'SgGroupId': u'sg-abcdefgh'}
with open('new_file.csv', 'w') as csvfile:
    fieldnames = ['SgDescription', 'SgName', 'SgGroupId']
    writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
    writer.writerow(row)

edited Jun 7, 2016 at 13:22

answered Jun 7, 2016 at 11:21

SparkAndShine

18.2k27 gold badges99 silver badges140 bronze badges

Collectives™ on Stack Overflow

Storing list in to csv file using python

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related