The new James Bond movie, Spectre, will be out in a few weeks. I thought it would be a very nice exercise to do a quick check on how did previous movies do in terms of overall quality (as assessed by the critics and / or the public) and box office earnings. More to the point, I wanted to do that just by writing a single R script, and scraping data off the web, just for fun.

Specifically, we want to obtain the following data for each movie:

  • Title.
  • Year.
  • Who played James?
  • What did the critics say?
  • Box office (corrected for inflation).

I am not taking the director into consideration, sorry. I might be ignorant about that specific detail, but before Sam Mendes directed Skyfall I didn't even care about who was in charge of each movie.

This is the list of resources to get data from:

Really, that's it. I was planning on doing a lot of the analysis myself, but it turns out Wikipedia already has a page with all the relevant information condensed. So no need to duplicate any efforts.

(Just for the record, my old workflow used a different Wikipedia page, then went to IMDB, then to the Federal Reserve for info on inflation. Turns out IMDB doesn't let you scrape their site, so I was trying to find some workaround when I saw a new and wonderful Wikipedia page. In any case, please note that there are undocumented and unoficial APIs, if you ever need them).

And this is the list of relevant libraries for this project:

  • RCurl: for reading HTTPS data.
  • XML: we'll need it to parse Wikipedia tables using its very handy readHTMLTable function.
  • ggplot2: for nice plots.

So, let's start by loading these libraries:

# Configure the plots

Let's proceed. This is the relevant Wikipedia page, which stores the info in two separate tables (EON or non-EON films; these last ones include Peter Seller's Casino Royale). Let's read and merge them.

doc <- getURL("")
tables <- readHTMLTable(doc, stringsAsFactors = FALSE)
# Relevant tables are 1 and 3
t1 <- tables[[1]]
t1s <- tables[[2]]
t2 <- tables[[3]]
t1 <- t1[, c(1, 2, 3, 8, 9)]
t1s <- t1s[, c(2, 4)]
t1 <- merge(t1, t1s)
t2 <- t2[, c(2, 1, 3, 7, 8, 9)]
t2 <- t2[-1, ]
tab_names <- c("Year", "Title", "Actor", "Boffice", "Budget", "RT")
names(t1) <- tab_names
names(t2) <- tab_names
# Let's keep this, just in case
t1$eon <- TRUE
t2$eon <- FALSE
bond <- rbind(t1, t2)
bond$Year <- as.numeric(bond$Year)
bond <- bond[order(bond$Year), ]

# Now let's correct some errors in the parsing, and assign proper numerical values
# where necessary
bond$Title <- gsub(x = bond$Title, pattern = ".*\\!", replacement = "")
bond$Actor <- sapply(bond$Actor, function(x) substr(x, nchar(x) / 2 + 2, nchar(x)))
bond$RT <- gsub(x = bond$RT, pattern = "%.*", replacement = "")
bond$Boffice <- as.numeric(bond$Boffice)
bond$Budget <- as.numeric(bond$Budget)
bond$RT <- as.numeric(bond$RT)

Ok, we have the data. Let's do a quick check:

table1 <- aggregate(RT ~ Actor, bond, length)
table1 <- table1[order(-table1$RT), ]
names(table1) <- c("Actor", "Number of movies")
##            Actor Number of movies
## 5    Roger Moore                7
## 6   Sean Connery                7
## 4 Pierce Brosnan                4
## 1   Daniel Craig                3
## 7 Timothy Dalton                2
## 2    David Niven                1
## 3 George Lazenby                1

Seems OK. Now we can plot how Bond movies have done both in terms of box office and critical reception. We have enough data to do it, so without further ado:

plt1 <- ggplot(bond) + 
    geom_smooth(aes(x = RT, y = Boffice), 
                method = "lm",
                color = "black") +
   geom_point(aes(x = RT, 
                  y = Boffice, 
                  color = Actor), 
              size = 6) +
    scale_color_manual(values = rainbow(7),
                       name = "Actor playing Bond") +
    ylab("Box office [M$, adjusted for inflation, values of 2005]\n") +
    xlab("\ score [%]") +
    geom_text(aes(x = RT, y = Boffice, label = Title), angle = -45,
              size = 4, hjust = 0, vjust = 2, alpha = 0.4) +
   annotate("text", label = "Source: Wikipedia (",
            x = 40, y = 900, hjust = 0.25, color = "gray")

There are several things we can comment:

  1. There is a general James Bond performance: if the movie is good (according to the critics), it will do well in the box office. Curiously, both Casino Royale installments practically sit at opposites end of the spectrum (with the comic one being terrible and the serious one being very good).

  2. The underappreciated: Timothy Dalton and George Lazenby. They did decent movies, but their box office earnings were way low.

  3. The gold mines: Skyfall, Thunderball and Goldfinger were amazing for the production company, even if they weren't better than Dr. No or From Russia with Love. After Thunderball (1967), it took another 47 years for a Bond film to surpass it at the box office (Skyfall, 2012).

(You can find the code used to generate this blog article as an .Rmd file here).