topic Re: Populate new field based on max value in Python Questions

Populate new field based on max value

NikolajGrønholdt — Wed, 27 Feb 2019 11:56:24 GMT

I am working with election data, with each row representing a district and each column represent a party. The columns have a percentage value for each party, in relation to total amount of votes in the given district. I have attached a screenshot of

my table.

Is there some way, using arcpy, that I can populate a new field with the column name of the winning party, as well as another field with the winning percentage?

An example could be the first row, where the winning party is 'A. Socialdemokratiet', with a percentage of 28,8. These two values would then be written to two new columns, say 'Winner: A. Socialdemokratiet' and 'Winner_share: 28,8'

Re: Populate new field based on max value

RandyBurton — Fri, 10 Dec 2021 21:55:55 GMT

You might try something like:

import arcpy

fc = r"C:\path\to\file.gdb\feature"

# add field (may want to check if they exist first)
arcpy.AddField_management(fc, "winner", "TEXT", "", "", 50,
                          "winner", "NULLABLE")
arcpy.AddField_management(fc, "percent", "DOUBLE", "", "", "",
                          "percent", "NULLABLE")

# list of fields with votes, and for winner and winning percent
fields = [ 'socialdemo', 'radikale', 'konservative', 'socialistisk', 'liberal', 'winner', 'percent' ]

with arcpy.da.UpdateCursor(fc, fields) as cursor:
    for row in cursor:
        votes = row[:5] # fields with vote counts or percentages

        # get maximum vote / percent
        winTotal = max(votes)
        # get winner / party
        winner = fields[votes.index(max(votes))]

        # other options if needed
        # # if votes, you can sum them
        # vTotal = sum(votes)
        # # and calculate percentage
        # percent = float(winTotal)/vTotal

        row[5] = winner   # party
        row[6] = winTotal # percent
        cursor.updateRow(row)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Hope this helps.

Re: Populate new field based on max value

NikolajGrønholdt — Thu, 28 Feb 2019 07:52:54 GMT

That worked just as intended. Thank you for the help. For some reason, I couldn't come up with the votes.index part.