Counting in loop

Mick

Good day everybody,

I am currently working with a feature class. I have a field with each cat that could be repeated around 100 or more times. However, I have 25 different cats.

My task is to count how many times each cat appears in the field. Currently, I have a total number 40000 when I use "numbermyList = len(myList)" after my loop and only one when I use it in the loop. When I use "numbermyList = len(cat)", it gives the total number only for the first cat but not working the other cats.(If i use inside or outside of the loop)

Could you please recommend to me how to use the loop to count the number of each cat in my field?

 

Certainly, I would like to use the received number in my next loop, so I will receive something like this: 1st cat = 4000(numbermyList = len(myList)), 2sd cat 5000 and so on (numbermyList = len(myList)).

 

 

 

 

  

JohannesLindner

 

cat_names = ["cat_1", "cat_2", "cat_3", "cat_25"]
cat_numbers = []

for name in cat_names:
    sql_query = "CatName = '{}'".format(name)
    cat_rows = [c for c in arcpy.da.SearchCursor("Cat_Layer", ["CatName"], sql_query)]
    cat_numbers.append(len(cat_rows))

for name, number in zip(cat_names, cat_numbers):
    print("{} appeared {} times in Cat_Layer.".format(name, number))

#cat_1 appeared 56 times in Cat_Layer.
#...
#cat_25 appeared 572 times in Cat_Layer.