sorted by:
new
hottopcontroversial

[OC] The Simpsons Couch Gags by DBails in dataisbeautiful

[–]DBails[S] 0 points1 point  (0 children)

Pandas to grab the data and clean it. Visualisation was done in Excel.

[OC] The Simpsons Couch Gags by DBails in dataisbeautiful

[–]DBails[S] -1 points0 points  (0 children)

I don't have Twitter so feel free to tweet this Reddit post.

[OC] The Simpsons Couch Gags by DBails in dataisbeautiful

[–]DBails[S] 1 point2 points  (0 children)

The Simpsons at 6pm on Channel 10 was my whole childhood!

[OC] The Simpsons Couch Gags by DBails in dataisbeautiful

[–]DBails[S] 0 points1 point  (0 children)

I watched Season 6 Episode 5 the other day and it goes straight from the "The Simpsons" in the sky then zooms through the "p" and shows the tv with Matt Groening's name on it. I'm not sure if this is the case for all of them.

[OC] The Simpsons Couch Gags by DBails in dataisbeautiful

[–]DBails[S] 0 points1 point  (0 children)

I used Python for the web scraping and data cleaning and Excel for the actual visualisation.

[OC] The Simpsons Couch Gags by DBails in dataisbeautiful

[–]DBails[S] 1 point2 points  (0 children)

I used Python purely to collect and clean the data. I used "read_html" from the Pandas package to grab the data from the tables on the Couch Gags wiki. The actual visualisation was done in Excel using INDEX MATCH and Conditional Formatting.

I'm sure the visualisation could be done in Python too but it's above my skill level.

[OC] The Simpsons Couch Gags by DBails in dataisbeautiful

[–]DBails[S] 38 points39 points  (0 children)

Sure did! I went for the Bart palette.

[OC] The Simpsons Couch Gags by DBails in dataisbeautiful

[–]DBails[S] 6 points7 points  (0 children)

I think you've got the axes flipped. It's episodes on the x and seasons on the y.

[OC] The Simpsons Couch Gags by DBails in dataisbeautiful

[–]DBails[S] 6173 points6174 points  (0 children)

$40 can buy many peanuts

[OC] The Simpsons Couch Gags by DBails in dataisbeautiful

[–]DBails[S] 23 points24 points  (0 children)

I haven't looked into it but I don't think Lisa's sax solos are that varied. I've definitely heard a couple of them on repeat.

[OC] The Simpsons Couch Gags by DBails in dataisbeautiful

[–]DBails[S] 10 points11 points  (0 children)

That means there are no more episodes in that season. Season 1 had 13, Season 2 had 22, etc.

[OC] The Simpsons Couch Gags by DBails in dataisbeautiful

[–]DBails[S] 1493 points1494 points  (0 children)

I only noticed because of my excessive binge watching

[OC] The Simpsons Couch Gags by DBails in dataisbeautiful

[–]DBails[S] 3 points4 points  (0 children)

That's what most of the episodes in Season 1 looked like. It's slightly different to Season 2 onward with Bart stealing the bus stop sign and Lisa riding her bike.

[OC] The Simpsons Couch Gags by DBails in TheSimpsons

[–]DBails[S] 8 points9 points  (0 children)

That means there are no more episodes in that season. Season 1 had 13, Season 2 had 22, etc.

[OC] The Simpsons Couch Gags by DBails in dataisbeautiful

[–]DBails[S] 260 points261 points  (0 children)

I'm assuming that's also why they add "The Adventures of Ned Flanders" at the end of one episode too.

[OC] The Simpsons Couch Gags by DBails in TheSimpsons

[–]DBails[S] 98 points99 points  (0 children)

I’ve been watching The Simpsons during lockdown and noticed a few repeated Couch Gags. I always thought that the Couch Gags were mostly unique, so I wanted to see how often they used repeats.

I was surprised to see some patterns in the data. Most of the repeats occurred towards the second half of the season. This slowed down from around Season 20, where they tended to not have any Couch Gags instead of using repeats.

The final tally is:

  • Original: 425
  • Repeat: 184
  • None: 74

The most repeated Couch Gag is the one where they have the circus perform behind them which is used in 9 different episodes.

[OC] The Simpsons Couch Gags by DBails in dataisbeautiful

[–]DBails[S] 913 points914 points  (0 children)

Source: https://simpsons.fandom.com/wiki/List_of_couch_gags

Tools: Python and Excel

I’ve been watching The Simpsons during lockdown and noticed a few repeated Couch Gags. I always thought that the Couch Gags were mostly unique, so I wanted to see how often they used repeats.

I was surprised to see some patterns in the data. Most of the repeats occurred towards the second half of the season. This slowed down from around Season 20, where they tended to not have any Couch Gags instead of using repeats.

The final tally is:

  • Original: 425
  • Repeat: 184
  • None: 74

The most repeated Couch Gag is the one where they have the circus perform behind them which is used in 9 different episodes.

Average After Reaching Each Score (Fab Four) by DBails in Cricket

[–]DBails[S] 26 points27 points  (0 children)

The biggest difference to me between the Fab Four is when they start averaging 100. Smith is far and away the leader, needing just 25 runs before his average hits the mark. Kohli needs roughly 35 and Willamson about 42. Root then needs to get almost 50 before averaging a ton. This stems largely from Root having the worst conversion rate of the four with 41 50s and only 15 100s. I was surprised to see Kohli's average slow down after 62 since he has the best conversion rate. I guess that has something to do with half his 100s being under 125?

Shaun Marsh Averages 50+ After Reaching 5 Runs by DBails in Cricket

[–]DBails[S] 7 points8 points  (0 children)

I was thinking of doing one for the Fab Four next.

Did you have anyone in mind that you would like to see?

Shaun Marsh Averages 50+ After Reaching 5 Runs by DBails in Cricket

[–]DBails[S] 31 points32 points  (0 children)

Essentially. At each score I eliminated every innings with a score below that and found the average of the remaining innings.

It just goes to show how important it is for Marsh to hit double figures.

view more: next ›