Merge combine multipule rows and compound multipule attributes

Question

I have this issue with similar to the above attachment. Multiple duplicate attributes in column A but different attributes in column B. I want to combine the duplicates of "A" in one row while retaining and merging all of the attributes in Column B. Is there a tool for this? Or can someone translate the Excel formula into a python script?

I am running Pro Standard. Thank you.

DavidPike · Answer

omg I just need to reset the cursor at the end of the for loop within the cursor! and yes I wasn't using defaultdict..

You've added a lot to my knowledge here Joshua, much appreciated.

JoshuaBixby · Answer

Regarding key value, are you using a regular dict or a defaultdict?

For your other question, try this:

with arcpy.da.SearchCursor(feature_class, fields) as cursor:
    for street_name in street_name_list:
        page_name_list = []
        for row in cursor:
            if row[0] == street_name and row[1] not in page_name_list:
                page_name_list.append(row[1])
        cur.reset()
        street_page_name_dict[street_name] = page_name_list

DavidPike · Answer

I was initially having the for loop within the cursor, but moved it out as it wasn't working as expected. Now you've explained why, this is very helpful and will save a lot of time on big processes. Big fan of that dictionary creation **steals code**.  Could you finally show how to reset the cursor if looping through a list like I was inefficiently doing? Big Thanks.

edit - I've tried to replicate the dictionary += value, but it has a key error (ie if the key doesn't exist the value is not == '')