I have dataframe with courses and the number of hours the course take for a year. I also have another dataframe with teachers which can have 4 different profiles : "Perm", "Vac", "temp", "prom".
The amount of hours teach a year (the sum of all hours) must be given by at least 90% of ("Perm" + "Vac" + temp), 50% of ("Vac"+ "temp") and 20% of "temp".
Is it possible to have combinations of which profile should teach which course to match the requirements ?
Course Hours combination1 combination2
course1 200 ? ?
course2 50 ? ?
course3 150 ? ?
course4 220 ? ?
course5 25 ? ?