Module for reading CSV data
Cliff Wells
logiplexsoftware at earthlink.net
Fri Nov 9 15:11:11 EST 2001
On Friday 09 November 2001 11:20, David A McInnis wrote:
> Is there a module for reading CSV files into a dictionary? Or is there a
> builtin that is used in conjunction with readlines()?
>
> The first row of my csv file contains field names.
>
How do you plan on storing the data in a dictionary? What would be the
dictionary key?
Is this what you're looking for?
l = [
['a', 'b', 'c', 'd', 'e'], # this is the column names
[1, 2, 3, 4, 5], # some data
[6, 7, 8, 9, 10],
]
d = {}
for h in range(len(l[0])):
d[l[0][h]] = [row[h] for row in l]
The result is a dictionary (d) keyed on the column name ('a', 'b', 'c'...)
with each item containing a list of data.
Hope this helps.
--
Cliff Wells
Software Engineer
Logiplex Corporation (www.logiplex.net)
(503) 978-6726 x308
(800) 735-0555 x308
More information about the Python-list
mailing list