Posted on

Updated Greatest Films of All Time for 2017

A new edition of 1001 Movies You Must See Before You Die was published in October 2017, and that means a batch of new movies have been added to the “Greatest Films of All Time” movie recommendation app.

In the 7th edition of the ‘1001 Movies’ series, 22 movies released in 2015 and 2016 were added to the list in the book. (So they don’t have to change the title of the book to 1023 Movies You Must See Before You Die, 22 movies were also taken out of the book. However, for our purposes, once they’ve been recommended in any edition of the ‘1001 Movies’ series, the films stay in “Greatest Films of All Time” app forever…).

The new films added are:

  • The Look of Silence
  • Star Wars: The Force Awakens
  • The Revenant
  • Son of Saul
  • Bridge of Spies
  • The Big Short
  • Spotlight
  • Tangerine
  • Straight Outta Compton
  • Mad Max: Fury Road
  • Victoria
  • La La Land
  • Moonlight
  • Manchester by the Sea
  • Jackie
  • Toni Erdmann
  • Under the Shadow
  • 13th
  • I, Daniel Blake
  • Arrival
  • Hell or High Water
  • Jungle Book

The app below has been updated, so these films appear in recommendations. As usual, the more “greatest films” lists the movie appears on, the higher its “List of Lists Score.”

So a film that appears on all 6 of the greatest films lists –> has a List of Lists Score of 6 –> and therefore must be one of the best of the best movies of all time.

A film that appears on 1 greatest films list –> has a List of Lists Score of 1 –> and therefore should still be a pretty safe bet.


Posted on

The greatest films of all time- a list compiled from multiple sources

This web app and open dataset I made for movie fans compiles several ‘greatest films’ lists to find the greatest of the great, and the analysis reveals seven films to be the best of the best.

Here's a Movie Recommender visualization and interface for the data hosted on Tableau Public:

The Problem

There’s nothing worse than sitting through a bad movie.

(OK, there are many things that are worse, but it’s still a bummer.)

So I always check reviews, recommendations, and ratings before committing to a film. If it doesn’t pass a certain threshold on a few of my trusted sources, I don’t watch it.

I want to be generally familiar with the history of film, and I want to see the movies that many other informed folks agree are worth seeing. I’m a sucker for a good story.

Some films influenced the culture in big ways and changed the art of filmmaking. I’d like to see as many of those movies as I can.

The Solution

To provide myself with a reliable movies ideas, I have been collecting lists of “The Greatest Films of All Time.” I have lists created by film critics, film industry leaders, and screenwriters, and I decided to put them all together in one giant spreadsheet. The complete dataset I compiled is posted here as a CSV.

I will be using it to navigate movie choices, and since there are 1,212 titles on the master list, it’s gonna to be a multi-year journey. The source lists are “greatest films” publications from the American Film Institute, the Writer’s Guild of America, The Sight & Sound Top 50, The Guardian, and 1001 Movies to See Before You Die.

I will be moving through the master list watching the films that many film experts, critics, and screenwriters agree are the best movies ever made.

What Movies Are On All ‘Greatest Films’ Lists?

Using Python in a Jupyter Notebook, I imported the csv as as a pandas dataframe and performed a basic query to find which movies appear on every list.

There are 7 films that appear on every list and they are: Citizen Kane, The Searchers, Some Like It Hot, Psycho, The Godfather: Part I, The Godfather: Part II, and Apocalypse Now.

The 7 films that appeared on every list

I’ve seen all those films, so I used another query to find which movies appear on 6 of the 7 lists. (I dropped the Sight & Sound Top 50 list.)

The movies on 6 out of 7 lists were: Gone With the Wind, The Wizard of Oz, Casablanca, Double Indemnity, North by Northwest, The Apartment, Dr. Strangelove, The Graduate, Butch Cassidy and the Sundance Kid, The Wild Bunch, Chinatown, Annie Hall, Star Wars, Raiders of the Lost Ark, E.T. The Extra Terrestrial, Goodfellas, and Pulp Fiction.

North by Northwest (1959) directed by Alfred Hitchcock

I’m going to start this hero’s journey through cinema history with North by Northwest. It’s the oldest movie that I haven’t seen yet that appears on 6 out of 7 of the greatest films of all time lists.

What sources do you use for picking the next movie you see? Rotten Tomatoes Percent Fresh score, IMDB star rating, or a list you keep around? How many of the top 7 have you seen?