Playa

ArcPy: Find Maximum Value for each group.

Discussion created by Playa on Mar 25, 2014
Latest reply on Mar 26, 2014 by xander_bakker
I'm new to python and and arcpy and would like to get some advice in generating a python script. I have a table with the following fields:

Field 01:  Quinary (txt)
Field 02:  Water Management Area (txt)
Field 03:  Percentage (Double)

The table represents the results based on the intersection of the quinary (polygon) feature class that was intersected with the Water Management Area (polygon) feature class. The Percentage Field represents the percentage area of the original Quinary Feature Class that falls within the Water Management Area.

The table has multiple records where Field 01 can have the same value, Field 02 can have the same value but Field 03 will be different. I need to identify the records based on Field 01 and Field 02 and identify the maximum value in Field 03.

ID  Field 01    Field 02    Field 03
01  Q1           W1          02.00
02  Q1           W1          48.00
03  Q1           W2          50.00
04  Q2           W3          90.00
05  Q2           W4          10.00


Results Reqiured:

ID  Field 01    Field 02    Field 03
03  Q1           W2          50.00
04  Q2           W3          90.00


Any help will be appreciated.

Regards

Outcomes