Fullført

NBA Compiler using R

Take data from an excel spreadsheet, manipulate the data to show all possible combinations of team of 6 years with the following criteria.

Combined salary must be greater the 25,000 but less than 50,000

There must be 1 QB, 1-2 RB, 1-2 WR and a total of 6 players

There can only be one CPT, all others are FLEX (Position.1)

Each 6 team roster can not have the same team member IE Chris Carson cant be both a CPT and FLEX position on the same team.

There must be at least one player from each team

I need all team combinations output to a csv/excel file in the following format, one team/line with the following headers on the top line.

CPTPosition1(CPT first to the left), NAME, ID, POSITION, DEPTH, TEAMABB, FLEX1 SAME INFO, FLEX2 SAME INFO, TEAM TOTAL POINTS, TEAM TOTAL SALARY

Line 2 would have the second team

I expect the code to have clear explanations the purpose of each line in case I need to modify/debug it in the future. Thank you

This is actually an NFL Compiler. Minor point.

But I did want to correct a typo. From the first line, "team of 6 years" should be "team of 6 members"
Also, There must be 1 QB, 1-2 RB, 1-2 WR, 3-4 RB+WR, and 6 players total. Thank you.

Ferdigheter: Databehandling, R programmeringspråk

Se mer: r studio, r install package, r download, r package makefile, r package tutorial, compile r code to executable, r packages, r compiler package, update using csv file, import csv file sql 2005 using wizard, read csv file using ksh, read csv file using python script, vlc player output modules, read csv file using adonet, using sorenson squeeze custom flash player, compiler using lex, design simple compiler using java, pascal compiler using, write compiler using visual studio, introduction to scientific programming and simulation using r

Om arbeidsgiveren:
( 4 omtaler ) Phoenix, United States

Prosjekt-ID: #18162348

Tildelt til:

mohel10

Hello there, I have read your project description and I can your team combinations output to a csv/excel file in the format you want and satisfying those conditions. Please send a private message so we can discuss Mer

$77 USD på 3 dager
(7 omtaler)
2.7

3 frilansere byr i snitt $151 for denne jobben

BHARATBEURA

Hello, I am an Excel Expert. I am efficient in Microsoft office tools & also have experience in sorting data, categorizing items, removing duplicates, working with functions or formulas, comparing sheets for unique da Mer

$222 USD på 3 dager
(6 Omtaler)
3.9
BestPartner4You

Hi,there. I am very interested in your project - 'NBA Compiler using R'. I've already done this kind of project before. I'm a professional programmer with 12 years of experience. If you award me, I'll implement all of Mer

$155 USD på 1 dag
(0 Omtaler)
0.0