Write dictionary of lists to a CSV file

by

If you don’t care about the order of your columns (since dictionaries are unordered), you can simply use zip():

d = {"key1": [1,2,3], "key2": [4,5,6], "key3": [7,8,9]}
with open("test.csv", "wb") as outfile:
   writer = csv.writer(outfile)
   writer.writerow(d.keys())
   writer.writerows(zip(*d.values()))

Result:

key3    key2    key1
7       4       1
8       5       2
9       6       3

If you do care about order, you need to sort the keys:

keys = sorted(d.keys())
with open("test.csv", "wb") as outfile:
   writer = csv.writer(outfile, delimiter = "\t")
   writer.writerow(keys)
   writer.writerows(zip(*[d[key] for key in keys]))

Result:

key1    key2    key3
1       4       7
2       5       8
3       6       9

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. Python Dictionary to CSV
  8. convert csv file to list of dictionaries
  9. Why does CSV file contain a blank line in between each data line when outputting with Dictwriter in Python [duplicate]
  10. Converting a csv file into a list of tuples with python
  11. Python: Writing Nested Dictionary to CSV
  12. How do I sort a dictionary by value?
  13. Split / Explode a column of dictionaries into separate columns with pandas
  14. How to properly subclass dict and override __getitem__ & __setitem__
  15. Python out of memory on large CSV file (numpy)
  16. Splitting a semicolon-separated string to a dictionary, in Python
  17. How do I write data into CSV format as string (not file)?
  18. Python: Checking if a ‘Dictionary’ is empty doesn’t seem to work
  19. Streaming large training and test files into Tensorflow’s DNNClassifier
  20. Is there a ‘multimap’ implementation in Python?
  21. Subclassing dict: should dict.__init__() be called?
  22. python pandas read_csv delimiter in column data
  23. How to skip the headers when processing a csv file using Python?
  24. Extract a subset of key-value pairs from dictionary?
  25. How to reverse a dictionary (whose values are lists) in Python? [duplicate]
  26. module ‘pandas’ has no attribute ‘read_csv
  27. Is the order of a Python dictionary guaranteed over iterations?
  28. Get data from Twitter using Tweepy and store in csv file
  29. How can I make a list of dictionaries according to the Cartesian product of values in a source dictionary (“explode” the dictionary)?
  30. start index at 1 for Pandas DataFrame

Leave a Comment