How to count the number of features with the same value for an attribute

[FedericoVélez]

I need a way in python to have the Count1 (in the image).

 

I have already did it using excel, but due to the client requirement it must be done either in modelbuilder or in a python scrit, i currently have the script to have the Count2, so i only need the Count1

Note: the data displayed in the image is not the actual data but a example)

[DanPatterson_Retired]

Are they always sequential? or are they randomly mixed?

This does sequential

old = ""
cnt = 0
def seq_count(val):
    global old
    global cnt
    if old == val:
        cnt += 1
        ret = cnt
    else:
        cnt = 0
        ret = cnt
    old = val
    return ret‍‍‍‍‍‍‍‍‍‍‍‍‍

[FedericoVélez]

this code is for the field calculator?

[DanPatterson_Retired]

you can use it in the field calculator... hence you can also use it as the codeblock for the Calculate field as indicated

[JoshuaBixby]

I can read your question a couple differnet ways.  What is the expected outcome for your example?  Do you want to know how many features have a Count1 value of 1, Count1 value of 2, etc... or are you interested in how many features have a total of 2 count values in Count1, 3 count values in Count3?

[FedericoVélez]

i'm interested in getting the Count1 column, which gives sequential numbers for those features with the same ProjectName.

The values are already sorted, so all the features with the same ProjectName are already as displayed in the image.

At the end i will have many features with Count1=1, Count1=2, etc. but it doesnt matter

[DanPatterson_Retired]

try my posted code then.  It can be implemented as a code block for the Calculate Field tool for use in arcpy or modelbuilder

[JoshuaBixby]

Ah, you are asking a different question entirely than what I first thought.  Besides Dan's code here, different flavors of the same question have been asked several times over the past couple years on GeoNet:  Calculating counting field , https://community.esri.com/thread/200080-is-it-possible-to-use-a-group-by-function-in-the-arcpy-upda... 

[FedericoVélez]

Tried a slight variation of the code in the link you sugested and worked perfectly thanks

[ChrisDonohue__GISP]

Like what Joshua Bixby suggested, the question can be read many ways, which complicates finding a solution.  Can you restate what you need in a different way so we can get a better understanding of what the goal is?

As for a solution, so far it is sounding like what possibly would work is a Summarize (Modelbuilder) or its Python equivalent.

Summarizing data in a table—Help | ArcGIS for Desktop   However, that is just a guess based on what most of the possible goals could be.

Chris Donohue, GISP