topic Re: Find max value in a field. in Python Questions

Find max value in a field.

DevinUnderwood2 — Sat, 11 Dec 2021 22:40:01 GMT

Why do I get a print out of all the records values as opposed to just the highest which should be 8182 ?

with arcpy.da.SearchCursor("escroads",'RecID') as cursor:
    for row in cursor:
        print str(max(row))‍‍‍

Re: Find max value in a field.

JamesMacKay3 — Fri, 13 Oct 2017 20:50:06 GMT

Calling max() on a row will return the maximum value within the fields in that row, not the maximum across multiple rows.

Re: Find max value in a field.

DanPatterson_Retired — Sat, 11 Dec 2021 22:40:04 GMT

field_vals = [1, 1000, 10, 100, 100]

search_cursor = [row_ for row_ in field_vals]

max(search_cursor)
Out[4]: 1000‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

you have to start thinking of you search cursor in this way.

or this way.

big_num = -1e200

for row_ in field_vals:
    print("{} bigger than {}?".format(row_, big_num))
    
1 bigger than -1e+200?
1000 bigger than -1e+200?
10 bigger than -1e+200?
100 bigger than -1e+200?
100 bigger than -1e+200?
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

or do something as you go along

for row_ in field_vals:
    print("{} bigger than {}?".format(row_, row_*20))
    
1 bigger than 20?
1000 bigger than 20000?
10 bigger than 200?
100 bigger than 2000?
100 bigger than 2000?‍‍‍‍‍‍‍‍

Re: Find max value in a field.

DevinUnderwood2 — Fri, 13 Oct 2017 21:11:32 GMT

Thanks

Interesting, this is the most I have used cursors.

I get the desired result now, including the comma for some reason

with arcpy.da.SearchCursor("escroads",'RecID') as cursor:
for row in cursor:
print max(cursor)

(8182,)

Re: Find max value in a field.

DanPatterson_Retired — Fri, 13 Oct 2017 21:16:53 GMT

max of a tuple I suspect

max((8131,))
Out[16]: 8131

check whether it works on the RecID might not be good if they are sorted...

Re: Find max value in a field.

JoshuaBixby — Sat, 11 Dec 2021 22:40:07 GMT

Your existing syntax risks not providing the correct answer. Your syntax should be:

with arcpy.da.SearchCursor("escroads",'RecID') as cursor:
    print max(cursor)‍‍

The Python max function is designed to work on iterables, which a Python cursor is a form of an iterable. Your original code sets up the cursor/iterable, but the for loop moves the iterator forward one position, and then max is called against the remainder of the iterable, exhausting the cursor. If the maximum value just happens to be the first record, it will not be returned as the maximum value because max never knew the value existed.

Cursors are extremely powerful, I encourage you to learn more about them and also Python iterables. I started (but haven't finished yet) an "Iterable Cursor" blog series that might help someone new to ArcPy cursors understand how to think of them as Python iterables: /blogs/tilting/2015/11/24/the-iterable-cursor-iteration-basics.

Re: Find max value in a field.

DevinUnderwood2 — Mon, 16 Oct 2017 14:19:00 GMT

Invaluable advice I will look into this more.

Thanks.

Re: Find max value in a field.

Anonymous User — Fri, 30 Oct 2020 18:47:53 GMT

I took this concept a step or two further and developed this little one-line gem which uses list comprehension and treats the cursor like a tuple:

max([cur[0] for cur in arcpy.da.SearchCursor("Asset Layer", "ASSETID")])

Important notes: This bit of arcpy code works in ArcMap, but it fails on an empty layer because the list is empty. Also, since it's in ArcMap, the code above honors the user's selected rows or features and therefore returns the maximum number of the field within the selection.

Re: Find max value in a field.

MatthewLeonard — Fri, 22 Apr 2022 14:42:01 GMT

@Anonymous User This worked perfectly, thanks!