Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #442: Examining the NFL's Shift from Run to Pass

AYXAcademy
Alteryx
Alteryx

Maveryx_WC_Banner.png

Hello, Community!

 

A solution to last week’s challenge can be found here.

 

This challenge was created by Desmond Turner. Thanks, @Desmond , for submitting your idea for this Weekly Challenge!

 

With the US football season now underway, it is the perfect time to dive into some football data. Over the years, the running back position in the National Football League (NFL) has seen a decline in value, driven by the league's shift towards a pass-heavy game. But does the data back this up? Use the provided dataset covering all plays from 2008 to 2019 to examine how the balance between running and passing has shifted over time.

 

Your challenge is to complete the following tasks:

  1. Calculate the total yards gained from run and pass plays each year.
  2. Determine the percentage of total yards gained attributed to running plays.
  3. Identify the top three teams that have leaned most heavily on the running game throughout this period.

 

Good luck, and happy football season!

 

Need a refresher? Review the following lessons in Academy to gear up.

 

Source: https://www.kaggle.com/datasets/maxhorowitz/nflplaybyplay2009to2016?select=NFL+Play+by+Play+2009-201...

 

Alteryx Academy

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
image.png
Bobbyt23
12 - Quasar

Fun challenge.

Spoiler
Challenge 442.jpg

 giphy

Pilsner
10 - Fireball

My solution:

Spoiler
442.png

Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
shawn_jacob32
6 - Meteoroid
Spoiler
Screenshot 2024-09-16 095347.png

alacoume
9 - Comet

My solution:

Spoiler
Challenge_442.jpg
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
W442.jpg
fmilliren
8 - Asteroid
Spoiler
Challenge_442_solution_image.jpg
Flo_P
9 - Comet

My solution

Spoiler
image.png