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.
To solve this week’s challenge, use Designer Desktop.
This challenge comes to us from @atcodedog05 . Thank you for your contribution.
Are you a fan of the sitcom The Office and the character Michael?
The dataset contains information about the seasons, episodes, scenes, and lines of the series.
For the first part of this challenge, we will use some of the dialogue and data to:
- Determine in how many seasons the character Michael appeared.
- Determine in how many episodes the character Michael appeared.
- Find out, based on the provided dataset, how many lines the character Michael had.
- Find out, based on the provided dataset, how many words the character Michael had.
Data Source: www.kaggle.com/datasets/nasirkhalid24/the-office-us-complete-dialoguetranscript
Hi @ahsanaali and @atcodedog05
I've downloaded the CSV and output it to yxdb (see attachment) -> I'm using this for the challenge (hoping it fits)
Had to download the file from the kaggle site. Got slightly different numbers than the output file.
Solution is based on downloaded file from Kaggle. Results are different compared to the one provided.
