Python function to simulate perfect grouped job assignment
Budget: €8 – €30 EUR
I have a dataframe which consist of all jobs which have been assigned to an employee for delivery.
I want to create a python function which takes this input and simulates an output of the number of jobs that could have been grouped together based on the delivery location and before an employee has left for delivery. The delivery location between 2 grouped jobs should not be more than 800 m and the maximum jobs an employee can handle is 3. An employee can only take another job provided the other job is created before he left and the delivery location is within 800m between each other. I have attached the csv file of the input and an image of the expected simulation output
I want to create a python function which takes this input and simulates an output of the number of jobs that could have been grouped together based on the delivery location and before an employee has left for delivery. The delivery location between 2 grouped jobs should not be more than 800 m and the maximum jobs an employee can handle is 3. An employee can only take another job provided the other job is created before he left and the delivery location is within 800m between each other. I have attached the csv file of the input and an image of the expected simulation output