Python Dictionary to CSV

by

Sample data:

mydict = [{"col1": 1000, "col2": 2000}, {"col1": 3000, "col2": 4000}]

One-liner for converting a list of dicts to CSV, using pandas: 

import pandas as pd

pd.DataFrame(mydict).to_csv('out.csv', index=False)

Results:

col1,col2
1000,2000
3000,4000

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. 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. A simple maths operation on a CSV column using python [closed]
  13. How to write a python code which copies a unique column from an output file to a .csv file
  14. I don’t know how to display step 3 for this assignment
  15. Access a particular field in arbitrarily nested JSON data [duplicate]
  16. How to use a dot “.” to access members of dictionary?
  17. How to implement an ordered, default dict?
  18. Python dictionary from an object’s fields
  19. Why can a Python dict have multiple keys with the same hash?
  20. Compare two CSV files and search for similar items
  21. [] and {} vs list() and dict(), which is better?
  22. Pandas read csv file with float values results in weird rounding and decimal digits
  23. top values from dictionary
  24. can you write a str.replace() using dictionary values in Python?
  25. Find dictionary keys with duplicate values
  26. Read .csv file from URL into Python 3.x – _csv.Error: iterator should return strings, not bytes (did you open the file in text mode?)
  27. What are dict_keys, dict_items and dict_values?
  28. differences between “d = dict()” and “d = {}”
  29. How to extract all values from a dictionary in Python?
  30. Comparing 2 lists consisting of dictionaries with unique keys in python

Leave a Comment