Joining Tables with Recent Date for Each Row Then Weighted Averaging

How to Aggregate DataFrames in Python Pandas Using Groupby and Dot Methods