Write python dictionary to CSV columns: keys to first column, values to second
csv, dictionary, python
Solution
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():`
Problem
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 ```