Development of a simple group allocation tool in python

The task is to create a simple tool in Python which helps university courses to allocate people into teams for group projects. The decision should be based on a simple personality test which we have designed using Google Survey. The Google Survey contains 5 questions with 4 answers each. Every answer option is linked to one of four personality categories (Collaborator, Leader, Analytical and Creative). Every participant will be assigned the personality type that fits the majority of his responses, e.g. a student selects 3 responses that are assigned to the “Collaborator” personality and 2 that are assigned to “Leader”, his overall personality according to our test would then be the “Collaborator”. All responses will be collected in a Google Spreadsheet. Based on the survey output explained above, we want to form groups of maximum 6 people. Personality types need to be spread as evenly as possible across all groups. The tool should access the Google Spreadsheet via an API. If the number of participants is not divisible by 6, smaller groups can be formed. But: Groups can only have a minimum of 4 and a maximum of 6 people. Example: 45 people need to be allocated. There must be 6 groups of 6 people each. The remaining 9 people have to be allocated in 2 groups with 5 and 4 members each, so that there are always at least 4 people. The user interface should only contain a button which says “Allocate groups”. After clicking this button, the tool should create a pdf with the allocated groups. The pdf should contain three columns: first name, last name, allocated group number. Our maximum budget for this project is 45$ and a project length of 48 hours. Therefore we can’t consider offers above this amount and time.