I'm new to python and learning the hard way. I have a task that is quite tedious and i hope you can help me.
I am organising an event for 220 people. Throughout the day there are 4 activities. The activities are performed in teams of 10 people (22 teams). The goal is that for every activity the teams change. So, i want to rearrange the team composition 4 times. This is to make sure people get to know as many colleagues as possible.
In excel, i have a list of 220 names in column A. I assigned a number to each name (1 -220) in column B. I imported the modules random and pandas. My first step was to import the excel file, turn the column B with Numbers into a list and shuffled them.
After that step i'm lost. From the shuffles list i want to create the 22 teams. After the first draw, i want to shuffle the list again and create again 22 teams but with the condition that there are no people from the first team composition together in the second composition. In Total this process repeats itself for four times.
Ideally i would like to export the resulta back to excel.
Hope that someone can help me!
Again, i'm learning so please share the thought process:).
Thank you for your time.
Kind regards,
Bas
Aucun commentaire:
Enregistrer un commentaire