Help with random distribution from given rules in different groups

I have a base file(F1) which needs to randomly distributed on the basis of another file(F2) which has rule give. for exp

this is the format of the file F2 where colm1, colm2 are joining columns from F1. colm 3 and colm 4 are variable columns, and are used to calculate final allocation, which is the maximum allocation for given agency.

The allocation needs to be done randomly , I found a node Random lable assigner but it seems very lengthy and not optimal for a big data set.