Appending N/A to blank strings

mott3510 · #1 July 7th, 2009, 12:16 AM

I have a list of numbers imported from excel, an example line looks like this...

70609,86,91,,66,66,

I would like a N/A to be inserted in between the two commas and after the last one.
This is the code I have so far, but I haven't gotten it to work.

Expand|Select|Wrap|Line Numbers

 
f = open("C:\users\cory\desktop\code\Verification.csv")

dd = {}

keys = f.readline().strip().split(',')
 
for key in keys:

    dd.setdefault(key, [])
 
for line in f:

    elements = line.strip().split(',')

    for i, item in enumerate(elements):

        if element == "":

            dd[keys[i]].append("N/A")            

        else:

            dd[keys[i]].append(int(item))

f.close()
 
for key in keys:

    print "%s: %s" % (key, dd[key])

bvdet · #2 July 7th, 2009, 12:45 AM

You are close. Instead of

Expand|Select|Wrap|Line Numbers

if element == "":

use this:

Expand|Select|Wrap|Line Numbers

if item == "":

OR

Expand|Select|Wrap|Line Numbers

if not item:

mott3510 · #3 July 7th, 2009, 01:13 AM

Ah. So close! Thanks!

Appending N/A to blank strings

re: Appending N/A to blank strings

re: Appending N/A to blank strings

/bytes/development

/bytes/it

/bytes/about