April 29, 2024, 1 a.m.

Week 3: Bad words

Unraveling numbers

A chart and some thoughts. That is all.

If you do not like to hear or see swearing, specifically the F word, then do not go any further!

At work, in our little jolly team, we have a “style guide” for GIFs posted to our chats. Meaning, we only post succession GIFs (and very occasionally The Bear). Talking to my colleague Steph over Teams about this very newsletter, I mused on what the next topic would be, and given the context of this musing, and with Succession gifs in my face, the theme became apparent.

After having a dig around, I discovered there are these files called SubRip subtitle files that are used to synch with video. The sites for these seemed ALL dodgy so it was a bit of a Hail Mary as I downloaded, and hoped to god the files were just text, but when you need to get a newsletter together, you take ALL KINDS of risks.

So this visual is not that amazing, I admit. But like most things data related, the finding, sorting, looking, exploring, cleaning etc took up 99.9% of the time I had and very late this afternoon, I got this plot done in ggplot2.

Very grateful (and amazed as always) that someone in the R community created a package to read SRT files and format them in a tidy text way (IYKYK). So thank you Francois Keck for your subtools R package. This opens up all kinds of opportunities to look at dialogue in film and television. Getting the characters who say the lines though is a bit tricky and I just didn’t have time to try and work that in. These are subtitle files, not scripts, so differentiating who is saying what is not straight forward. It would be very cool to code this chart by character and see who indeed gives the most fucks.

So apologies again if you don’t like swearing/cursing. Bt for those who enjoyed the salty language of Logan and his friends, I hope you enjoy!

Chart of timestamped instances of “fuck-based” words in Succession Episode 1, Season 4 (The Munsters).

Thanks again for subscribing, and thanks to the people who got in touch to say they liked the Sofia Copolla chart from last week. Always like feedback: good and constructive!

This newsletter was created on Gadigal Land. Just up the river from where I live, pictures and marks were made on rocks to share stories about the world with others, and they were put there tens of thousands of years ago. I want to acknowledge that this tradition of story telling and using images to communicate and pass on information is nothing new - and the Custodians of this unceded land were here, and doing it first.

You just read issue #5 of Unraveling numbers. You can also browse the full archives of this newsletter.

week_3.pdf
Download
This email brought to you by Buttondown, the easiest way to start and grow your newsletter.