Replace Null values with 0 in many fields

JAKERODEL

Can somebody point out what I am doing wrong here?  I am trying to get a list of fields (PrecipFields) and replace all null values with 0.  When I call out a specific field it works fine.  When I use list of fields it looks as if it runs but non of the values are updated. 

>>> with arcpy.da.UpdateCursor("asciiPoints",["ippt_allsites_spas1325_024_19230927_0700_UTC"]) as cursor:

...     for row in cursor:

...         if row[0] == None:

...             row[0] = 0

...             cursor.updateRow(row)

Works fine...

My field list I want to use...

>>> print PrecipFields

[u'ippt_allsites_spas1325_021_19230927_0400_UTC', u'ippt_allsites_spas1325_022_19230927_0500_UTC', u'ippt_allsites_spas1325_023_19230927_0600_UTC', u'ippt_allsites_spas1325_024_19230927_0700_UTC', u'ippt_allsites_spas1325_025_19230927_0800_UTC', u'ippt_allsites_spas1325_026_19230927_0900_UTC', u'ippt_allsites_spas1325_027_19230927_1000_UTC', u'ippt_allsites_spas1325_028_19230927_1100_UTC'

This is a shortened list.  There could be hundreds of fields.

Nothing happens...

>>> with arcpy.da.UpdateCursor("asciiPoints","PrecipFields") as cursor:

...     for row in cursor:

...         if row[0] == None:

...             row[0] = 0

...             cursor.updateRow(row)

...

RuthBowers

Hi, Jake. You have to enumerate through all the fields. As Darren pointed out, row[0] refers to the first column in the row. I pasted in an example below. When you use enumerate, using my example, i is the number of the column position from the left (of the columns included in the cursor), starting at 0. c is the corresponding value from the list being enumerated through, in your case, the column name.

# Assuming PrecipFields is a python list of column names.

with arcpy.da.UpdateCursor("asciiPoints", PrecipFields) as cursor:

    for row in cursor:

        updated = False

        for i, c in enumerate(PrecipFields):

            if row == None:

                row = 0

                updated = True

        if updated == True:

            cursor.updateRow(row)

I hope this is helpful.