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 ) )

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 ?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Find max value in a field.

DevinUnderwood2

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

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"escroads"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'RecID'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> str<SPAN class="punctuation token">(</SPAN>max<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Encuentra más publicaciones etiquetadas con

Accepted answers

DanPatterson_Retired

field_vals <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1000</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">100</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">100</SPAN><SPAN class="punctuation token">]</SPAN>

search_cursor <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>row_ <SPAN class="keyword token">for</SPAN> row_ <SPAN class="keyword token">in</SPAN> field_vals<SPAN class="punctuation token">]</SPAN>

max<SPAN class="punctuation token">(</SPAN>search_cursor<SPAN class="punctuation token">)</SPAN>
Out<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1000</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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

or this way.

big_num <SPAN class="operator token">=</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1e200</SPAN>

<SPAN class="keyword token">for</SPAN> row_ <SPAN class="keyword token">in</SPAN> field_vals<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{} bigger than {}?"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row_<SPAN class="punctuation token">,</SPAN> big_num<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
<SPAN class="number token">1</SPAN> bigger than <SPAN class="operator token">-</SPAN><SPAN class="number token">1e</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">200</SPAN>?
<SPAN class="number token">1000</SPAN> bigger than <SPAN class="operator token">-</SPAN><SPAN class="number token">1e</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">200</SPAN>?
<SPAN class="number token">10</SPAN> bigger than <SPAN class="operator token">-</SPAN><SPAN class="number token">1e</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">200</SPAN>?
<SPAN class="number token">100</SPAN> bigger than <SPAN class="operator token">-</SPAN><SPAN class="number token">1e</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">200</SPAN>?
<SPAN class="number token">100</SPAN> bigger than <SPAN class="operator token">-</SPAN><SPAN class="number token">1e</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">200</SPAN>?
‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

or do something as you go along

<SPAN class="keyword token">for</SPAN> row_ <SPAN class="keyword token">in</SPAN> field_vals<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{} bigger than {}?"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row_<SPAN class="punctuation token">,</SPAN> row_<SPAN class="operator token">*</SPAN><SPAN class="number token">20</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
<SPAN class="number token">1</SPAN> bigger than <SPAN class="number token">20</SPAN>?
<SPAN class="number token">1000</SPAN> bigger than <SPAN class="number token">20000</SPAN>?
<SPAN class="number token">10</SPAN> bigger than <SPAN class="number token">200</SPAN>?
<SPAN class="number token">100</SPAN> bigger than <SPAN class="number token">2000</SPAN>?
<SPAN class="number token">100</SPAN> bigger than <SPAN class="number token">2000</SPAN>?<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

Anonymous User

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.

DevinUnderwood2

Invaluable advice I will look into this more.

Thanks.

JoshuaBixby

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

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"escroads"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'RecID'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> max<SPAN class="punctuation token">(</SPAN>cursor<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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.

DanPatterson_Retired

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...

DevinUnderwood2

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,)

DanPatterson_Retired

field_vals <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1000</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">100</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">100</SPAN><SPAN class="punctuation token">]</SPAN>

search_cursor <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>row_ <SPAN class="keyword token">for</SPAN> row_ <SPAN class="keyword token">in</SPAN> field_vals<SPAN class="punctuation token">]</SPAN>

max<SPAN class="punctuation token">(</SPAN>search_cursor<SPAN class="punctuation token">)</SPAN>
Out<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1000</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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

or this way.

big_num <SPAN class="operator token">=</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1e200</SPAN>

<SPAN class="keyword token">for</SPAN> row_ <SPAN class="keyword token">in</SPAN> field_vals<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{} bigger than {}?"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row_<SPAN class="punctuation token">,</SPAN> big_num<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
<SPAN class="number token">1</SPAN> bigger than <SPAN class="operator token">-</SPAN><SPAN class="number token">1e</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">200</SPAN>?
<SPAN class="number token">1000</SPAN> bigger than <SPAN class="operator token">-</SPAN><SPAN class="number token">1e</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">200</SPAN>?
<SPAN class="number token">10</SPAN> bigger than <SPAN class="operator token">-</SPAN><SPAN class="number token">1e</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">200</SPAN>?
<SPAN class="number token">100</SPAN> bigger than <SPAN class="operator token">-</SPAN><SPAN class="number token">1e</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">200</SPAN>?
<SPAN class="number token">100</SPAN> bigger than <SPAN class="operator token">-</SPAN><SPAN class="number token">1e</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">200</SPAN>?
‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

or do something as you go along

<SPAN class="keyword token">for</SPAN> row_ <SPAN class="keyword token">in</SPAN> field_vals<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{} bigger than {}?"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row_<SPAN class="punctuation token">,</SPAN> row_<SPAN class="operator token">*</SPAN><SPAN class="number token">20</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
<SPAN class="number token">1</SPAN> bigger than <SPAN class="number token">20</SPAN>?
<SPAN class="number token">1000</SPAN> bigger than <SPAN class="number token">20000</SPAN>?
<SPAN class="number token">10</SPAN> bigger than <SPAN class="number token">200</SPAN>?
<SPAN class="number token">100</SPAN> bigger than <SPAN class="number token">2000</SPAN>?
<SPAN class="number token">100</SPAN> bigger than <SPAN class="number token">2000</SPAN>?<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JamesMacKay3

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

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.