Python: Writing Nested Dictionary to CSV

by

This looks like a job for DictWriter:

import csv
import itertools
import sys

fields = [ 'org', '2015', '2014', '2013' ]
dw     = { 'orgname1': { '2015' : 2, '2014' : 1, '2013' : 1 },
           'orgname2': { '2015' : 1, '2014' : 2, '2013' : 3 },
           'orgname3': { '2015' : 1, '2014' : 3, '2013' : 1 }
        }

w = csv.DictWriter( sys.stdout, fields )
for key,val in sorted(dw.items()):
    row = {'org': key}
    row.update(val)
    w.writerow(row)

More Related Contents:

  1. Connecting data in python to spreadsheets
  2. Creating a dictionary from a csv file?
  3. How do I convert this list of dictionaries to a csv file?
  4. Writing a dictionary to a csv file with one line for every ‘key: value’
  5. Creating a dictionary from a CSV file
  6. Merging two CSV files using Python
  7. Write dictionary of lists to a CSV file
  8. Python Dictionary to CSV
  9. convert csv file to list of dictionaries
  10. Why does CSV file contain a blank line in between each data line when outputting with Dictwriter in Python [duplicate]
  11. Converting a csv file into a list of tuples with python
  12. Update a CSV file?
  13. Why can’t I use a list as a dict key in python?
  14. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  15. Creating a list of dictionaries results in a list of copies of the same dictionary
  16. How to check if one dictionary is a subset of another larger dictionary?
  17. switching keys and values in a dictionary in python [duplicate]
  18. Most Pythonic Way to Build Dictionary From Single List
  19. How can I update an attribute created by a base class’ mutable default argument, without modifying that argument? [duplicate]
  20. How to pass dictionary items as function arguments in python? [duplicate]
  21. Python DictWriter writing UTF-8 encoded CSV files
  22. scipy.io.loadmat nested structures (i.e. dictionaries)
  23. Numpy loading csv TOO slow compared to Matlab
  24. How to sort dictionary by key in numerical order Python
  25. How to read one single line of csv data in Python?
  26. Python: skip comment lines marked with # in csv.DictReader
  27. Accepting a dictionary as an argument with argparse and python [duplicate]
  28. Should I use a class or dictionary?
  29. Pandas df.to_csv(“file.csv” encode=”utf-8″) still gives trash characters for minus sign
  30. How to add an element to the beginning of an OrderedDict?

Leave a Comment