This is a script I am currently using and it works perfectly. However, I want to make some changes. This script helps me create my fantasy basketball teams. It is currently designed to create a team of 6 players composed of one Captain (CPT), and five FLEX players for a total of 6. The output is designed so the information on the Captain is always to the far left set of columns.
I want the updated script to create a team of 8 and the positions will be PG, SG, SF, PF, C, UTIL. The constraints will remain the same as the original script with the exception of the new positions. The following constraints will need to be added.
PG = or between 1 and 3
SG = or between 1 and 3
SF = or between 1 and 3
PF = or between 1 and 3
C = or between 1 and 2
PG+SG = at least 3
SF+PF = at least 3
The output will need to be organized the following order:
Far left, PG info
then PG or SG
then SF or PF
then whatever is left
Players can't repeat. For example, Michael Jordan can't occupy two positions on the same team however this script already addresses that.
I've included the script and a sample dataset. Thank you for your consideration.
13 freelancers are bidding on average $220 for this job
Hi, I'm an experienced Data Scientist and I've done all sorts of data ETL and processing in both R and Python. I can do this quickly and accurately. Let me know if you're interested via chat. thanks