How do I convert this list of dictionaries to a csv file?

by 
import csv

to_csv = [
    {'name': 'bob', 'age': 25, 'weight': 200},
    {'name': 'jim', 'age': 31, 'weight': 180},
]

keys = to_csv[0].keys()

with open('people.csv', 'w', newline="") as output_file:
    dict_writer = csv.DictWriter(output_file, keys)
    dict_writer.writeheader()
    dict_writer.writerows(to_csv)

More Related Contents:

  1. Connecting data in python to spreadsheets
  2. Creating a dictionary from a csv file?
  3. Writing a dictionary to a csv file with one line for every ‘key: value’
  4. Creating a dictionary from a CSV file
  5. Merging two CSV files using Python
  6. Write dictionary of lists to a CSV file
  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. Convert nested JSON to CSV file in Python
  12. Python: Writing Nested Dictionary to CSV
  13. Using lambda function in python
  14. Why do my Tkinter widgets get stored as None? [duplicate]
  15. python – Using pandas structures with large csv(iterate and chunksize)
  16. Time complexity of accessing a Python dict
  17. How do I print the key-value pairs of a dictionary in python
  18. Converting a list of tuples into a dict
  19. How to sort IP addresses stored in dictionary in Python?
  20. Is it possible to keep the column order using csv.DictReader?
  21. Change values in dict of nested dicts using items in a list?
  22. Dictionary best data structure for train routes?
  23. Python UTF-16 CSV reader
  24. Using python map and other functional tools
  25. Read specific columns with pandas or other python module
  26. load csv into 2D matrix with numpy for plotting
  27. Strip white spaces from CSV file
  28. Python Parse CSV Correctly
  29. Determine whether a key is present in a dictionary [duplicate]
  30. Comparing 2 lists consisting of dictionaries with unique keys in python

Leave a Comment