Importing CSV Data As Variable-Value Pairs in Python

Question

I'm trying to emulate the bash concept in Python to have data from a CSV as variable-value pairs. I've a CSV file, which can be made anyway as possible (its up to me). Currently it looks like this...

Unit,pixels
AvgVol,87654
AvgLen,5432

and similarly a long list of values. If modifying the CSV will make it work, do suggest that too.

I'm trying to read these in such a way that I can access the values like pixels using Unit or 87654 using AvgVol without having to remember their index, similar to what cat or source would do in bash. Anyways, This is useful so that I can edit my CSV file with the list of variables and their values, without having to worry about their order or anything when referring to a particular variable for its values. I'll later use these for other computations so I can go like

if AvgVol>MaxVol:
   print 'something'

Any help is appreciated and I hope its doable without much complexity. Thanks!!

Have a look at DictReader

shuttle87
– shuttle87

2016-10-24 01:00:29 +00:00
Commented Oct 24, 2016 at 1:00 — shuttle87
– shuttle87, Commented Oct 24, 2016 at 1:00

riteshtch · Accepted Answer · 2016-10-24 01:20:22Z

1

You can use the csv module to perform your task.

Here is an example:

$ cat csvfile 
Unit,pixels
AvgVol,87654
AvgLen,5432
$ python3 script.py 
{'Unit': 'pixels', 'AvgLen': 5432, 'AvgVol': 87654}

and here is the python program:

import csv

csvdict={}
with open('csvfile', 'r') as file:
    reader = csv.reader(file)
    for row in reader:
        csvdict[row[0]]=(int(row[1]) if row[1].isdigit() else row[1])

print(csvdict)

answered Oct 24, 2016 at 1:20

riteshtch

8,7894 gold badges28 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Importing CSV Data As Variable-Value Pairs in Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related