Python, Count Frequency Of Occurrence For Value In Another Column

So I've been scouring stackoverflow for solutions to similar problems and keep hitting walls. I am new to python and using pandas/python for ETL so forgive me if I am not describin

Solution 1:

You can try:

df2['Total Instances'] = df2['Subscriber Key'].map(df1['Subscriber Key'].value_counts())