Loop over data in column 1 from dataframe_1 & assign to rows of a different dataframe_2 in a new column, with col 2 on dataframe_1 showing the limit

I have the below 2 dataframes Dataframe_1 Salesguy limit A 10 B 11 C 0 D 14 E 6 There is another dataframe2, which contains some shop details with 10 columns and say 1000 rows. I n