Challenge #358: Goodbye, Michael! (Part 1)

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

challenge_358_start_file.yxzp

challege_358_solution.yxzp

Join

Intermediate

Data Preparation

Core

Transform

Accepted answers

All comments

ahsanaali

The input file seems to be missing.

RWvanLeeuwen

Hi @atcodedog05,

Please share the .\the-office_lines-v4.yxdb file with us here. Thanks in advance

Roland

RWvanLeeuwen

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)

358 RWvL - csv to yxdb.png

The-Office-Lines-V4.yxdb

mmontgomery

Had to download the file from the kaggle site. Got slightly different numbers than the output file.

Spoiler

c_358.yxzp

RWvanLeeuwen

Got it!

Here's my take

Spoiler

challenge_358_start_file - RWvL.yxmd

WesCannon

Downloaded the file from the Kaggle site (had to change the field length). Here is my solution....

Spoiler

challenge_358_WC.yxmd

ahsanaali

Spoiler

Solution is based on downloaded file from Kaggle. Results are different compared to the one provided.

challenge_358_Solution_AAA.yxmd

RolandSchubert

Spoiler

challenge_358_solution_rsc.yxmd

atcodedog05

Hi @ahsanaali, @RWvanLeeuwen, @mmontgomery , @WesCannon

The starter file seems to have been updated. You can recheck the file now.

Kenda

Spoiler

As with others, I got a slightly different output with the given input file

challenge_358_ks.yxzp

Flo_P

Spoiler

Like some, differences to the output. Unlike some, correct word count! (I think)

challenge_358_solved_FPER.yxzp

benjimoser

My Solution

Spoiler

challenge_358_Benji.yxzp

Luke_C

Spoiler

challenge_358_start_file.yxmd

DataNath

My solution to #358.

Spoiler

Challenge 358 completed.yxmd

OllieClarke

My solution (same results)

Spoiler

Challenge 358 OC Solution.yxzp

FinnCharlton

Spoiler

challenge_358_complete.yxmd

binu_acs

Spoiler

challenge_358_solution_BV.yxmd

acarter881

Here's my solution. This one seems to be imprecise by design. I matched all outputs except for words, but I think my number of words makes more sense.

Spoiler

challenge_358_start_file.yxmd

braveraj

Can't quite get the word count to match but it's close.

Spoiler

challenge_358_office_michael_scott.yxmd

ggruccioAYX

Sometimes I forget to post under my old account to get credit!

Shelbey

Spoiler

challenge_358_solution.yxzp

anthonyw

Challenge Completed! My results are a bit different from the Output. Wondering if anyone had the same results

challenge_358_start_file_Completed.yxmd

Clifford_Coon

My solution. Straight through processing (one line) and minimal tools.

Spoiler

challenge_358_solution_ccc.yxmd

ggruccio

Fun Office challenge - not as straightforward as I initially thought!

Spoiler

challenge_358_gg_finish.yxzp

almeera

Caroi42

Mine was a bit different - I did some data cleaning to look for spelling variations for my totals for word and line were higher.

Spoiler

challenge_358_Caro.yxmd

ed_hayter

Spoiler

challenge_358_flow.yxmd

TurboToad

Fun challenge!

Spoiler

TT_challenge_358_solution_file.yxmd

LHolmes

Some interesting lessons in data cleansing. Provided two solutions - one that matched and another that looks a little deeper.

Spoiler

Just looking at "Michael"

Looking at variations of "Michael", such as "M ichael", "Micheal", "Micahel".

challenge_358_solution_lmh.yxzp

TonyAndriani

I wasted some time looking for an elegant way to eliminate the line for "Michael's ad" since that isn't a line spoken by the character but then realized it was being included which made things a lot simpler.