Challenge #394: Fantasy Football Team
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A solution to last week’s challenge can be found here.
This challenge is the final selection for the Weekly Challenge User Group October Takeover event, and it was contributed by Talia Sanders (@tsand22), a member of the Indianapolis User Group. We extend our gratitude to Talia for your valuable contribution, and we are excited for everyone to dive into this challenge!
In this challenge, you are the manager of a Fantasy Football team, tasked with making draft picks before your league starts. Your dataset includes details on the first-round draft order, the total number of teams in the league, and players' overall rankings; however, the draft extends beyond a single round.
For this challenge, you must complete three tasks:
1. Build a workflow that snakes the draft order so that Round 1 starts with Team 1 and ends with Team 6, then Round 2 starts with Team 6 and ends with Team 1. This alternating pattern continues for five more rounds, unfolding as follows:
- Round 1: Team 1 to Team 6
- Round 2: Team 6 to Team 1
- Round 3: Team 1 to Team 6
- Round 4: Team 6 to Team 1
- Round 5: Team 1 to Team 6
2. Identify the top 6 players for each listed position. These positions include kicker, running back, quarterback, tight end, and wide receiver.
3. Determine the draft order for each round and players selected, including team and position.
Note: Assume that every team manager in the league has agreed to select players for the same position in each round. For example, everyone will pick a kicker in Round 1. By the end of Round 5, each team should have one player for each position. Also assume that the draft picks will go in order of the players’ rankings.
Source: https://www.fantasypros.com/nfl/rankings/consensus-cheatsheets.php
Challenge Update on October 25th: The authorship for this challenge has been corrected today, and it is now accurately credited to the rightful author. We sincerely apologize for any prior confusion.
- Labels:
- Basic
- Core
- Data Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Fun challenge, and I'm excited to see how others provide a more efficient way of solving this!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This challenge went better than my current fantasy football league! jahmyr gibbs needs to deliver soon!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Went for some Generate Rows fun for this one just to see if it worked
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator