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.


Labels:

Comments

Post a Comment

Popular posts from this blog

Making KPI Dashboards with PowerBI

 While this is the free tier, I cannot share or collaborate with others, nor can I publish content to other people's workspaces, but they will not stop me from screenshooting and recording these self-taught adventures,so! I'm doing this because I idly searched "Mattel careers" and "Information Technology", and seeing a bulletpoint saying the following: Analytical and reporting skills such as creating dashboards and establishing KPIs such as experience with PowerBI, Cognos, Tableau, and Google Data Lake/AWS is preferred And thought "Well, I've used Tableau, and I've heard about PowerBI,  even if its in-demandness is questionable , so how similar is it? And can I write about it?"  First, PowerBI (PIB) does have a downloadable, local version, but apparently Windows-only. I could download the .exe but I couldn't run it / drag it to applications on my MacBook.  Not a problem, we'll use the online SaaS version, and a dataset found here, ...
Post a Comment
Read more

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

 If you're seeing this post, I'm helping you, and you probably have LI presence: React and share this post to help me in return.   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...
Post a Comment
Read more

Create a Simple Network (Packet Tracer) + A Walkthrough

Again; I've done this, but now there's so many new things, I'm doing it again. The truly new portions were...everything on the right side of this diagram; The cloud needed a coax connector and a copper Ethernet connector. It's all easy to install, turn off the cloud (Weird), install the modules. Getting the Cable section of Connections was an unusual struggle - The other drop down menu had nothing within. It required going into the Ethernet options and setting the Provider Network to 'cable', which is the next step AFTER the drop-downs. The rest was typical DHCP and DNS setups, mainly on the Cisco server down there. The post is rather short - How about adding a video to it? Find out what A Record means - This site says 'Maps a name to an IP address', which is DNS. So it's another name for DNS? You can change them (presumably in a local context) to associate an IP address to another name.
Post a Comment
Read more