Popoulate fields based on occurrences and text

Question

Trying to figure out how to populate two fields based on two fields. I need to be able to populate say F_ID3 with the number of occurrences of F_ID1 then in F_D4 add the text of the occurrences from F_ID2. Like below, note that their may be empty or nulls in the fields

Currently have this

OBJECTIDF_ID1F_ID21aa1123123452aa1123123463BB3361678914BB3361678925BB3361678936UU9832111237PP222569898PP22256988

I need this

OBJECTIDF_ID1F_ID2F_ID3F_ID41aa112312345212345, 123462aa112312346  3BB336167891367891, 67892, 378934BB336167892  5BB336167893  6UU9832111231111237PP2225698926988, 69898PP22256988

2Quiker · Answer

I wasn't getting what I needed from the code you provided but I was able to make the following work based on the code you provided. It's not as clean as yours but I am a newbie to python. Thanks. #populate F_ID3 & F_ID4 dict1 = dict() with arcpy.da.SearchCursor(fc,['F_ID1','F_ID3','F_ID2']) as cursor: for row in cursor: dict1.setdefault(row[0],[]).append(str(row[2])) with arcpy.da.UpdateCursor(fc,['F_ID1','F_ID3','F_ID4']) as cursor: for row in cursor: row[2] = ",".join(dict1[row[0]]) cursor.updateRow(row) #Populate F_ID3 with arcpy.da.UpdateCursor(fc, ["F_ID1", "F_ID3"]) as cur: cnt = Counter(row[0] for row in cur) cur.reset() for row in cur: cur.updateRow([row[0], cnt.pop(row[0], None)])‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

JoshuaBixby · Answer

Quick and dirty, haven't tested, but may work for you: import arcpy from collections import defaultdict lyr = fields = ["F_ID1", "F_ID2", "F_ID3", "F_ID4"] sql = "ORDER BY F_ID1, F_ID2, OBJECTID" d = defaultdict(list) with arcpy.da.UpdateCursor(lyr, fields, sql_clause=(None,sql)) as cur: for id1, id2, id3, id4 in cur: d[id1] += id2 cur.reset() id1, id2, id3, id4 = next(cur) cur.updateRow([id1, id2, len(d[id1]), ",".join(d[id1])]) id_prev = id1 for id1, id2, id3, id4 in cur: if id1 == id_prev: continue cur.updateRow([id1, id2, len(d[id1]), ",".join(d[id1])]) id_prev = id1 ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍