quick and smart way for parsing a CSV file?

[Hank]

Hi,

I have a CSV file from excel that looks like this (simplified):

name,descriptio n,type1,type2,n ame,filename
test1,this is a test,0.000,1.00 0,,
test2,another test,1.000,0.00 0,newname,filen ame
test3,this is a test,0.000,1.00 0,,
test4,this is a test,0.000,1.00 0,,
test5,this is a test,0.000,1.00 0,,
test6,this is a test,0.000,1.00 0,,

what i want at the end is a dictionary like

dict1[name] = test1
dict1[description] = "this is a test"
..
..
..
dict2[name] = test2
dict2[description] = "another test"

whats a fast and quick way of parsing it? Look for the first comma,
strip that entry out of the string, keep going? Thought there might be
some shortcuts.

Thanks

[achrist]

Hank wrote:

Hi,

I have a CSV file from excel that looks like this (simplified):

name,descriptio n,type1,type2,n ame,filename
test1,this is a test,0.000,1.00 0,,
test2,another test,1.000,0.00 0,newname,filen ame
test3,this is a test,0.000,1.00 0,,
test4,this is a test,0.000,1.00 0,,
test5,this is a test,0.000,1.00 0,,
test6,this is a test,0.000,1.00 0,,

what i want at the end is a dictionary like

dict1[name] = test1
dict1[description] = "this is a test"
.
.
.
dict2[name] = test2
dict2[description] = "another test"

import csv

dicts = []

inputFile = open("SomeDurnF ileName.csv", "rb")
parser = csv.reader(inpu tFile)
firstRec = True
for fields in parser:
if firstRec:
fieldNames = fields
firstRec = False
else:
dicts.append({} )
for i,f in enumerate(field s)
dicts[-1][fieldNames[i]] = f

[Michael Peuser]

<ac*****@easyst reet.com> schrieb im Newsbeitrag
news:3F******** *******@easystr eet.com...

Hank wrote:

Hi,

I have a CSV file from excel that looks like this (simplified):

..........

import csv

dicts = []

inputFile = open("SomeDurnF ileName.csv", "rb")
parser = csv.reader(inpu tFile)

If you do not use Python 2.3 for some reason or other there is a third party
CSV that is fast and workes fine with Python 2.2 (but uses a different
interface of course)
http://www.object-craft.com.au/projects/csv/

Kindly
Michael P

[John Hunter]

>>>>> "Hank" == Hank <so*********@ya hoo.ca> writes:

Hank> Hi, I have a CSV file from excel that looks like this
Hank> (simplified):

Hank> name,descriptio n,type1,type2,n ame,filename test1,this is a
Hank> test,0.000,1.00 0,, test2,another
Hank> test,1.000,0.00 0,newname,filen ame test3,this is a
Hank> test,0.000,1.00 0,, test4,this is a test,0.000,1.00 0,,
Hank> test5,this is a test,0.000,1.00 0,, test6,this is a
Hank> test,0.000,1.00 0,,

I posted some code recently to parse CSV into a dictionary where you
can extract rows or columns by key or index number. It's not exactly
what you asked for, but might help

http://groups.google.com/groups?hl=e...hon.org&rnum=4

John Hunter

[Hank]

where would i get this csv module from? does it come with python 2.2?

thanks
ac*****@easystr eet.com wrote in message news:<3F******* ********@easyst reet.com>...

Hank wrote:

Hi,

I have a CSV file from excel that looks like this (simplified):

name,descriptio n,type1,type2,n ame,filename
test1,this is a test,0.000,1.00 0,,
test2,another test,1.000,0.00 0,newname,filen ame
test3,this is a test,0.000,1.00 0,,
test4,this is a test,0.000,1.00 0,,
test5,this is a test,0.000,1.00 0,,
test6,this is a test,0.000,1.00 0,,

what i want at the end is a dictionary like

dict1[name] = test1
dict1[description] = "this is a test"
.
.
.
dict2[name] = test2
dict2[description] = "another test"

import csv

dicts = []

inputFile = open("SomeDurnF ileName.csv", "rb")
parser = csv.reader(inpu tFile)
firstRec = True
for fields in parser:
if firstRec:
fieldNames = fields
firstRec = False
else:
dicts.append({} )
for i,f in enumerate(field s)
dicts[-1][fieldNames[i]] = f

[Michael Peuser]

"Hank" <so*********@ya hoo.ca> schrieb im Newsbeitrag
news:73******** *************** ***@posting.goo gle.com...

where would i get this csv module from? does it come with python 2.2?

thanks

No of course - read my posting!

Kindly
Michael P

[Skip Montanaro]

where would i get this csv module from? does it come with python 2.2?
thanks

It comes with Python 2.3. If you grab the csv and _csv modules from the
Python 2.3 CVS repository, they should build and run under 2.2.x. If that's
not possible, poke around for Object Craft's csv module.

Skip

[Skip Montanaro]

soundwave56> I have a CSV file from excel that looks like this
soundwave56> (simplified):

soundwave56> name,descriptio n,type1,type2,n ame,filename
soundwave56> test1,this is a test,0.000,1.00 0,,
soundwave56> test2,another test,1.000,0.00 0,newname,filen ame
soundwave56> test3,this is a test,0.000,1.00 0,,
soundwave56> test4,this is a test,0.000,1.00 0,,
soundwave56> test5,this is a test,0.000,1.00 0,,
soundwave56> test6,this is a test,0.000,1.00 0,,

Take a look at the csv module delivered with Python 2.3.

Skip

[Hank]

I'm using ActivePython2.2 which has the win32 extensions included.
Don't think they have a ActivePython2.3 out yet.

Also I was trying out PAGE which needed 2.2. Don't have the resources
to recompile for 2.3.

Thanks for the help!

"Michael Peuser" <mp*****@web.de > wrote in message news:<bj******* ******@news.t-online.com>...

<ac*****@easyst reet.com> schrieb im Newsbeitrag
news:3F******** *******@easystr eet.com...

Hank wrote:

Hi,

I have a CSV file from excel that looks like this (simplified):

.........

import csv

dicts = []

inputFile = open("SomeDurnF ileName.csv", "rb")
parser = csv.reader(inpu tFile)

If you do not use Python 2.3 for some reason or other there is a third party
CSV that is fast and workes fine with Python 2.2 (but uses a different
interface of course)
http://www.object-craft.com.au/projects/csv/

Kindly
Michael P