How do I write a Python dictionary to a csv file

Question

I have what I think should be a very easy task that I can t seem to solve   How do I write a Python dictionary to a csv file   All I want is to write the dictionary keys to the top row of the file and the key values to the second line   The closest that I ve come is the following  that I got from somebody else s post    f   open  mycsvfile csv   wb   w   csv DictWriter f my dict keys    w writerows my dict  f close     The problem is  the above code seems to only be writing the keys to the first line and that s it   I m not getting the values written to the second line   Any ideas

User · Answer

Your code was very close to working     Try using a regular csv writer rather than a DictWriter   The latter is mainly used for writing a list of dictionaries   Here s some code that writes each key value pair on a separate row   import csv  somedict   dict raymond  red   rachel  blue   matthew  green   with open  mycsvfile csv   wb   as f      w   csv writer f      w writerows somedict items      If instead you want all the keys on one row and all the values on the next  that is also easy   with open  mycsvfile csv   wb   as f      w   csv writer f      w writerow somedict keys        w writerow somedict values      Pro tip   When developing code like this  set the writer to w   csv writer sys stderr  so you can more easily see what is being generated   When the logic is perfected  switch back to w   csv writer f

User · Answer

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     quot test quot   1   quot testing quot   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

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

Examples related to python

Examples related to dictionary