Write python dictionary to CSV columns: keys to first column, values to second

Question

I'm looking for a way to write a python dictionary to columns (keys in first column and values in second). This link shows how to write a list to a column, but am wondering if there is a way to do this without converting my dictionary to two zipped lists.

myDict = {1:'a', 2:'b', 3:'c'}

keyList = myDict.keys()
valueList = myDict.values()

rows = zip(keyList, valueList)

with open('test.csv', 'wb') as f:
    writer = csv.writer(f)
    for row in rows:
        writer.writerow(row)

desired result:

1;a
2;b
3;c

Arkistarvh Kltzuonstev · Accepted Answer · 2019-10-03 11:01:28Z

15

You could simply do in python 2.X :

with open('test.csv', 'wb') as f:
    writer = csv.writer(f)
    for row in myDict.iteritems():
        writer.writerow(row)

For python 3.X, change the for loop line to for row in myDict.items():

edited Oct 3, 2019 at 11:01

Arkistarvh Kltzuonstev

6,9837 gold badges32 silver badges62 bronze badges

answered Jul 15, 2014 at 23:26

zsquare

10.2k6 gold badges56 silver badges87 bronze badges

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

Comments

Anorov · Accepted Answer · 2014-07-16 23:40:03Z

3

A slightly shorter version is to do:

rows = myDict.iteritems()

(Or .items() for Python 3.)

To get the ; separator, pass delimiter to csv.reader or csv.writer. In this case:

writer = csv.writer(f, delimiter=';')

edited Jul 16, 2014 at 23:40

answered Jul 15, 2014 at 23:14

Anorov

2,01014 silver badges20 bronze badges

3 Comments

zsquare Over a year ago

This would yield 1;2;3\na;b;c, not the desired output.

Michael Romrell Over a year ago

THANK YOU! It took me forever to find a suitable answer to this you helped me find my solution: with open('manifesttest2.csv', "wb") as f: writer = csv.writer(f, delimiter=',') writer.writerow(amazonData)

Anorov Over a year ago

@MichaelRomrell CSV's reader and writer objects should be using , as a delimiter by default (CSV stands for comma-separated values). Does it work without passing the parameter?

Collectives™ on Stack Overflow

Write python dictionary to CSV columns: keys to first column, values to second

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related