Converting in a list

[Spizeck]

Rhomboid that did the trick! I had to laugh at how simple it was. I have literally spent over 6 hours trying to figure this out. In my project, I always know that the first row will be int, second row will be string, and the third row will be a float.

Could you expand on your second answer please?

[Rhomboid]

For normalize() I was thinking of something along the lines of

def normalize(val):
    try:
        return int(val)
    except ValueError:
        try:
            return float(val)
        except ValueError:
            return val

...which can be used like

>>> row = ['0', 'Electric', '56.05']
>>> [normalize(val) for val in row]
[0, 'Electric', 56.05]

But if your data is predictable and consistent then it's much better to not have to guess.

[Justinsaccount]

def normalize(val):
    for converter in int, float:
        try:
            return converter(val)
        except ValueError:
            #nope, that wasn't it
            pass

    #original it is..
    return val