Reading a CSV file into a list of dictionaries

[Laurent RAHUEL]

RFQ wrote:

> Hi, I'm struggling here to do the following with any success:
> 
> I have a comma delimited file where each line in the file is something
> like:
> 
> PNumber,3056,Contractor,XYZ Contracting,Architect,ABC Architects,...

This is NOT a CSV file. A CSV file would be :

PNumber,Contractor,Architect,...
2056,XYZ Contracting,ABC Architects,...

Then, you could use the built-in CSV module of recent python versions.

> 
> So each line is intended to be: key1,value1,key2,value2,key3,value3...
> and each line is to be variable in length (although it will have to be
> an even number of records so that each key has a value).
> 
> I want to read in this csv file and parse it into a list of
> dictionaries. So each record in the list is a dictionary:
> 
> {"PNumber":"3056","Contractor":"XYZ Contracting", ... }
> 
> I have no problem reading in the CSV file to a list and splitting each
> line in the file into its comma separated values. But I can't figure
> out how to parse each resulting list into a dictionary.
> 
> Any help on this?

By,