Adding a column to a dataframe based on aggregated data in another dataframe