Creating a dictionary from a CSV file

by

Create a dictionary, then iterate over the result and stuff the rows in the dictionary. Note that if you encounter a row with a duplicate date, you will have to decide what to do (raise an exception, replace the previous row, discard the later row, etc…)

Here’s test.csv:

Date,Foo,Bar
123,456,789
abc,def,ghi

and the corresponding program:

import csv
reader = csv.reader(open('test.csv'))

result = {}
for row in reader:
    key = row[0]
    if key in result:
        # implement your duplicate row handling here
        pass
    result[key] = row[1:]
print(result)

yields:

{'Date': ['Foo', 'Bar'], '123': ['456', '789'], 'abc': ['def', 'ghi']}

or, with DictReader:

import csv
reader = csv.DictReader(open('test.csv'))

result = {}
for row in reader:
    key = row.pop('Date')
    if key in result:
        # implement your duplicate row handling here
        pass
    result[key] = row
print(result)

results in:

{'123': {'Foo': '456', 'Bar': '789'}, 'abc': {'Foo': 'def', 'Bar': 'ghi'}}

Or perhaps you want to map the column headings to a list of values for that column:

import csv
reader = csv.DictReader(open('test.csv'))

result = {}
for row in reader:
    for column, value in row.items():  # consider .iteritems() for Python 2
        result.setdefault(column, []).append(value)
print(result)

That yields:

{'Date': ['123', 'abc'], 'Foo': ['456', 'def'], 'Bar': ['789', 'ghi']}

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. 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. Python: Writing Nested Dictionary to CSV
  12. Why dict.get(key) instead of dict[key]?
  13. Python import csv to list
  14. Remove duplicate dict in list in Python
  15. How to get a random value from dictionary?
  16. How to write to a CSV line by line?
  17. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  18. Hashing a dictionary?
  19. How to read a column of csv as dtype list using pandas?
  20. Using a Python Dictionary as a Key (Non-nested)
  21. Python: CSV write by column rather than row
  22. Read csv from Google Cloud storage to pandas dataframe
  23. How do I return dictionary keys as a list in Python?
  24. Why can’t I use a list as a dict key in python? Exactly what can and cannot be used, and why?
  25. Python dictionary replace values
  26. How to get multiple dictionary values?
  27. Sort a list of tuples by second value, reverse=True and then by key, reverse=False
  28. Using Python class as a data container [closed]
  29. sorting list of nested dictionaries in python
  30. How to convert only numbers in a mixed list into float

Leave a Comment