How to check for empty cells in csv before converting to int (Python script)?

Question

I am new to stackoverflow and python so please forgive me if this question lacks detail

I want to import data from a csv file to a table in Postgres. However, I'm not sure how to check for null values. I would like to import certain values as ints (these values for some reason have a .0 trailing them ie 10.0 when I want 10) . Some of the cells for on_hand and on_order are null though - how would I go about checking to see if these cells are null and if they are null, to simply do a row[2].strip and row[3].strip?

for row in reader:
    arg = {
        'name': row[0].strip(),
        'description': row[1].strip(),
        'on_hand': int(float(row[2].strip())),
        'on_order': int(float(row[3].strip()))
    }
    cur.execute(
        """INSERT INTO 
        "Inventory"("Name","Description","On hand","On order")
         select %(name)s, 
            %(description)s, 
            %(on_hand)s,
            %(on_order)s,
        WHERE NOT EXISTS (
                SELECT * FROM "Inventory" WHERE "Name"=%(name)s
            );""", arg)

thanks!

Answer 1

How about this - basically convert to float only if row[2] actually has some value, else just return an empty string "" (You may return None as well)/

for row in reader:
    arg = {
        'name': row[0].strip(),
        'description': row[1].strip(),
        'on_hand': int(float(row[2].strip())) if row[2].strip() else "",
        'on_order': int(float(row[3].strip())) if row[3].strip() else ""
    }

Answer 2

I would just try to cast and in case of a ValueError exception assign None to to the variable.

for row in reader:

    try:
        on_hand = int(float(row[2]))
    except ValueError:
        on_hand = None

    try:
        on_order = int(float(row[3]))
    except ValueError:
        on_order = None

    arg = {
        'name': row[0].strip(),
        'description': row[1].strip(),
        'on_hand': on_hand,
        'on_order': on_order
    }