Hi,

I have a dataframe with courses ("courses") and the number of hours the course is teached for a year ("hours")

my problem is that for each course, i have to choose someone to teach it. every teacher have a profil which are either :

- Perm
- Vac
- temp

-other

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")
- 20% of "temp".

Is it possible to have combinations of which profile should teach which course to match the requirements ?

my dataframe would look like that.

Course Hours combination1 combination2

course1 200 ? ?

course2 50 ? ?

course3 150 ? ?

course4 220 ? ?

course5 25 ? ?

in that exemple, at least :

-129 hours should be teach by temp teachers

-322,5 hours should be teach by Vac or temp teachers

-580,5 hours should be teach by Temp, Vac or perm teachers

Is it possible ?