Challenge #315: The One Where Everyone Talked

[AYXAcademy]

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

[Aaron_Harter]

The One With All The Summarize Tools

Spoiler

[joelmiller66]

"Could I have used anymore tools??????"

Spoiler

[balajilolla1]

Spoiler

Solution Attached

[Kenda]

Spoiler

Might have taken a shortcut but 3 tools got me the matching output!

[patrick_digan]

Spoiler

[dYoast]

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.

[Luke_C]

Spoiler

[AkimasaKajitani]

My solution.

Spoiler

But I'm wondering this challenge tagged as the macro tag.

[ahsanaali]