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)

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 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 over 280 people weekly. [ Example Job Description ]        Auditing :        Something doesn't work on your page or in your app. I can find it, or you can lose business. [ Here ] [ Example Job Description ]   I really enjoy testing apps and webpage concepts! I have an iPhone and Android phones ready. Technical: Still as-needed, always remote, contract, or temporary. IT Operations Tech [ Example Job Description ]     Hardware and SaaS support.     Cisco routing and switching (Networking). CCNA, A+, Sec+, Azure certified WORKING ON: Junos

Portfolio of UX/Product Feedback [Vol. 1]

I browse websites and apps, while making note of things I find frustrating for end users. You have probably been linked here from a form or my resume. If you have any questions about what I'm looking for in a role, click here .   This post is not to shame, but to point out errors and hopefully make my talent for finding and documenting such mistakes clear to someone hiring. Contents: Instances where I offer constructive feedback on someone's website, logo, or app. Actions that were taken by the developers or artists.  I'm glad you want your webpages to be the best they can be with my help; If you need your sites audited, e-mail me . Latest Update -  November 20th, 2020.   Vol. 2 is here .

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.