Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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 #416: The Oscars 2024

AYXAcademy
Alteryx
Alteryx

Maveryx_WC_Banner.png

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

 

This challenge was submitted by Jifeng Qiu (@Qiu) , a dedicated member of our Community. Qiu is the first person to earn our new Weekly Challenge Contributor Badge and will also receive special swag from Academy soon. Congratulations, Qiu, and we eagerly await more challenges!

 

The Academy Awards, officially known as the Oscars, honor artistic and technical merit in the film industry. The 96th Academy Awards 2024 is scheduled for Sunday, March 10, 2024, and will recognize movies released in 2023.

 

The first dataset contains information about movies nominated for the award from 1928 to 2023. The second dataset contains information on actors and actresses who were nominated for the 2024 Oscars and their respective movies.

 

For this challenge, only focus on the winner of the actor, actress, supporting actor, or supporting actress categories.

 

Your task this week is to find:

 

  1. Actors/Actresses with eight or more nominations.
  2. Actors/Actresses who have eight more nominations than they have total awards (do not consider nominees with zero awards).
  3. Actors/Actresses who won every time they were nominated.
  4. Actors/Actresses with five or more nominations who have never won.
  5. 2024 nominees who have won before.

 

Need a refresher? Review these lessons in Academy to gear up:

 

Sources:

 

Lights, Camera, Action!

 

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

Luke_C
17 - Castor
17 - Castor

What a fun challenge, @Qiu !

 

Spoiler
image.png
Flo_P
9 - Comet

Love a quick and easy one to make Mondays more tolerable

Spoiler
image.png
Kenda
16 - Nebula
16 - Nebula
Spoiler
Interesting findings from this challenge, @Qiu!
image.png
alexnajm
17 - Castor
17 - Castor

Good one!

Spoiler
Challenge 416.png
braveraj
11 - Bolide
Spoiler
Oscar workflow.png
binuacs
21 - Polaris
Spoiler
image.png
joseph_forbidussi
7 - Meteor
Spoiler
Weekly Challenge 416_Solution_Screenshot.png

shawn_jacob32
6 - Meteoroid
Spoiler
Screenshot 2024-03-04 120642.png

DataNath
17 - Castor
17 - Castor

My solution to #416.

 

Spoiler
416.png