Converting a csv file into a list of tuples with python

by

You can ponder this:

import csv

def fitem(item):
    item=item.strip()
    try:
        item=float(item)
    except ValueError:
        pass
    return item        

with open('/tmp/test.csv', 'r') as csvin:
    reader=csv.DictReader(csvin)
    data={k.strip():[fitem(v)] for k,v in reader.next().items()}
    for line in reader:
        for k,v in line.items():
            k=k.strip()
            data[k].append(fitem(v))

print data

Prints:

{'Price': [6.05, 8.05, 6.54, 6.05, 7.05, 7.45, 5.45, 6.05, 6.43, 7.05, 8.05, 3.05],
 'Type': ['orange', 'orange', 'orange', 'pear', 'pear', 'pear', 'apple', 'apple', 'apple', 'apple', 'plum', 'plum'], 
 'Brand': ['brand1', 'brand2', 'brand3', 'brand1', 'brand2', 'brand3', 'brand1', 'brand2', 'brand3', 'brand4', 'brand1', 'brand2'], 
 'Weight': [3.2, 5.2, 4.2, 3.2, 3.6, 3.9, 2.7, 3.2, 3.5, 3.9, 4.2, 2.2]}

If you want the csv file literally as tuples by rows:

import csv
with open('/tmp/test.csv') as f:
    data=[tuple(line) for line in csv.reader(f)]

print data
# [('Brand', ' Price', ' Weight', ' Type'), ('brand1', ' 6.05', ' 3.2', ' orange'), ('brand2', ' 8.05', ' 5.2', ' orange'), ('brand3', ' 6.54', ' 4.2', ' orange'), ('brand1', ' 6.05', ' 3.2', ' pear'), ('brand2', ' 7.05', ' 3.6', ' pear'), ('brand3', ' 7.45', ' 3.9', ' pear'), ('brand1', ' 5.45', ' 2.7', ' apple'), ('brand2', ' 6.05', ' 3.2', ' apple'), ('brand3', ' 6.43', ' 3.5', ' apple'), ('brand4', ' 7.05', ' 3.9', ' apple'), ('brand1', ' 8.05', ' 4.2', ' plum'), ('brand2', ' 3.05', ' 2.2', ' plum')]

More Related Contents:

  1. Connecting data in python to spreadsheets
  2. Why can’t I use a list as a dict key in python?
  3. Creating a dictionary from a csv file?
  4. How do I convert this list of dictionaries to a csv file?
  5. Writing a dictionary to a csv file with one line for every ‘key: value’
  6. Creating a dictionary from a CSV file
  7. Merging two CSV files using Python
  8. List of tuples to dictionary [duplicate]
  9. Write dictionary of lists to a CSV file
  10. Converting a list of tuples into a dict
  11. python tuple to dict
  12. Python Dictionary to CSV
  13. Convert a namedtuple into a dictionary
  14. Why can’t I use a list as a dict key in python? Exactly what can and cannot be used, and why?
  15. convert csv file to list of dictionaries
  16. Why does CSV file contain a blank line in between each data line when outputting with Dictwriter in Python [duplicate]
  17. In what case would I use a tuple as a dictionary key? [closed]
  18. Python: Writing Nested Dictionary to CSV
  19. Dictionaries and default values
  20. Grouping Python dictionary keys as a list and create a new dictionary with this list as a value
  21. How do I initialize a dictionary of empty lists in Python?
  22. Importing a CSV file into a sqlite3 database table using Python
  23. Comparing two dictionaries and checking how many (key, value) pairs are equal
  24. List vs tuple, when to use each? [duplicate]
  25. Pandas DataFrame to List of Dictionaries
  26. Use Multiple Character Delimiter in Python Pandas read_csv
  27. Reading from CSVs in Python repeatedly?
  28. Python Class __div__ issue
  29. differences between “d = dict()” and “d = {}”
  30. If in Python I put a list inside a tuple, can I safely change the contents of that list? [duplicate]

Leave a Comment