topic Cumulative count in Python Questions https://community.esri.com/t5/python-questions/cumulative-count/m-p/726198#M56293 <HTML><HEAD></HEAD><BODY><P>I'm trying to create a cumulative count of IDs by Date in a field called Count.</P><P></P><P>For example, with these 3 IDs highlighted below, the results of Count would be 1, 2 and 3.</P><P><IMG __jive_id="415117" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/415117_pastedImage_2.png" /></P><P></P><P>Any help would be greatly appreciated.</P><P></P><P>*edit - in the screenshot above the IDs have been sorted to be grouped.</P></BODY></HTML> Wed, 25 Jul 2018 14:46:11 GMT deleted-user-qpvAI3Fo0MKR 2018-07-25T14:46:11Z Cumulative count https://community.esri.com/t5/python-questions/cumulative-count/m-p/726198#M56293 <HTML><HEAD></HEAD><BODY><P>I'm trying to create a cumulative count of IDs by Date in a field called Count.</P><P></P><P>For example, with these 3 IDs highlighted below, the results of Count would be 1, 2 and 3.</P><P><IMG __jive_id="415117" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/415117_pastedImage_2.png" /></P><P></P><P>Any help would be greatly appreciated.</P><P></P><P>*edit - in the screenshot above the IDs have been sorted to be grouped.</P></BODY></HTML> Wed, 25 Jul 2018 14:46:11 GMT https://community.esri.com/t5/python-questions/cumulative-count/m-p/726198#M56293 deleted-user-qpvAI3Fo0MKR 2018-07-25T14:46:11Z Re: Cumulative count https://community.esri.com/t5/python-questions/cumulative-count/m-p/726199#M56294 <HTML><HEAD></HEAD><BODY><P>See here for the logic behind tracking the count in a dictionary:&nbsp;<A _jive_internal="true" class="link-titled" href="https://community.esri.com/message/596160?commentID=596160#comment-596160" title="https://community.esri.com/message/596160?commentID=596160#comment-596160">https://community.esri.com/message/596160?commentID=596160#comment-596160</A>&nbsp;</P><P></P><P>And here for Update Cursor (ideally, your data is in a database and you can use ORDER_BY):&nbsp;<A class="link-titled" href="http://pro.arcgis.com/en/pro-app/arcpy/data-access/updatecursor-class.htm" title="http://pro.arcgis.com/en/pro-app/arcpy/data-access/updatecursor-class.htm">UpdateCursor—Data Access module | ArcGIS Desktop</A>&nbsp;</P></BODY></HTML> Wed, 25 Jul 2018 17:25:45 GMT https://community.esri.com/t5/python-questions/cumulative-count/m-p/726199#M56294 DarrenWiens2 2018-07-25T17:25:45Z Re: Cumulative count https://community.esri.com/t5/python-questions/cumulative-count/m-p/726200#M56295 <HTML><HEAD></HEAD><BODY><P>Thanks you <A href="https://community.esri.com/migrated-users/19932">Darren Wiens</A>‌ for providing the logic! I'm using the Sort tool to bring the .csv into scratch.gdb ready to be populated with the counts using your logic.</P><P>Many thanks again!</P></BODY></HTML> Wed, 25 Jul 2018 18:47:47 GMT https://community.esri.com/t5/python-questions/cumulative-count/m-p/726200#M56295 deleted-user-qpvAI3Fo0MKR 2018-07-25T18:47:47Z