Numerical Aggregate of Unique Column Value by Particular Value with Multiple Groupby in Pandas DataFrames

Merging DataFrames Where the Common Column Has Repeating Values