How do I write a Python dictionary to a csv file? [duplicate]

by

You are using DictWriter.writerows() which expects a list of dicts, not a dict. You want DictWriter.writerow() to write a single row.

You will also want to use DictWriter.writeheader() if you want a header for you csv file.

You also might want to check out the with statement for opening files. It’s not only more pythonic and readable but handles closing for you, even when exceptions occur.

Example with these changes made:

import csv

my_dict = {"test": 1, "testing": 2}

with open('mycsvfile.csv', 'w') as f:  # You will need 'wb' mode in Python 2.x
    w = csv.DictWriter(f, my_dict.keys())
    w.writeheader()
    w.writerow(my_dict)

Which produces:

test,testing
1,2

More Related Contents:

  1. Creating multiple python dictionaries from a file
  2. How to map dict into another dict Python
  3. Determine the type of an object?
  4. Getting key with maximum value in dictionary?
  5. Is there any pythonic way to combine two dicts (adding values for keys that appear in both)?
  6. How can I get list of values from dict?
  7. I’m getting Key error in python
  8. How to convert a file into a dictionary?
  9. How do I exchange keys with values in a dictionary? [duplicate]
  10. Multiple levels of ‘collection.defaultdict’ in Python
  11. What are dictionary view objects?
  12. How to convert a nested Python dict to object?
  13. join two lists of dictionaries on a single key
  14. How to sum all the values in a dictionary?
  15. In Python, how do I iterate over a dictionary in sorted key order?
  16. Difference between dict.clear() and assigning {} in Python
  17. Difference between defining typing.Dict and dict?
  18. How to json_normalize a column with NaNs
  19. Dictionary column in pandas dataframe
  20. JSON dumps custom formatting
  21. How to make a dictionary that returns key for keys missing from the dictionary instead of raising KeyError?
  22. JSON object must be str, bytes or bytearray, not dict
  23. How to convert a pymongo.cursor.Cursor into a dict?
  24. Changing one dict changes all dicts in a list of dicts [duplicate]
  25. Converting xml to dictionary using ElementTree
  26. Why does dict(k=4, z=2).update(dict(l=1)) return None in Python? [duplicate]
  27. Fast way to copy dictionary in Python
  28. How to type hint a dictionary with values of different types
  29. How to convert string representation of dictionary in Pandas DataFrame to a new columns?
  30. How do I send list of dictionary as Body parameter together with Files in FastAPI?

Leave a Comment