Home - Owaistiwana/Rowan GitHub Wiki

Welcome to the Rowan wiki!

The Golden Girls Drinking Game: A Tidytext Analysis
Feb 5, 2018 Television, Pop Culture, Data Viz Golden Girls, R
I had set out to build a Twitter bot that would come up with new Golden Girls quotes… I failed. I decided that in order to build a better bot, I should have a better understanding of the input text: Golden Girls episode transcripts. The obvious choice was a tidytext analysis of the scripts using Julia Silge’s package and paradigm.

This approach has been used on many texts by now, from Pride and Prejudice to Donald Trump’s tweets. For this post, I am going to jump off the rails a bit and do a tidytext analysis for… The Golden Girls drinking game.1

The Rules
There are many versions of the game across the internet. For this analysis, I’m going to use these rules: Drink each time…

The ladies eat cheesecake
Rose tells a story about St. Olaf
Blanche (or anyone) is called a slut
Sophia begins a story “Picture it:”
Dorothy exclaims “38 years” or says “It’s me, Stan”
The Goal
In this age of binge-watching and binge-drinking, I’m setting out to the find (but not endorse) the solution to a simple question: Which season of Golden Girls should you watch to maximize drink consumption?

The Data
I scraped the transcripts of all 169 Golden Girls episodes from Springfield! Springfield! using rvest. This source contains every spoken word in each episode. However, these transcripts are missing stage directions and the names of the people speaking each line. This missing data makes analyzing the text and searching for rule triggers a bit more challenging.

The Game
Cheesecake trigger
Without stage directions in the scripts, I can’t directly see if the women are eating cheesecake. Instead, I infer a lower-bound estimate using the dialogue. To do this I use two rules: (1) if the women are talking about cheesecake, they are eating it and (2) if they mention cheesecake again within 20 lines of dialogue, they are still eating that same cheesecake.
With this chart2, I’ve already run into a problem. In my extensive research, I came across a piece of trivia claiming over 100 cheesecakes were eaten over the course of the series.3 Searching the transcipts, I only count 32 cheesecakes. I tried to relax the text parsing to include any mention of the word “cake”, but after reviewing the output, these references include exclusively non-cheesecakes.4 For now, I assume the missing cheesecakes are uniformly distributed across the seasons and will not affect the results.5

The Golden Girls
Calculating the drink triggers for each of the remaining rules follows a similar methodology, with just a few changes, explained below.

Rose & St. Olaf
For Rose’s stories about St. Olaf, I use the same strategy as the cheesecake trigger. If St. Olaf is referenced in the transcript, I assume Rose is involved in the story. Mentions of St. Olaf within 20 lines of each other are the same story and won’t be counted.

St. Olaf was not a huge part of Rose’s character until the middle seasons.6 Her first long (>10 lines) story about St. Olaf was in episode 4 of season 2.

Blanche & the S* word7
The 80’s were a different time and, well… the Golden Girls really like to refer to each other (but mostly Blanche) as sluts. In fact, the word “slut” is spoken 54 times throughout the series, which is exactly the same number of times as “cheesecake”. That’s… ridiculous.8
In the spirit of equal opportunity, the rule in this game is to count drinks when anyone is called a slut.

Sophia & Picture It: Sicily…
To find instances of Sophia beginning a story with “Picture it”, I split the transcripts into bigrams (pairs of words) rather than words, and then apply a filter for all instances of “picture it.”

Sophia’s most common use of the phrase is to begin her stories about Sicily. Looking at the trigrams of the text, she also uses it for Brooklyn, Germany, Morocco, and Miami.

Dorothy & Stanley
The original rule for Dorothy was to drink each time Dorothy refers to Sophia as “Ma”. Exploratory data analysis shows that this happens 1906 distinct times over the course of the series and all game players would pass out from drink consumption within 20 minutes.9

Throughout the series, Dorothy is hung up on her sleazy ex-husband, Stan. An alternative rule I found is to drink whenever Dorothy exclaims “38 years” – the length of her marriage – or she uses the phrase “It’s me, Stan.”

Combining the rules
Putting it all together, mentions of St. Olaf drive the drink consumption in this game. There are alternative rules for the Golden Girls drinking game where each player chooses a character and only drinks when that character’s rule is triggered. In those cases… pick Rose.

The Results
You and your closest friends get together on a Saturday night to play the Golden Girls drinking game and need to pick a season to maximize consumption.

By choosing season 5, you will consume the most beverages over the course of the evening. Is this the most efficient solution?
Minute-by-minute gameplay
Watching an entire season (9+ hours) of a show is quite the commitment10 for a drinking game. Which season should you watch in order to consume drinks in the shortest time?

I start by converting the episodes in each season to a running tally of time. Each half-hour episode is approximately 22-minutes long, though 11 of the episodes were hour-long (44 minutes)11. With that, I calculate the time of each trigger for each season.

Season 5 is the way to go for steady drink consumption all night long. If you’re playing the Golden Girls drinking game with speed in mind, perhaps seasons 4 or 6 are the more logical choices – it will take 5 hours of watching season 5 before the drink count exceeds seasons 4 or 6.

With seasons 4 and 6, you get an hour at a relaxed pace before consuming up to 20 drinks in 20 minutes.

Update: An earlier version of this chart did not have the repeated references to cheesecake or St. Olaf filtered out.
The ramps in seasons 4 and 6 are both caused by Rose’s St. Olaf story lines, with a few Dorothy triggers during the season 6 ramp. Again, if you play the alternative rules and need to pick a character, choose Rose.

Let’s be honest – any game that requires watching The Golden Girls is a game worth playing, regardless of how many drinks you have. But I set out to answer a question: which season (reasonably) maximizes drink consumption? Seasons 4, 5, or 6 are the way to go.
Have you noticed the unconventional (bright and tan) plot colors? This is my attempt at a Golden Girls (wicker furniture in Miami) theme in ggplot using ggthemr. 💃🏿↩

I’m seeing this quoted by super credible sources including Fox News, Huffington Post, and Mental Floss. The closest I can find to a primary source is the IMDB trivia page. 🤷‍♀️↩

The Golden Girls enjoyed their desserts! In addition to cheesecake, they discussed wedding cake, marbled cake, chocolate cake, rum cake, birthday cake, St. Olaf friendship cake, sponge cake, Bundt cake, cupcakes, fruitcake, hotcakes, and pancakes. They also once had crab cakes. 🍰↩

This analysis will result in a handful of errors – Type I (the women discussing cheesecake they are not eating) and Type II (the women eating a cheesecake and not talking about it). My hope is that the counting errors made by inebriated game players will overshadow these methodological errors. (Type 🍷 error)↩

In episode 8 of season 1, Rose mentions being from a place called “Little Falls”.↩

Never thought I’d use this word so many times (or at all) in a data analysis. I’m not 100% comfortable with it, but in the interest of a fair literary analysis, here we are. 🙏🏼↩

Fun fact: There’s a -0.92 correlation between the frequency of the word “cheesecake” and “slut” in a given season. 💹↩

Citation needed. 🤷🏾‍♂️↩

Totally worth it. 💯↩

Without an explicit list of the longer episodes, I assign the the 11 episodes with the most lines in the transcript as the hour-long ones. ⏳↩

⚠️ **GitHub.com Fallback** ⚠️