A solution to last week's challenge can be found here.
Source: Steelers.com
The 2020 NFL draft will occur later this week. Yay American Football! Let's look back at data from previous drafts to find out which teams used their draft picks most efficiently.
Each year the NFL holds a draft where aspiring collegiate players are selected to play for an NFL team. The draft takes place over 7 rounds with each team selecting players based on their performance in the previous season. Selections, also known as picks, can be traded amongst teams, resulting in some teams not selecting within given rounds and others having multiple picks.
In general, the earlier a pick is made in the draft the more valuable it is (i.e., you are likely to get a more valuable player with the first pick than the 10th pick). Sometimes, a highly valued prospect does not pan out and the valuable draft pick is wasted.
For this week’s challenge, create a list of the top three teams with the highest draft efficiency for each year of the data.