convert csv file to list of dictionaries

Use csv.DictReader:

import csv

with open('test.csv') as f:
    a = [{k: int(v) for k, v in row.items()}
        for row in csv.DictReader(f, skipinitialspace=True)]

Will result in :

[{'col2': 2, 'col3': 3, 'col1': 1}, {'col2': 5, 'col3': 6, 'col1': 4}]

Related Contents:

  1. How do I sort a list of dictionaries by a value of the dictionary?
  2. How do I convert two lists into a dictionary?
  3. Access nested dictionary items via a list of keys?
  4. Getting a list of values from a list of dicts
  5. Creating a dictionary from a csv file?
  6. How can I get list of values from dict?
  7. How do I merge a list of dicts into a single dict?
  8. Dictionary: Get list of values for list of keys
  9. Access a particular field in arbitrarily nested JSON data [duplicate]
  10. How to return dictionary keys as a list in Python?
  11. How do I convert this list of dictionaries to a csv file?
  12. Create a list with initial capacity in Python
  13. Pandas DataFrame to List of Dictionaries
  14. Creating a list of dictionaries results in a list of copies of the same dictionary
  15. In Python, when to use a Dictionary, List or Set?
  16. How can I convert a dictionary into a list of tuples?
  17. How to overcome TypeError: unhashable type: ‘list’
  18. Writing a dictionary to a csv file with one line for every ‘key: value’
  19. List of dicts to/from dict of lists
  20. Creating a dictionary from a CSV file
  21. python filter list of dictionaries based on key value
  22. How do I combine two lists into a dictionary in Python? [duplicate]
  23. Converting list of tuples into a dictionary
  24. Converting Dictionary to List? [duplicate]
  25. How to find the min/max value of a common key in a list of dicts?
  26. join two lists of dictionaries on a single key
  27. How can I access the nested data in this complex JSON, which includes another JSON document as one of the strings?
  28. List of tuples to dictionary [duplicate]
  29. Write dictionary of lists to a CSV file
  30. Check if value already exists within list of dictionaries?
  31. Appending a dictionary to a list in a loop
  32. Sorting a dictionary with lists as values, according to an element from the list
  33. Python Dictionary to CSV
  34. How can I make a dictionary (dict) from separate lists of keys and values?
  35. Combining Dictionaries Of Lists In Python
  36. How do I sort this list in Python, if my date is in a String?
  37. Most Pythonic Way to Build Dictionary From Single List
  38. Get a list of values from a list of dictionaries?
  39. Why can’t I use a list as a dict key in python? Exactly what can and cannot be used, and why?
  40. How do I return dictionary keys as a list in Python?
  41. How can I avoid “RuntimeError: dictionary changed size during iteration” error?
  42. Setting a value in a nested Python dictionary given a list of indices and value
  43. Group by multiple keys and summarize/average values of a list of dictionaries
  44. Convert list of strings to dictionary
  45. Changing one dict changes all dicts in a list of dicts [duplicate]
  46. Make dictionary from list with python [duplicate]
  47. Using a dict to translate numbers to letters in python
  48. Why does CSV file contain a blank line in between each data line when outputting with Dictwriter in Python [duplicate]
  49. Comparing 2 lists consisting of dictionaries with unique keys in python
  50. How to sort a list of dictionaries by a value of the dictionary in Python?

Leave a Comment