Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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
A solution to last week’s challenge can be found here.
Welcome to the F.R.I.E.N.D.S. themed weekly challenge!
In this challenge we would like to figure out which season all 5 main characters spoke the most.
The dataset contains the series transcript, which includes every line and character from the show.
Determine the episode that each character spoke the most in. For instance, Joey had significantly fewer lines in season 1.
Hint: Find everyone's top 10 episodes they spoke the most.
Data source: https://www.kaggle.com/ryanstonebraker/friends-transcript
I got a different result because of how I approached the problem.
See inside the spoiler.
Spoiler
I chose to count the words in the quotes after removing acting hints. My result has 4687 words vs. 4392 for the starting output.
