Skip to main content

Using Tableau and Letterboxd To Manipulate Movie Data

 


Letterboxd is a personal database to keep track of what movies you've watched, want to watch, and their ratings 🎥

Now, we're looking at my own data. Everything goes from 2016 - 2020, even though some movies are dated for the years they were released. I am keeping the date watched and the year released in the data. I've hidden the Letterboxd URLs to the specific movie pages - It's not necessary - and my own username is not shown.

Spoiler alert: There are movies that are highly acclaimed that...I do not like! Feel free to link to this post and go "How does she like 'Valerian and The City of A Thousand Planets' more than 'Up'?"

Check out the public charts here on Tableau Public, and follow along!


Ratings breakdown:

  • 15 movies are rated 5 (perfect).
  • 25 movies are rated as 4 (Very good)
  • 33 movies are rated 3.5 (fine enough) 
  • 35 movies are rated 3
  •  24 are rated 2.5 (I've seen worse, but barely.)
  • 9 movies are rated 2 (I'd watch if I was bored. Very bored.)
  • 11 movies are rated 1.5 (Goodness me)
  • 3 movies are rated 1 
  • 1 Lone little movie is rated 0.5


Year and Quarter Watched

It's easiest to point out for 2020; I'm not sure I watched any older movies in 2020 (besides 1), so I didn't catalog them on the website.


For the curious, July is "The Personal History of David Copperfield". If 2020 had not been 2020, June would have included A24's "The Green Knight", Disney's "Soul", and Universal's "Candyman".

Q1 -Jan to (and including) March.

Q2 - April to (and including) June

Q3 - July to (and including)  September

Q4 - is October to December

I notice that does not include rewatches of movies. I know I logged a rewatch that would be in Q1 of 2020. 

If you can guess which movie it is (You get one shot at it), post on this LinkedIn post, I'll send you the code to a 5$ gift card to either Starbucks or Dunkin. Your choice!

Hint

 


Look at this graph, and in Q1. You have a 1 in 90 chance of getting it! 

Contest ended November 28th, 2020.

Average Ratings Per Year (The movie came out)

I had to adjust this a bit because the information was spread out over 120 years (The oldest movie was "A Trip To The Moon"), so I adjusted the axis to start at 1960 and go to 2021 for visual clarity. 

 
The year that had the movies with the highest ratings were 2000, with 5. However, how many movies from 2000 did I watch?

Only 1: 

 This is a pro-Wuxia house.

Yep, that'll skew it.


Amount of Movies Watched Per Quarter Over 174 Movies

This is not the Quarter they were released, but the Quarter they were watched in, no matter the year.



I expect Q4 to rise by 1, with the release of "Soul" on Disney+. If "Raya And The Last Dragon" came out as scheduled on Thanksgiving, it would have been added also.

I'm working on a bit more data manipulation - I want to learn how to sort by # of 5 ratings per watch year, or how many 3.5 ratings were in Q2 of 2019?

Don't forget about the competition and the prize 😉 Ends December 20th, 2020. Or until someone gets it.


Comments

Popular posts from this blog

What Do You Need? [AKA; List of Offered Services / My Next Role] (2020)

UPDATED 2021 I am a trusted outsourced remote consultant for your company.   I enjoy having the flexibility to take on temporary projects from time to time! I start at part-time, temp work for now. If we like each other, we can renegotiate. If anything sounds weird, out there, or unusual - Feel free to e-mail me .  3 Services Offered Technical: Cloud Technician     Azure [ See tag ] WORKING ON: Infrastructure As Code (Specifically Terraform/Azure and CloudFormation/AWS)  Support [Web: Example Job Description ] [Text : Example Description ]     I help you with adjustments in HTML, CSS, and Javascript.     When you email a business a question and they answer? That's me.   IT Operations Tech [ Example Job Description ]     Hardware and SaaS support.     Cisco routing and switching (Networking). CCNA, A+, Sec+, Azure certified WORKING ON: Junos Networking  Writing :      You want to pay me to write more of *waves hand* this blog? I am game .     I write B2C e-mails going out to o

Contactless Tech’s Role in the New Guest Experience ft. Intelity and The George

 Contactless hospitality technology is growing. You want to get away, and you'll be damned if a little thing like a deadly virus will stop you! But you still don't want to touch things. Ew. During the chat between INTELITY CEO Robert Stevenson and THE GEORGE Director of Operations Kerrie Hunter, you’ll learn how the historic boutique hotel has adapted a mobile-first guest experience in the wake of COVID-19—and how they see contactless technology affecting the future of hospitality. I don't remember how I found INTELITY (probably hoping to score a position with them), but I liked them enough to stay on the e-mail lists.  

Connecting IoT Devices to a Registration Server (Packet Tracer, Cisco)

In Packet Tracer, a demo software made by Cisco Systems. It certainly has changed a lot since 2016. It's almost an Olympic feat to even get started with it now, but it does look snazzy. This is for the new CCNA, that integrates, among other things, IoT and Automation, which I've worked on here before. Instructions here . I don't know if this is an aspect of "Let's make sure people are paying attention and not simply following blindly", or an oversight - The instructions indicate a Meraki Server, when a regular one is the working option here. I have to enable the IoT service on this server. Also, we assign the server an IPv4 address from a DHCP pool instead of giving it a static one. For something that handles our IoT business, perhaps that's safer; Getting a new IPv4 address every week or so is a minimal step against an intruder, but it is a step. There are no devices associated with this new server; In an earlier lab (not shown), I attached them to 'H