KS Data 110 Unit 5 Web Scrapping
Kris Sutton
6/30/2021
For this homework Assignment I will be web scrapping the IMDB website page “Feature Film, Released between 2016-01-01 and 2016-12-31” using the “Beginner’s Guide on Web Scraping in R” tutorial.
Feature Film, Released between 2016-01-01 and 2016-12-31 https://www.imdb.com/search/title/?count=100&release_date=2016%2C2016&title_type=feature IMDb July 02, 2021
Beginner’s Guide on Web Scraping in R (using rvest) with example https://www.analyticsvidhya.com/blog/2017/03/beginners-guide-on-web-scraping-in-r-using-rvest-with-hands-on-knowledge/ Analytics Vidhya July 02, 2021 June 24, 2019
library(rvest)## Warning: package 'rvest' was built under R version 4.0.5library(dplyr)## Warning: package 'dplyr' was built under R version 4.0.5##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union##specifying url for desired website to be scraped
url <- 'https://www.imdb.com/search/title/?count=100&release_date=2016,2016&title_type=feature'
##reading the HTML code from the website
webpage <- read_html(url)#Using CSS selectors to scrape the rankings
rank_data_html <- html_nodes(webpage, '.text-primary')
#Converting the ranking data to text
rank_data <- html_text(rank_data_html)
#Let's have a look at the rankings
head(rank_data)## [1] "1." "2." "3." "4." "5." "6."str(rank_data)## chr [1:100] "1." "2." "3." "4." "5." "6." "7." "8." "9." "10." "11." "12." ...Scrapping ratings section.
#converting rankings to numerical
rank_data<-as.numeric(rank_data)
head(rank_data)## [1] 1 2 3 4 5 6str(rank_data)## num [1:100] 1 2 3 4 5 6 7 8 9 10 ...Scrapping title section.
## scrapping titles
title_data_html <- html_nodes(webpage,'.lister-item-header a')
#convert titles data to text
title_data <- html_text(title_data_html)
head(title_data)## [1] "Suicide Squad" "The Conjuring 2" "Captain Fantastic"
## [4] "Sing" "Deadpool" "Hidden Figures"str(title_data)## chr [1:100] "Suicide Squad" "The Conjuring 2" "Captain Fantastic" "Sing" ...Scrapping description section.
##scrape the description section
description_data_html <- html_nodes(webpage,'.ratings-bar+ .text-muted')
##converting description data to text
description_data <- html_text(description_data_html)
head(description_data_html, 10)## {xml_nodeset (10)}
## [1] <p class="text-muted">\nA secret government agency recruits some of the ...
## [2] <p class="text-muted">\nEd and Lorraine Warren travel to North London to ...
## [3] <p class="text-muted">\nIn the forests of the Pacific Northwest, a fathe ...
## [4] <p class="text-muted">\nIn a city of humanoid animals, a hustling theate ...
## [5] <p class="text-muted">\nA wisecracking mercenary gets experimented on an ...
## [6] <p class="text-muted">\nThe story of a team of female African-American m ...
## [7] <p class="text-muted">\nIn Ancient Polynesia, when a terrible curse incu ...
## [8] <p class="text-muted">\nThree girls are kidnapped by a man with a diagno ...
## [9] <p class="text-muted">\nSeven gunmen from a variety of backgrounds are b ...
## [10] <p class="text-muted">\nWhile on a journey of physical and spiritual hea ...Cleaning description data.
##removing '\n'
description_data<-gsub("\n","",description_data)
head(description_data)## [1] "A secret government agency recruits some of the most dangerous incarcerated super-villains to form a defensive task force. Their first mission: save the world from the apocalypse."
## [2] "Ed and Lorraine Warren travel to North London to help a single mother raising four children alone in a house plagued by a supernatural spirit."
## [3] "In the forests of the Pacific Northwest, a father devoted to raising his six kids with a rigorous physical and intellectual education is forced to leave his paradise and enter the world, challenging his idea of what it means to be a parent."
## [4] "In a city of humanoid animals, a hustling theater impresario's attempt to save his theater with a singing competition becomes grander than he anticipates even as its finalists find that their lives will never be the same."
## [5] "A wisecracking mercenary gets experimented on and becomes immortal but ugly, and sets out to track down the man who ruined his looks."
## [6] "The story of a team of female African-American mathematicians who served a vital role in NASA during the early years of the U.S. space program."Scraping runtimes
## scraping runtime
runtime_data_html <- html_nodes(webpage,'.text-muted .runtime')
## converting to text
runtime_data <- html_text(runtime_data_html)
## remove mins and convert to num
runtime_data<-gsub(" min","",runtime_data)
runtime_data<-as.numeric(runtime_data)
head(runtime_data)## [1] 123 134 118 108 108 127Scraping genre section.
##scrape genre section
genre_data_html <- html_nodes(webpage,'.genre')
##converting genre data to text
genre_data <- html_text(genre_data_html)
head(genre_data)## [1] "\nAction, Adventure, Fantasy "
## [2] "\nHorror, Mystery, Thriller "
## [3] "\nComedy, Drama "
## [4] "\nAnimation, Comedy, Family "
## [5] "\nAction, Adventure, Comedy "
## [6] "\nBiography, Drama, History "Cleaning genre data.
##removing \n
genre_data<-gsub("\n","",genre_data)
##removing spaces
genre_data<-gsub(" ","",genre_data)
## removing all but first genre
genre_data<-gsub(",.*","",genre_data)
##converting genre from text to factor
genre_data<-as.factor(genre_data)
head(genre_data)## [1] Action Horror Comedy Animation Action Biography
## Levels: Action Adventure Animation Biography Comedy Crime Drama HorrorScraping IMDB rating.
##scrape the IMDB rating section
rating_data_html <- html_nodes(webpage,'.ratings-imdb-rating strong')
##convert ratings data to text
rating_data <- html_text(rating_data_html)
head(rating_data)## [1] "5.9" "7.3" "7.9" "7.1" "8.0" "7.8"Clean IMDB rating data.
##convert ratings to numerical
rating_data<-as.numeric(rating_data)
head(rating_data)## [1] 5.9 7.3 7.9 7.1 8.0 7.8Scraping votes data.
##to scrape the votes section
votes_data_html <- html_nodes(webpage,'.sort-num_votes-visible span:nth-child(2)')
##convert votes data to text
votes_data <- html_text(votes_data_html)
head(votes_data)## [1] "622,782" "239,722" "199,906" "138,652" "928,628" "208,152"Cleaning votes data.
##remove commas
votes_data<-gsub(",","",votes_data)
##converting votes to numerical
votes_data<-as.numeric(votes_data)
head(votes_data)## [1] 622782 239722 199906 138652 928628 208152Scrape directors data.
##scrape directors section
directors_data_html <- html_nodes(webpage,'.text-muted+ p a:nth-child(1)')
##convert directors data to text
directors_data <- html_text(directors_data_html)
##convert directors data to factor
directors_data<-as.factor(directors_data)
head(directors_data)## [1] David Ayer James Wan Matt Ross Garth Jennings Tim Miller
## [6] Theodore Melfi
## 99 Levels: Alex Proyas Ana Lily Amirpour André Øvredal ... Zack SnyderScraping actors data.
##scrape actors section
actors_data_html <- html_nodes(webpage,'.lister-item-content .ghost~ a')
##convert actors data to text
actors_data <- html_text(actors_data_html)
##convert to factor
actors_data<-as.factor(actors_data)
head(actors_data)## [1] Will Smith Jared Leto Margot Robbie Viola Davis Vera Farmiga
## [6] Patrick Wilson
## 348 Levels: Aamir Khan Aaron Eckhart Aaron Paul ... Zooey DeschanelScraping metascore section.
##scrape the metascore section
metascore_data_html <- html_nodes(webpage,'.metascore')
##convert meta data to text
metascore_data <- html_text(metascore_data_html)
##remove extra space in metascore
metascore_data<-gsub(" ","",metascore_data)
head(metascore_data)## [1] "40" "65" "72" "59" "65" "74"length(metascore_data)## [1] 96metascore_data## [1] "40" "65" "72" "59" "65" "74" "81" "62" "54" "72" "67" "81" "75" "71" "94"
## [16] "70" "78" "51" "44" "41" "84" "72" "65" "68" "25" "79" "71" "51" "66" "51"
## [31] "48" "52" "99" "48" "96" "57" "44" "32" "57" "88" "79" "77" "52" "80" "58"
## [46] "28" "81" "66" "78" "81" "32" "76" "66" "42" "60" "62" "33" "51" "67" "52"
## [61] "81" "46" "69" "23" "77" "58" "58" "47" "49" "23" "59" "36" "46" "60" "78"
## [76] "42" "39" "55" "49" "77" "51" "64" "68" "55" "65" "72" "74" "35" "26" "40"
## [91] "42" "66" "34" "36" "33" "55"Correcting for missing the four metascores.
##for loop to fill in missing metascores
for (i in c(78,81,82,88)){
a<-metascore_data[1:(i-1)]
b<-metascore_data[i:length(metascore_data)]
metascore_data<-append(a,list("NA"))
metascore_data<-append(metascore_data,b)
}
#Data-Preprocessing: converting metascore to numerical
metascore_data<-as.numeric(metascore_data)## Warning: NAs introduced by coercion
## Warning: NAs introduced by coercion
## Warning: NAs introduced by coercion
## Warning: NAs introduced by coercionlength(metascore_data)## [1] 100summary(metascore_data)## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 23.00 46.75 59.50 59.15 72.00 99.00 4Scrape gross revenue.
##scrape the gross revenue section
gross_data_html <- html_nodes(webpage,'.ghost~ .text-muted+ span')
##convert gross revenue to text
gross_data <- html_text(gross_data_html)
#Data-Preprocessing: removing '$' and 'M' signs
gross_data<-gsub("M","",gross_data)
gross_data<-substring(gross_data,2,6)
#Let's check the length of gross data
length(gross_data)## [1] 89head(gross_data)## [1] "325.1" "102.4" "5.88" "270.4" "363.0" "169.6"length(gross_data)## [1] 89#Filling missing entries with NA
for (i in c(34, 50, 55, 60, 62, 63, 82, 87, 88, 89, 96)){
a<-gross_data[1:(i-1)]
b<-gross_data[i:length(gross_data)]
gross_data<-append(a,list("NA"))
gross_data<-append(gross_data,b)
}
gross_data<-as.numeric(gross_data)## Warning: NAs introduced by coercion
## Warning: NAs introduced by coercion
## Warning: NAs introduced by coercion
## Warning: NAs introduced by coercion
## Warning: NAs introduced by coercion
## Warning: NAs introduced by coercion
## Warning: NAs introduced by coercion
## Warning: NAs introduced by coercion
## Warning: NAs introduced by coercion
## Warning: NAs introduced by coercion
## Warning: NAs introduced by coercionhead(gross_data)## [1] 325.10 102.40 5.88 270.40 363.00 169.60length(gross_data)## [1] 100#Combining all the lists to form a data frame
movies_df<-data.frame(Rank = rank_data, Title = title_data,
Description = description_data, Runtime = runtime_data,
Genre = genre_data, Rating = rating_data,
Metascore = metascore_data, Votes = votes_data, Gross_Earning_in_Mil = gross_data,
Director = directors_data, Actor = actors_data)
#Structure of the data frame
str(movies_df)## 'data.frame': 400 obs. of 11 variables:
## $ Rank : num 1 2 3 4 5 6 7 8 9 10 ...
## $ Title : chr "Suicide Squad" "The Conjuring 2" "Captain Fantastic" "Sing" ...
## $ Description : chr "A secret government agency recruits some of the most dangerous incarcerated super-villains to form a defensive "| __truncated__ "Ed and Lorraine Warren travel to North London to help a single mother raising four children alone in a house pl"| __truncated__ "In the forests of the Pacific Northwest, a father devoted to raising his six kids with a rigorous physical and "| __truncated__ "In a city of humanoid animals, a hustling theater impresario's attempt to save his theater with a singing compe"| __truncated__ ...
## $ Runtime : num 123 134 118 108 108 127 107 117 132 115 ...
## $ Genre : Factor w/ 8 levels "Action","Adventure",..: 1 8 5 3 1 4 3 8 1 1 ...
## $ Rating : num 5.9 7.3 7.9 7.1 8 7.8 7.6 7.3 6.9 7.5 ...
## $ Metascore : num 40 65 72 59 65 74 81 62 54 72 ...
## $ Votes : num 622782 239722 199906 138652 928628 ...
## $ Gross_Earning_in_Mil: num 325.1 102.4 5.88 270.4 363 ...
## $ Director : Factor w/ 99 levels "Alex Proyas",..: 23 42 59 35 95 93 83 56 8 87 ...
## $ Actor : Factor w/ 348 levels "Aamir Khan","Aaron Eckhart",..: 339 146 211 337 332 263 207 111 333 120 ...Creating my qplot bar graph.
##bring in gg plot library
library('ggplot2')
##plot movies_df
qplot(data = movies_df,Runtime,fill = Genre,bins = 30)
Question 1: Based on the above data, which movie from which Genre had the longest runtime?
##filtering for longest runtime
filter(movies_df, Runtime > 160) %>%
arrange(., -Runtime)## Rank Title
## 1 45 American Honey
## 2 45 American Honey
## 3 45 American Honey
## 4 45 American Honey
## 5 42 Silence
## 6 64 Dangal
## 7 42 Silence
## 8 64 Dangal
## 9 42 Silence
## 10 64 Dangal
## 11 42 Silence
## 12 64 Dangal
## Description
## 1 A teenage girl with nothing to lose joins a traveling magazine sales crew, and gets caught up in a whirlwind of hard partying, law bending and young love as she criss-crosses the Midwest with a band of misfits.
## 2 A teenage girl with nothing to lose joins a traveling magazine sales crew, and gets caught up in a whirlwind of hard partying, law bending and young love as she criss-crosses the Midwest with a band of misfits.
## 3 A teenage girl with nothing to lose joins a traveling magazine sales crew, and gets caught up in a whirlwind of hard partying, law bending and young love as she criss-crosses the Midwest with a band of misfits.
## 4 A teenage girl with nothing to lose joins a traveling magazine sales crew, and gets caught up in a whirlwind of hard partying, law bending and young love as she criss-crosses the Midwest with a band of misfits.
## 5 In the 17th century, two Portuguese Jesuit priests travel to Japan in an attempt to locate their mentor, who is rumored to have committed apostasy, and to propagate Catholicism.
## 6 Former wrestler Mahavir Singh Phogat and his two wrestler daughters struggle towards glory at the Commonwealth Games in the face of societal oppression.
## 7 In the 17th century, two Portuguese Jesuit priests travel to Japan in an attempt to locate their mentor, who is rumored to have committed apostasy, and to propagate Catholicism.
## 8 Former wrestler Mahavir Singh Phogat and his two wrestler daughters struggle towards glory at the Commonwealth Games in the face of societal oppression.
## 9 In the 17th century, two Portuguese Jesuit priests travel to Japan in an attempt to locate their mentor, who is rumored to have committed apostasy, and to propagate Catholicism.
## 10 Former wrestler Mahavir Singh Phogat and his two wrestler daughters struggle towards glory at the Commonwealth Games in the face of societal oppression.
## 11 In the 17th century, two Portuguese Jesuit priests travel to Japan in an attempt to locate their mentor, who is rumored to have committed apostasy, and to propagate Catholicism.
## 12 Former wrestler Mahavir Singh Phogat and his two wrestler daughters struggle towards glory at the Commonwealth Games in the face of societal oppression.
## Runtime Genre Rating Metascore Votes Gross_Earning_in_Mil
## 1 163 Adventure 7.0 58 39829 0.66
## 2 163 Adventure 7.0 58 39829 0.66
## 3 163 Adventure 7.0 58 39829 0.66
## 4 163 Adventure 7.0 58 39829 0.66
## 5 161 Drama 7.2 77 103412 7.10
## 6 161 Action 8.4 23 165829 12.39
## 7 161 Drama 7.2 77 103412 7.10
## 8 161 Action 8.4 23 165829 12.39
## 9 161 Drama 7.2 77 103412 7.10
## 10 161 Action 8.4 23 165829 12.39
## 11 161 Drama 7.2 77 103412 7.10
## 12 161 Action 8.4 23 165829 12.39
## Director Actor
## 1 Andrea Arnold Amy Adams
## 2 Andrea Arnold Eva Green
## 3 Andrea Arnold Jun Kunimura
## 4 Andrea Arnold Craig Roberts
## 5 Martin Scorsese Jake Gyllenhaal
## 6 Nitesh Tiwari Matt Bomer
## 7 Martin Scorsese Michelle Williams
## 8 Nitesh Tiwari Gil Birmingham
## 9 Martin Scorsese Kevin Hart
## 10 Nitesh Tiwari Michael Peña
## 11 Martin Scorsese Kurt Russell
## 12 Nitesh Tiwari Valerie MahaffeyAmerican Honey from the Adventure genre is the longest movie at 163 minutes.
Time for a plot graph and question 2.
##geom_point graph
ggplot(movies_df,aes(x=Runtime,y=Rating))+
geom_point(aes(size=Votes,col=Genre))
Based on the above data, in the Runtime of 130-160 mins, which genre has the highest votes?
## filter for runtime 130 through 160
filter(movies_df, Runtime > 130 & Runtime < 160) %>%
arrange(., -Votes)## Rank Title
## 1 13 Captain America: Civil War
## 2 13 Captain America: Civil War
## 3 13 Captain America: Civil War
## 4 13 Captain America: Civil War
## 5 19 Batman v Superman: Dawn of Justice
## 6 19 Batman v Superman: Dawn of Justice
## 7 19 Batman v Superman: Dawn of Justice
## 8 19 Batman v Superman: Dawn of Justice
## 9 23 Rogue One: A Star Wars Story
## 10 23 Rogue One: A Star Wars Story
## 11 23 Rogue One: A Star Wars Story
## 12 23 Rogue One: A Star Wars Story
## 13 14 Hacksaw Ridge
## 14 14 Hacksaw Ridge
## 15 14 Hacksaw Ridge
## 16 14 Hacksaw Ridge
## 17 29 Fantastic Beasts and Where to Find Them
## 18 29 Fantastic Beasts and Where to Find Them
## 19 29 Fantastic Beasts and Where to Find Them
## 20 29 Fantastic Beasts and Where to Find Them
## 21 32 X-Men: Apocalypse
## 22 32 X-Men: Apocalypse
## 23 32 X-Men: Apocalypse
## 24 32 X-Men: Apocalypse
## 25 36 Manchester by the Sea
## 26 36 Manchester by the Sea
## 27 36 Manchester by the Sea
## 28 36 Manchester by the Sea
## 29 2 The Conjuring 2
## 30 2 The Conjuring 2
## 31 2 The Conjuring 2
## 32 2 The Conjuring 2
## 33 9 The Magnificent Seven
## 34 9 The Magnificent Seven
## 35 9 The Magnificent Seven
## 36 9 The Magnificent Seven
## 37 69 Snowden
## 38 69 Snowden
## 39 69 Snowden
## 40 69 Snowden
## 41 31 13 Hours
## 42 31 13 Hours
## 43 31 13 Hours
## 44 31 13 Hours
## 45 21 The Handmaiden
## 46 21 The Handmaiden
## 47 21 The Handmaiden
## 48 21 The Handmaiden
## 49 77 The Lost City of Z
## 50 77 The Lost City of Z
## 51 77 The Lost City of Z
## 52 77 The Lost City of Z
## 53 85 Miss Sloane
## 54 85 Miss Sloane
## 55 85 Miss Sloane
## 56 85 Miss Sloane
## 57 62 The Wailing
## 58 62 The Wailing
## 59 62 The Wailing
## 60 62 The Wailing
## Description
## 1 Political involvement in the Avengers' affairs causes a rift between Captain America and Iron Man.
## 2 Political involvement in the Avengers' affairs causes a rift between Captain America and Iron Man.
## 3 Political involvement in the Avengers' affairs causes a rift between Captain America and Iron Man.
## 4 Political involvement in the Avengers' affairs causes a rift between Captain America and Iron Man.
## 5 Fearing that the actions of Superman are left unchecked, Batman takes on the Man of Steel, while the world wrestles with what kind of a hero it really needs.
## 6 Fearing that the actions of Superman are left unchecked, Batman takes on the Man of Steel, while the world wrestles with what kind of a hero it really needs.
## 7 Fearing that the actions of Superman are left unchecked, Batman takes on the Man of Steel, while the world wrestles with what kind of a hero it really needs.
## 8 Fearing that the actions of Superman are left unchecked, Batman takes on the Man of Steel, while the world wrestles with what kind of a hero it really needs.
## 9 In a time of conflict, a group of unlikely heroes band together on a mission to steal the plans to the Death Star, the Empire's ultimate weapon of destruction.
## 10 In a time of conflict, a group of unlikely heroes band together on a mission to steal the plans to the Death Star, the Empire's ultimate weapon of destruction.
## 11 In a time of conflict, a group of unlikely heroes band together on a mission to steal the plans to the Death Star, the Empire's ultimate weapon of destruction.
## 12 In a time of conflict, a group of unlikely heroes band together on a mission to steal the plans to the Death Star, the Empire's ultimate weapon of destruction.
## 13 World War II American Army Medic Desmond T. Doss, who served during the Battle of Okinawa, refuses to kill people and becomes the first man in American history to receive the Medal of Honor without firing a shot.
## 14 World War II American Army Medic Desmond T. Doss, who served during the Battle of Okinawa, refuses to kill people and becomes the first man in American history to receive the Medal of Honor without firing a shot.
## 15 World War II American Army Medic Desmond T. Doss, who served during the Battle of Okinawa, refuses to kill people and becomes the first man in American history to receive the Medal of Honor without firing a shot.
## 16 World War II American Army Medic Desmond T. Doss, who served during the Battle of Okinawa, refuses to kill people and becomes the first man in American history to receive the Medal of Honor without firing a shot.
## 17 The adventures of writer Newt Scamander in New York's secret community of witches and wizards seventy years before Harry Potter reads his book in school.
## 18 The adventures of writer Newt Scamander in New York's secret community of witches and wizards seventy years before Harry Potter reads his book in school.
## 19 The adventures of writer Newt Scamander in New York's secret community of witches and wizards seventy years before Harry Potter reads his book in school.
## 20 The adventures of writer Newt Scamander in New York's secret community of witches and wizards seventy years before Harry Potter reads his book in school.
## 21 In the 1980s the X-Men must defeat an ancient all-powerful mutant, En Sabah Nur, who intends to thrive through bringing destruction to the world.
## 22 In the 1980s the X-Men must defeat an ancient all-powerful mutant, En Sabah Nur, who intends to thrive through bringing destruction to the world.
## 23 In the 1980s the X-Men must defeat an ancient all-powerful mutant, En Sabah Nur, who intends to thrive through bringing destruction to the world.
## 24 In the 1980s the X-Men must defeat an ancient all-powerful mutant, En Sabah Nur, who intends to thrive through bringing destruction to the world.
## 25 A depressed uncle is asked to take care of his teenage nephew after the boy's father dies.
## 26 A depressed uncle is asked to take care of his teenage nephew after the boy's father dies.
## 27 A depressed uncle is asked to take care of his teenage nephew after the boy's father dies.
## 28 A depressed uncle is asked to take care of his teenage nephew after the boy's father dies.
## 29 Ed and Lorraine Warren travel to North London to help a single mother raising four children alone in a house plagued by a supernatural spirit.
## 30 Ed and Lorraine Warren travel to North London to help a single mother raising four children alone in a house plagued by a supernatural spirit.
## 31 Ed and Lorraine Warren travel to North London to help a single mother raising four children alone in a house plagued by a supernatural spirit.
## 32 Ed and Lorraine Warren travel to North London to help a single mother raising four children alone in a house plagued by a supernatural spirit.
## 33 Seven gunmen from a variety of backgrounds are brought together by a vengeful young widow to protect her town from the private army of a destructive industrialist.
## 34 Seven gunmen from a variety of backgrounds are brought together by a vengeful young widow to protect her town from the private army of a destructive industrialist.
## 35 Seven gunmen from a variety of backgrounds are brought together by a vengeful young widow to protect her town from the private army of a destructive industrialist.
## 36 Seven gunmen from a variety of backgrounds are brought together by a vengeful young widow to protect her town from the private army of a destructive industrialist.
## 37 The NSA's illegal surveillance techniques are leaked to the public by one of the agency's employees, Edward Snowden, in the form of thousands of classified documents distributed to the press.
## 38 The NSA's illegal surveillance techniques are leaked to the public by one of the agency's employees, Edward Snowden, in the form of thousands of classified documents distributed to the press.
## 39 The NSA's illegal surveillance techniques are leaked to the public by one of the agency's employees, Edward Snowden, in the form of thousands of classified documents distributed to the press.
## 40 The NSA's illegal surveillance techniques are leaked to the public by one of the agency's employees, Edward Snowden, in the form of thousands of classified documents distributed to the press.
## 41 During an attack on a U.S. compound in Libya, a security team struggles to make sense out of the chaos.
## 42 During an attack on a U.S. compound in Libya, a security team struggles to make sense out of the chaos.
## 43 During an attack on a U.S. compound in Libya, a security team struggles to make sense out of the chaos.
## 44 During an attack on a U.S. compound in Libya, a security team struggles to make sense out of the chaos.
## 45 A woman is hired as a handmaiden to a Japanese heiress, but secretly she is involved in a plot to defraud her.
## 46 A woman is hired as a handmaiden to a Japanese heiress, but secretly she is involved in a plot to defraud her.
## 47 A woman is hired as a handmaiden to a Japanese heiress, but secretly she is involved in a plot to defraud her.
## 48 A woman is hired as a handmaiden to a Japanese heiress, but secretly she is involved in a plot to defraud her.
## 49 A true-life drama, centering on British explorer Major Percival Fawcett, who disappeared whilst searching for a mysterious city in the Amazon in the 1920s.
## 50 A true-life drama, centering on British explorer Major Percival Fawcett, who disappeared whilst searching for a mysterious city in the Amazon in the 1920s.
## 51 A true-life drama, centering on British explorer Major Percival Fawcett, who disappeared whilst searching for a mysterious city in the Amazon in the 1920s.
## 52 A true-life drama, centering on British explorer Major Percival Fawcett, who disappeared whilst searching for a mysterious city in the Amazon in the 1920s.
## 53 In the high-stakes world of political power-brokers, Elizabeth Sloane is the most sought after and formidable lobbyist in D.C. But when taking on the most powerful opponent of her career, she finds winning may come at too high a price.
## 54 In the high-stakes world of political power-brokers, Elizabeth Sloane is the most sought after and formidable lobbyist in D.C. But when taking on the most powerful opponent of her career, she finds winning may come at too high a price.
## 55 In the high-stakes world of political power-brokers, Elizabeth Sloane is the most sought after and formidable lobbyist in D.C. But when taking on the most powerful opponent of her career, she finds winning may come at too high a price.
## 56 In the high-stakes world of political power-brokers, Elizabeth Sloane is the most sought after and formidable lobbyist in D.C. But when taking on the most powerful opponent of her career, she finds winning may come at too high a price.
## 57 Soon after a stranger arrives in a little village, a mysterious sickness starts spreading. A policeman, drawn into the incident, is forced to solve the mystery in order to save his daughter.
## 58 Soon after a stranger arrives in a little village, a mysterious sickness starts spreading. A policeman, drawn into the incident, is forced to solve the mystery in order to save his daughter.
## 59 Soon after a stranger arrives in a little village, a mysterious sickness starts spreading. A policeman, drawn into the incident, is forced to solve the mystery in order to save his daughter.
## 60 Soon after a stranger arrives in a little village, a mysterious sickness starts spreading. A policeman, drawn into the incident, is forced to solve the mystery in order to save his daughter.
## Runtime Genre Rating Metascore Votes Gross_Earning_in_Mil
## 1 147 Action 7.8 75 690516 408.00
## 2 147 Action 7.8 75 690516 408.00
## 3 147 Action 7.8 75 690516 408.00
## 4 147 Action 7.8 75 690516 408.00
## 5 152 Action 6.4 44 653739 330.30
## 6 152 Action 6.4 44 653739 330.30
## 7 152 Action 6.4 44 653739 330.30
## 8 152 Action 6.4 44 653739 330.30
## 9 133 Action 7.8 65 570605 532.10
## 10 133 Action 7.8 65 570605 532.10
## 11 133 Action 7.8 65 570605 532.10
## 12 133 Action 7.8 65 570605 532.10
## 13 139 Biography 8.1 71 455091 67.21
## 14 139 Biography 8.1 71 455091 67.21
## 15 139 Biography 8.1 71 455091 67.21
## 16 139 Biography 8.1 71 455091 67.21
## 17 132 Adventure 7.3 66 421202 234.00
## 18 132 Adventure 7.3 66 421202 234.00
## 19 132 Adventure 7.3 66 421202 234.00
## 20 132 Adventure 7.3 66 421202 234.00
## 21 144 Action 6.9 52 403201 155.40
## 22 144 Action 6.9 52 403201 155.40
## 23 144 Action 6.9 52 403201 155.40
## 24 144 Action 6.9 52 403201 155.40
## 25 137 Drama 7.8 57 255992 47.70
## 26 137 Drama 7.8 57 255992 47.70
## 27 137 Drama 7.8 57 255992 47.70
## 28 137 Drama 7.8 57 255992 47.70
## 29 134 Horror 7.3 65 239722 102.40
## 30 134 Horror 7.3 65 239722 102.40
## 31 134 Horror 7.3 65 239722 102.40
## 32 134 Horror 7.3 65 239722 102.40
## 33 132 Action 6.9 54 189408 93.43
## 34 132 Action 6.9 54 189408 93.43
## 35 132 Action 6.9 54 189408 93.43
## 36 132 Action 6.9 54 189408 93.43
## 37 134 Biography 7.3 49 142449 21.59
## 38 134 Biography 7.3 49 142449 21.59
## 39 134 Biography 7.3 49 142449 21.59
## 40 134 Biography 7.3 49 142449 21.59
## 41 144 Action 7.3 48 124834 52.85
## 42 144 Action 7.3 48 124834 52.85
## 43 144 Action 7.3 48 124834 52.85
## 44 144 Action 7.3 48 124834 52.85
## 45 145 Drama 8.1 84 122537 2.01
## 46 145 Drama 8.1 84 122537 2.01
## 47 145 Drama 8.1 84 122537 2.01
## 48 145 Drama 8.1 84 122537 2.01
## 49 141 Biography 6.6 39 83224 8.58
## 50 141 Biography 6.6 39 83224 8.58
## 51 141 Biography 6.6 39 83224 8.58
## 52 141 Biography 6.6 39 83224 8.58
## 53 132 Drama 7.5 64 67366 3.44
## 54 132 Drama 7.5 64 67366 3.44
## 55 132 Drama 7.5 64 67366 3.44
## 56 132 Drama 7.5 64 67366 3.44
## 57 156 Horror 7.5 46 56377 NA
## 58 156 Horror 7.5 46 56377 NA
## 59 156 Horror 7.5 46 56377 NA
## 60 156 Horror 7.5 46 56377 NA
## Director Actor
## 1 Anthony Russo Matthew McConaughey
## 2 Anthony Russo Eddie Redmayne
## 3 Anthony Russo Michael Keaton
## 4 Anthony Russo Zoey Deutch
## 5 Zack Snyder T.J. Miller
## 6 Zack Snyder Keanu Reeves
## 7 Zack Snyder Sebastian Pigott
## 8 Zack Snyder Mykelti Williamson
## 9 Gareth Edwards Janelle Monáe
## 10 Gareth Edwards James Badge Dale
## 11 Gareth Edwards Kate McKinnon
## 12 Gareth Edwards Bryce Dallas Howard
## 13 Mel Gibson Reese Witherspoon
## 14 Mel Gibson Katherine Waterston
## 15 Mel Gibson Nick Offerman
## 16 Mel Gibson James Franco
## 17 David Yates James McAvoy
## 18 David Yates Mahershala Ali
## 19 David Yates Chloë Grace Moretz
## 20 David Yates Hailee Steinfeld
## 21 Bryan Singer Jessica Sula
## 22 Bryan Singer Alex R. Hibbert
## 23 Bryan Singer Bailey Anne Borders
## 24 Bryan Singer Kyra Sedgwick
## 25 Kenneth Lonergan Vincent D'Onofrio
## 26 Kenneth Lonergan Bárbara Lennie
## 27 Kenneth Lonergan Alison Brie
## 28 Kenneth Lonergan Aubrey Plaza
## 29 James Wan Jared Leto
## 30 James Wan Mone Kamishiraishi
## 31 James Wan Julian Dennison
## 32 James Wan Marion Cotillard
## 33 Antoine Fuqua Viggo Mortensen
## 34 Antoine Fuqua Ben Affleck
## 35 Antoine Fuqua John Goodman
## 36 Antoine Fuqua Tom Hanks
## 37 Oliver Stone Emilia Clarke
## 38 Oliver Stone Neel Sethi
## 39 Oliver Stone Teresa Palmer
## 40 Oliver Stone Benjamin Walker
## 41 Michael Bay Haley Lu Richardson
## 42 Michael Bay Trevante Rhodes
## 43 Michael Bay Gabriela Lopez
## 44 Michael Bay Blake Jenner
## 45 Park Chan-Wook Taraji P. Henson
## 46 Park Chan-Wook John Krasinski
## 47 Park Chan-Wook Melissa McCarthy
## 48 Park Chan-Wook Matthew McConaughey
## 49 James Gray Jennifer Lawrence
## 50 James Gray Sasha Lane
## 51 James Gray Tom Cruise
## 52 James Gray Matt Damon
## 53 John Madden Gong Yoo
## 54 John Madden Gerard Butler
## 55 John Madden Kate Beckinsale
## 56 John Madden Ray Romano
## 57 Na Hong-jin Ryan Gosling
## 58 Na Hong-jin Ben Foster
## 59 Na Hong-jin Edward Norton
## 60 Na Hong-jin Aaron Eckhart##find the most votes per genre
mostvotes <- movies_df %>%
group_by(Genre) %>%
summarise(most_votes = sum(Votes, na.rm=TRUE)) %>%
arrange(., -most_votes)
mostvotes## # A tibble: 8 x 2
## Genre most_votes
## <fct> <dbl>
## 1 Action 40262880
## 2 Drama 10409600
## 3 Animation 6825888
## 4 Biography 6707664
## 5 Comedy 5224120
## 6 Horror 4163080
## 7 Adventure 4003940
## 8 Crime 2592056At 40262880 Action has the highest votes of all the genres.
Time for a plot graph and question 3.
ggplot(movies_df,aes(x=Runtime,y=Gross_Earning_in_Mil))+
geom_point(aes(size=Rating,col=Genre))## Warning: Removed 44 rows containing missing values (geom_point).
Question 3: Based on the above data, across all genres which genre has the highest average gross earnings in runtime 100 to 120.
##filter for 100 to 120 runtime
filter(movies_df, Runtime > 100 & Runtime < 120)## Rank Title
## 1 3 Captain Fantastic
## 2 4 Sing
## 3 5 Deadpool
## 4 7 Moana
## 5 8 Split
## 6 10 Doctor Strange
## 7 11 Nocturnal Animals
## 8 12 Arrival
## 9 16 The Nice Guys
## 10 17 Zootopia
## 11 18 Me Before You
## 12 20 Passengers
## 13 22 Train to Busan
## 14 26 Your Name.
## 15 30 The Neon Demon
## 16 33 Moonlight
## 17 34 The Invisible Guest
## 18 35 The Girl on the Train
## 19 38 The Legend of Tarzan
## 20 40 War Dogs
## 21 41 Hell or High Water
## 22 43 The Jungle Book
## 23 44 Triple 9
## 24 51 Hunt for the Wilderpeople
## 25 53 10 Cloverfield Lane
## 26 54 The Founder
## 27 56 Ghostbusters: Answer the Call
## 28 57 The Bad Batch
## 29 58 The 5th Wave
## 30 59 How to Be Single
## 31 61 Central Intelligence
## 32 65 Lion
## 33 70 Jack Reacher: Never Go Back
## 34 71 Resident Evil: The Final Chapter
## 35 74 Assassin's Creed
## 36 79 Why Him?
## 37 80 The Purge: Election Year
## 38 83 The Edge of Seventeen
## 39 86 Deepwater Horizon
## 40 90 Hail, Caesar!
## 41 92 The Huntsman: Winter's War
## 42 93 The Choice
## 43 94 Teenage Mutant Ninja Turtles: Out of the Shadows
## 44 95 The Great Wall
## 45 98 Criminal
## 46 3 Captain Fantastic
## 47 4 Sing
## 48 5 Deadpool
## 49 7 Moana
## 50 8 Split
## 51 10 Doctor Strange
## 52 11 Nocturnal Animals
## 53 12 Arrival
## 54 16 The Nice Guys
## 55 17 Zootopia
## 56 18 Me Before You
## 57 20 Passengers
## 58 22 Train to Busan
## 59 26 Your Name.
## 60 30 The Neon Demon
## 61 33 Moonlight
## 62 34 The Invisible Guest
## 63 35 The Girl on the Train
## 64 38 The Legend of Tarzan
## 65 40 War Dogs
## 66 41 Hell or High Water
## 67 43 The Jungle Book
## 68 44 Triple 9
## 69 51 Hunt for the Wilderpeople
## 70 53 10 Cloverfield Lane
## 71 54 The Founder
## 72 56 Ghostbusters: Answer the Call
## 73 57 The Bad Batch
## 74 58 The 5th Wave
## 75 59 How to Be Single
## 76 61 Central Intelligence
## 77 65 Lion
## 78 70 Jack Reacher: Never Go Back
## 79 71 Resident Evil: The Final Chapter
## 80 74 Assassin's Creed
## 81 79 Why Him?
## 82 80 The Purge: Election Year
## 83 83 The Edge of Seventeen
## 84 86 Deepwater Horizon
## 85 90 Hail, Caesar!
## 86 92 The Huntsman: Winter's War
## 87 93 The Choice
## 88 94 Teenage Mutant Ninja Turtles: Out of the Shadows
## 89 95 The Great Wall
## 90 98 Criminal
## 91 3 Captain Fantastic
## 92 4 Sing
## 93 5 Deadpool
## 94 7 Moana
## 95 8 Split
## 96 10 Doctor Strange
## 97 11 Nocturnal Animals
## 98 12 Arrival
## 99 16 The Nice Guys
## 100 17 Zootopia
## 101 18 Me Before You
## 102 20 Passengers
## 103 22 Train to Busan
## 104 26 Your Name.
## 105 30 The Neon Demon
## 106 33 Moonlight
## 107 34 The Invisible Guest
## 108 35 The Girl on the Train
## 109 38 The Legend of Tarzan
## 110 40 War Dogs
## 111 41 Hell or High Water
## 112 43 The Jungle Book
## 113 44 Triple 9
## 114 51 Hunt for the Wilderpeople
## 115 53 10 Cloverfield Lane
## 116 54 The Founder
## 117 56 Ghostbusters: Answer the Call
## 118 57 The Bad Batch
## 119 58 The 5th Wave
## 120 59 How to Be Single
## 121 61 Central Intelligence
## 122 65 Lion
## 123 70 Jack Reacher: Never Go Back
## 124 71 Resident Evil: The Final Chapter
## 125 74 Assassin's Creed
## 126 79 Why Him?
## 127 80 The Purge: Election Year
## 128 83 The Edge of Seventeen
## 129 86 Deepwater Horizon
## 130 90 Hail, Caesar!
## 131 92 The Huntsman: Winter's War
## 132 93 The Choice
## 133 94 Teenage Mutant Ninja Turtles: Out of the Shadows
## 134 95 The Great Wall
## 135 98 Criminal
## 136 3 Captain Fantastic
## 137 4 Sing
## 138 5 Deadpool
## 139 7 Moana
## 140 8 Split
## 141 10 Doctor Strange
## 142 11 Nocturnal Animals
## 143 12 Arrival
## 144 16 The Nice Guys
## 145 17 Zootopia
## 146 18 Me Before You
## 147 20 Passengers
## 148 22 Train to Busan
## 149 26 Your Name.
## 150 30 The Neon Demon
## 151 33 Moonlight
## 152 34 The Invisible Guest
## 153 35 The Girl on the Train
## 154 38 The Legend of Tarzan
## 155 40 War Dogs
## 156 41 Hell or High Water
## 157 43 The Jungle Book
## 158 44 Triple 9
## 159 51 Hunt for the Wilderpeople
## 160 53 10 Cloverfield Lane
## 161 54 The Founder
## 162 56 Ghostbusters: Answer the Call
## 163 57 The Bad Batch
## 164 58 The 5th Wave
## 165 59 How to Be Single
## 166 61 Central Intelligence
## 167 65 Lion
## 168 70 Jack Reacher: Never Go Back
## 169 71 Resident Evil: The Final Chapter
## 170 74 Assassin's Creed
## 171 79 Why Him?
## 172 80 The Purge: Election Year
## 173 83 The Edge of Seventeen
## 174 86 Deepwater Horizon
## 175 90 Hail, Caesar!
## 176 92 The Huntsman: Winter's War
## 177 93 The Choice
## 178 94 Teenage Mutant Ninja Turtles: Out of the Shadows
## 179 95 The Great Wall
## 180 98 Criminal
## Description
## 1 In the forests of the Pacific Northwest, a father devoted to raising his six kids with a rigorous physical and intellectual education is forced to leave his paradise and enter the world, challenging his idea of what it means to be a parent.
## 2 In a city of humanoid animals, a hustling theater impresario's attempt to save his theater with a singing competition becomes grander than he anticipates even as its finalists find that their lives will never be the same.
## 3 A wisecracking mercenary gets experimented on and becomes immortal but ugly, and sets out to track down the man who ruined his looks.
## 4 In Ancient Polynesia, when a terrible curse incurred by the Demigod Maui reaches Moana's island, she answers the Ocean's call to seek out the Demigod to set things right.
## 5 Three girls are kidnapped by a man with a diagnosed 23 distinct personalities. They must try to escape before the apparent emergence of a frightful new 24th.
## 6 While on a journey of physical and spiritual healing, a brilliant neurosurgeon is drawn into the world of the mystic arts.
## 7 A wealthy art gallery owner is haunted by her ex-husband's novel, a violent thriller she interprets as a symbolic revenge tale.
## 8 A linguist works with the military to communicate with alien lifeforms after twelve mysterious spacecraft appear around the world.
## 9 In 1970s Los Angeles, a mismatched pair of private eyes investigate a missing girl and the mysterious death of a porn star.
## 10 In a city of anthropomorphic animals, a rookie bunny cop and a cynical con artist fox must work together to uncover a conspiracy.
## 11 A girl in a small town forms an unlikely bond with a recently-paralyzed man she's taking care of.
## 12 A malfunction in a sleeping pod on a spacecraft traveling to a distant colony planet wakes one passenger 90 years early.
## 13 While a zombie virus breaks out in South Korea, passengers struggle to survive on the train from Seoul to Busan.
## 14 Two strangers find themselves linked in a bizarre way. When a connection forms, will distance be the only thing to keep them apart?
## 15 An aspiring model, Jesse, is new to Los Angeles. However, her beauty and youth, which generate intense fascination and jealousy within the fashion industry, may prove themselves sinister.
## 16 A young African-American man grapples with his identity and sexuality while experiencing the everyday struggles of childhood, adolescence, and burgeoning adulthood.
## 17 A successful entrepreneur accused of murder and a witness preparation expert have less than three hours to come up with an impregnable defense.
## 18 A divorcee becomes entangled in a missing persons investigation that promises to send shockwaves throughout her life.
## 19 Tarzan, having acclimated to life in London, is called back to his former home in the jungle to investigate the activities at a mining encampment.
## 20 Loosely based on the true story of two young men, David Packouz and Efraim Diveroli, who won a three hundred million dollar contract from the Pentagon to arm America's allies in Afghanistan.
## 21 A divorced father and his ex-con older brother resort to a desperate scheme in order to save their family's ranch in West Texas.
## 22 After a threat from the tiger Shere Khan forces him to flee the jungle, a man-cub named Mowgli embarks on a journey of self discovery with the help of panther Bagheera and free-spirited bear Baloo.
## 23 A gang of criminals and corrupt cops plan the murder of a police officer in order to pull off their biggest heist yet across town.
## 24 A national manhunt is ordered for a rebellious kid and his foster uncle who go missing in the wild New Zealand bush.
## 25 After getting in a car accident, a woman is held in a shelter by a man who claims that the outside world is affected by a widespread chemical attack.
## 26 The story of Ray Kroc, a salesman who turned two brothers' innovative fast food eatery, McDonald's, into the biggest restaurant business in the world, with a combination of ambition, persistence, and ruthlessness.
## 27 Following a ghost invasion of Manhattan, paranormal enthusiasts Erin Gilbert and Abby Yates, nuclear engineer Jillian Holtzmann, and subway worker Patty Tolan band together to stop the otherworldly threat.
## 28 In a desert dystopia, a young woman is kidnapped by cannibals.
## 29 Four waves of increasingly deadly alien attacks have left most of Earth in ruin. Cassie is on the run, desperately trying to save her younger brother.
## 30 A group of young adults navigate love and relationships in New York City.
## 31 After he reconnects with an awkward pal from high school through Facebook, a mild-mannered accountant is lured into the world of international espionage.
## 32 A five-year-old Indian boy is adopted by an Australian couple after getting lost hundreds of kilometers from home. 25 years later, he sets out to find his lost family.
## 33 Jack Reacher must uncover the truth behind a major government conspiracy in order to clear his name while on the run as a fugitive from the law.
## 34 Alice returns to where the nightmare began: The Hive in Raccoon City, where the Umbrella Corporation is gathering its forces for a final strike against the only remaining survivors of the apocalypse.
## 35 Callum Lynch explores the memories of his ancestor Aguilar de Nerha and gains the skills of a Master Assassin, before taking on the secret Templar society.
## 36 A holiday gathering threatens to go off the rails when Ned Fleming realizes that his daughter's Silicon Valley millionaire boyfriend is about to pop the question.
## 37 Former Police Sergeant Barnes becomes head of security for Senator Charlie Roan, a Presidential candidate targeted for death on Purge night due to her vow to eliminate the Purge.
## 38 High-school life gets even more unbearable for Nadine when her best friend, Krista, starts dating her older brother.
## 39 A dramatization of the disaster in April 2010, when the offshore drilling rig called the Deepwater Horizon exploded, resulting in the worst oil spill in American history.
## 40 A Hollywood fixer in the 1950s works to keep the studio's stars in line.
## 41 Eric and fellow warrior Sara, raised as members of ice Queen Freya's army, try to conceal their forbidden love as they fight to survive the wicked intentions of both Freya and her sister Ravenna.
## 42 Travis and Gabby first meet as neighbors in a small coastal town and wind up in a relationship that is tested by life's most defining events.
## 43 The Turtles get into another battle with their enemy the Shredder, who has acquired new allies: the mutant thugs Bebop and Rocksteady and the alien being Krang.
## 44 In ancient China, a group of European mercenaries encounters a secret army that maintains and defends the Great Wall of China against a horde of monstrous creatures.
## 45 In a last-ditch effort to stop a diabolical plot, a dead CIA operative's memories, secrets, and skills are implanted into a death-row inmate in hopes that he will complete the operative's mission.
## 46 In the forests of the Pacific Northwest, a father devoted to raising his six kids with a rigorous physical and intellectual education is forced to leave his paradise and enter the world, challenging his idea of what it means to be a parent.
## 47 In a city of humanoid animals, a hustling theater impresario's attempt to save his theater with a singing competition becomes grander than he anticipates even as its finalists find that their lives will never be the same.
## 48 A wisecracking mercenary gets experimented on and becomes immortal but ugly, and sets out to track down the man who ruined his looks.
## 49 In Ancient Polynesia, when a terrible curse incurred by the Demigod Maui reaches Moana's island, she answers the Ocean's call to seek out the Demigod to set things right.
## 50 Three girls are kidnapped by a man with a diagnosed 23 distinct personalities. They must try to escape before the apparent emergence of a frightful new 24th.
## 51 While on a journey of physical and spiritual healing, a brilliant neurosurgeon is drawn into the world of the mystic arts.
## 52 A wealthy art gallery owner is haunted by her ex-husband's novel, a violent thriller she interprets as a symbolic revenge tale.
## 53 A linguist works with the military to communicate with alien lifeforms after twelve mysterious spacecraft appear around the world.
## 54 In 1970s Los Angeles, a mismatched pair of private eyes investigate a missing girl and the mysterious death of a porn star.
## 55 In a city of anthropomorphic animals, a rookie bunny cop and a cynical con artist fox must work together to uncover a conspiracy.
## 56 A girl in a small town forms an unlikely bond with a recently-paralyzed man she's taking care of.
## 57 A malfunction in a sleeping pod on a spacecraft traveling to a distant colony planet wakes one passenger 90 years early.
## 58 While a zombie virus breaks out in South Korea, passengers struggle to survive on the train from Seoul to Busan.
## 59 Two strangers find themselves linked in a bizarre way. When a connection forms, will distance be the only thing to keep them apart?
## 60 An aspiring model, Jesse, is new to Los Angeles. However, her beauty and youth, which generate intense fascination and jealousy within the fashion industry, may prove themselves sinister.
## 61 A young African-American man grapples with his identity and sexuality while experiencing the everyday struggles of childhood, adolescence, and burgeoning adulthood.
## 62 A successful entrepreneur accused of murder and a witness preparation expert have less than three hours to come up with an impregnable defense.
## 63 A divorcee becomes entangled in a missing persons investigation that promises to send shockwaves throughout her life.
## 64 Tarzan, having acclimated to life in London, is called back to his former home in the jungle to investigate the activities at a mining encampment.
## 65 Loosely based on the true story of two young men, David Packouz and Efraim Diveroli, who won a three hundred million dollar contract from the Pentagon to arm America's allies in Afghanistan.
## 66 A divorced father and his ex-con older brother resort to a desperate scheme in order to save their family's ranch in West Texas.
## 67 After a threat from the tiger Shere Khan forces him to flee the jungle, a man-cub named Mowgli embarks on a journey of self discovery with the help of panther Bagheera and free-spirited bear Baloo.
## 68 A gang of criminals and corrupt cops plan the murder of a police officer in order to pull off their biggest heist yet across town.
## 69 A national manhunt is ordered for a rebellious kid and his foster uncle who go missing in the wild New Zealand bush.
## 70 After getting in a car accident, a woman is held in a shelter by a man who claims that the outside world is affected by a widespread chemical attack.
## 71 The story of Ray Kroc, a salesman who turned two brothers' innovative fast food eatery, McDonald's, into the biggest restaurant business in the world, with a combination of ambition, persistence, and ruthlessness.
## 72 Following a ghost invasion of Manhattan, paranormal enthusiasts Erin Gilbert and Abby Yates, nuclear engineer Jillian Holtzmann, and subway worker Patty Tolan band together to stop the otherworldly threat.
## 73 In a desert dystopia, a young woman is kidnapped by cannibals.
## 74 Four waves of increasingly deadly alien attacks have left most of Earth in ruin. Cassie is on the run, desperately trying to save her younger brother.
## 75 A group of young adults navigate love and relationships in New York City.
## 76 After he reconnects with an awkward pal from high school through Facebook, a mild-mannered accountant is lured into the world of international espionage.
## 77 A five-year-old Indian boy is adopted by an Australian couple after getting lost hundreds of kilometers from home. 25 years later, he sets out to find his lost family.
## 78 Jack Reacher must uncover the truth behind a major government conspiracy in order to clear his name while on the run as a fugitive from the law.
## 79 Alice returns to where the nightmare began: The Hive in Raccoon City, where the Umbrella Corporation is gathering its forces for a final strike against the only remaining survivors of the apocalypse.
## 80 Callum Lynch explores the memories of his ancestor Aguilar de Nerha and gains the skills of a Master Assassin, before taking on the secret Templar society.
## 81 A holiday gathering threatens to go off the rails when Ned Fleming realizes that his daughter's Silicon Valley millionaire boyfriend is about to pop the question.
## 82 Former Police Sergeant Barnes becomes head of security for Senator Charlie Roan, a Presidential candidate targeted for death on Purge night due to her vow to eliminate the Purge.
## 83 High-school life gets even more unbearable for Nadine when her best friend, Krista, starts dating her older brother.
## 84 A dramatization of the disaster in April 2010, when the offshore drilling rig called the Deepwater Horizon exploded, resulting in the worst oil spill in American history.
## 85 A Hollywood fixer in the 1950s works to keep the studio's stars in line.
## 86 Eric and fellow warrior Sara, raised as members of ice Queen Freya's army, try to conceal their forbidden love as they fight to survive the wicked intentions of both Freya and her sister Ravenna.
## 87 Travis and Gabby first meet as neighbors in a small coastal town and wind up in a relationship that is tested by life's most defining events.
## 88 The Turtles get into another battle with their enemy the Shredder, who has acquired new allies: the mutant thugs Bebop and Rocksteady and the alien being Krang.
## 89 In ancient China, a group of European mercenaries encounters a secret army that maintains and defends the Great Wall of China against a horde of monstrous creatures.
## 90 In a last-ditch effort to stop a diabolical plot, a dead CIA operative's memories, secrets, and skills are implanted into a death-row inmate in hopes that he will complete the operative's mission.
## 91 In the forests of the Pacific Northwest, a father devoted to raising his six kids with a rigorous physical and intellectual education is forced to leave his paradise and enter the world, challenging his idea of what it means to be a parent.
## 92 In a city of humanoid animals, a hustling theater impresario's attempt to save his theater with a singing competition becomes grander than he anticipates even as its finalists find that their lives will never be the same.
## 93 A wisecracking mercenary gets experimented on and becomes immortal but ugly, and sets out to track down the man who ruined his looks.
## 94 In Ancient Polynesia, when a terrible curse incurred by the Demigod Maui reaches Moana's island, she answers the Ocean's call to seek out the Demigod to set things right.
## 95 Three girls are kidnapped by a man with a diagnosed 23 distinct personalities. They must try to escape before the apparent emergence of a frightful new 24th.
## 96 While on a journey of physical and spiritual healing, a brilliant neurosurgeon is drawn into the world of the mystic arts.
## 97 A wealthy art gallery owner is haunted by her ex-husband's novel, a violent thriller she interprets as a symbolic revenge tale.
## 98 A linguist works with the military to communicate with alien lifeforms after twelve mysterious spacecraft appear around the world.
## 99 In 1970s Los Angeles, a mismatched pair of private eyes investigate a missing girl and the mysterious death of a porn star.
## 100 In a city of anthropomorphic animals, a rookie bunny cop and a cynical con artist fox must work together to uncover a conspiracy.
## 101 A girl in a small town forms an unlikely bond with a recently-paralyzed man she's taking care of.
## 102 A malfunction in a sleeping pod on a spacecraft traveling to a distant colony planet wakes one passenger 90 years early.
## 103 While a zombie virus breaks out in South Korea, passengers struggle to survive on the train from Seoul to Busan.
## 104 Two strangers find themselves linked in a bizarre way. When a connection forms, will distance be the only thing to keep them apart?
## 105 An aspiring model, Jesse, is new to Los Angeles. However, her beauty and youth, which generate intense fascination and jealousy within the fashion industry, may prove themselves sinister.
## 106 A young African-American man grapples with his identity and sexuality while experiencing the everyday struggles of childhood, adolescence, and burgeoning adulthood.
## 107 A successful entrepreneur accused of murder and a witness preparation expert have less than three hours to come up with an impregnable defense.
## 108 A divorcee becomes entangled in a missing persons investigation that promises to send shockwaves throughout her life.
## 109 Tarzan, having acclimated to life in London, is called back to his former home in the jungle to investigate the activities at a mining encampment.
## 110 Loosely based on the true story of two young men, David Packouz and Efraim Diveroli, who won a three hundred million dollar contract from the Pentagon to arm America's allies in Afghanistan.
## 111 A divorced father and his ex-con older brother resort to a desperate scheme in order to save their family's ranch in West Texas.
## 112 After a threat from the tiger Shere Khan forces him to flee the jungle, a man-cub named Mowgli embarks on a journey of self discovery with the help of panther Bagheera and free-spirited bear Baloo.
## 113 A gang of criminals and corrupt cops plan the murder of a police officer in order to pull off their biggest heist yet across town.
## 114 A national manhunt is ordered for a rebellious kid and his foster uncle who go missing in the wild New Zealand bush.
## 115 After getting in a car accident, a woman is held in a shelter by a man who claims that the outside world is affected by a widespread chemical attack.
## 116 The story of Ray Kroc, a salesman who turned two brothers' innovative fast food eatery, McDonald's, into the biggest restaurant business in the world, with a combination of ambition, persistence, and ruthlessness.
## 117 Following a ghost invasion of Manhattan, paranormal enthusiasts Erin Gilbert and Abby Yates, nuclear engineer Jillian Holtzmann, and subway worker Patty Tolan band together to stop the otherworldly threat.
## 118 In a desert dystopia, a young woman is kidnapped by cannibals.
## 119 Four waves of increasingly deadly alien attacks have left most of Earth in ruin. Cassie is on the run, desperately trying to save her younger brother.
## 120 A group of young adults navigate love and relationships in New York City.
## 121 After he reconnects with an awkward pal from high school through Facebook, a mild-mannered accountant is lured into the world of international espionage.
## 122 A five-year-old Indian boy is adopted by an Australian couple after getting lost hundreds of kilometers from home. 25 years later, he sets out to find his lost family.
## 123 Jack Reacher must uncover the truth behind a major government conspiracy in order to clear his name while on the run as a fugitive from the law.
## 124 Alice returns to where the nightmare began: The Hive in Raccoon City, where the Umbrella Corporation is gathering its forces for a final strike against the only remaining survivors of the apocalypse.
## 125 Callum Lynch explores the memories of his ancestor Aguilar de Nerha and gains the skills of a Master Assassin, before taking on the secret Templar society.
## 126 A holiday gathering threatens to go off the rails when Ned Fleming realizes that his daughter's Silicon Valley millionaire boyfriend is about to pop the question.
## 127 Former Police Sergeant Barnes becomes head of security for Senator Charlie Roan, a Presidential candidate targeted for death on Purge night due to her vow to eliminate the Purge.
## 128 High-school life gets even more unbearable for Nadine when her best friend, Krista, starts dating her older brother.
## 129 A dramatization of the disaster in April 2010, when the offshore drilling rig called the Deepwater Horizon exploded, resulting in the worst oil spill in American history.
## 130 A Hollywood fixer in the 1950s works to keep the studio's stars in line.
## 131 Eric and fellow warrior Sara, raised as members of ice Queen Freya's army, try to conceal their forbidden love as they fight to survive the wicked intentions of both Freya and her sister Ravenna.
## 132 Travis and Gabby first meet as neighbors in a small coastal town and wind up in a relationship that is tested by life's most defining events.
## 133 The Turtles get into another battle with their enemy the Shredder, who has acquired new allies: the mutant thugs Bebop and Rocksteady and the alien being Krang.
## 134 In ancient China, a group of European mercenaries encounters a secret army that maintains and defends the Great Wall of China against a horde of monstrous creatures.
## 135 In a last-ditch effort to stop a diabolical plot, a dead CIA operative's memories, secrets, and skills are implanted into a death-row inmate in hopes that he will complete the operative's mission.
## 136 In the forests of the Pacific Northwest, a father devoted to raising his six kids with a rigorous physical and intellectual education is forced to leave his paradise and enter the world, challenging his idea of what it means to be a parent.
## 137 In a city of humanoid animals, a hustling theater impresario's attempt to save his theater with a singing competition becomes grander than he anticipates even as its finalists find that their lives will never be the same.
## 138 A wisecracking mercenary gets experimented on and becomes immortal but ugly, and sets out to track down the man who ruined his looks.
## 139 In Ancient Polynesia, when a terrible curse incurred by the Demigod Maui reaches Moana's island, she answers the Ocean's call to seek out the Demigod to set things right.
## 140 Three girls are kidnapped by a man with a diagnosed 23 distinct personalities. They must try to escape before the apparent emergence of a frightful new 24th.
## 141 While on a journey of physical and spiritual healing, a brilliant neurosurgeon is drawn into the world of the mystic arts.
## 142 A wealthy art gallery owner is haunted by her ex-husband's novel, a violent thriller she interprets as a symbolic revenge tale.
## 143 A linguist works with the military to communicate with alien lifeforms after twelve mysterious spacecraft appear around the world.
## 144 In 1970s Los Angeles, a mismatched pair of private eyes investigate a missing girl and the mysterious death of a porn star.
## 145 In a city of anthropomorphic animals, a rookie bunny cop and a cynical con artist fox must work together to uncover a conspiracy.
## 146 A girl in a small town forms an unlikely bond with a recently-paralyzed man she's taking care of.
## 147 A malfunction in a sleeping pod on a spacecraft traveling to a distant colony planet wakes one passenger 90 years early.
## 148 While a zombie virus breaks out in South Korea, passengers struggle to survive on the train from Seoul to Busan.
## 149 Two strangers find themselves linked in a bizarre way. When a connection forms, will distance be the only thing to keep them apart?
## 150 An aspiring model, Jesse, is new to Los Angeles. However, her beauty and youth, which generate intense fascination and jealousy within the fashion industry, may prove themselves sinister.
## 151 A young African-American man grapples with his identity and sexuality while experiencing the everyday struggles of childhood, adolescence, and burgeoning adulthood.
## 152 A successful entrepreneur accused of murder and a witness preparation expert have less than three hours to come up with an impregnable defense.
## 153 A divorcee becomes entangled in a missing persons investigation that promises to send shockwaves throughout her life.
## 154 Tarzan, having acclimated to life in London, is called back to his former home in the jungle to investigate the activities at a mining encampment.
## 155 Loosely based on the true story of two young men, David Packouz and Efraim Diveroli, who won a three hundred million dollar contract from the Pentagon to arm America's allies in Afghanistan.
## 156 A divorced father and his ex-con older brother resort to a desperate scheme in order to save their family's ranch in West Texas.
## 157 After a threat from the tiger Shere Khan forces him to flee the jungle, a man-cub named Mowgli embarks on a journey of self discovery with the help of panther Bagheera and free-spirited bear Baloo.
## 158 A gang of criminals and corrupt cops plan the murder of a police officer in order to pull off their biggest heist yet across town.
## 159 A national manhunt is ordered for a rebellious kid and his foster uncle who go missing in the wild New Zealand bush.
## 160 After getting in a car accident, a woman is held in a shelter by a man who claims that the outside world is affected by a widespread chemical attack.
## 161 The story of Ray Kroc, a salesman who turned two brothers' innovative fast food eatery, McDonald's, into the biggest restaurant business in the world, with a combination of ambition, persistence, and ruthlessness.
## 162 Following a ghost invasion of Manhattan, paranormal enthusiasts Erin Gilbert and Abby Yates, nuclear engineer Jillian Holtzmann, and subway worker Patty Tolan band together to stop the otherworldly threat.
## 163 In a desert dystopia, a young woman is kidnapped by cannibals.
## 164 Four waves of increasingly deadly alien attacks have left most of Earth in ruin. Cassie is on the run, desperately trying to save her younger brother.
## 165 A group of young adults navigate love and relationships in New York City.
## 166 After he reconnects with an awkward pal from high school through Facebook, a mild-mannered accountant is lured into the world of international espionage.
## 167 A five-year-old Indian boy is adopted by an Australian couple after getting lost hundreds of kilometers from home. 25 years later, he sets out to find his lost family.
## 168 Jack Reacher must uncover the truth behind a major government conspiracy in order to clear his name while on the run as a fugitive from the law.
## 169 Alice returns to where the nightmare began: The Hive in Raccoon City, where the Umbrella Corporation is gathering its forces for a final strike against the only remaining survivors of the apocalypse.
## 170 Callum Lynch explores the memories of his ancestor Aguilar de Nerha and gains the skills of a Master Assassin, before taking on the secret Templar society.
## 171 A holiday gathering threatens to go off the rails when Ned Fleming realizes that his daughter's Silicon Valley millionaire boyfriend is about to pop the question.
## 172 Former Police Sergeant Barnes becomes head of security for Senator Charlie Roan, a Presidential candidate targeted for death on Purge night due to her vow to eliminate the Purge.
## 173 High-school life gets even more unbearable for Nadine when her best friend, Krista, starts dating her older brother.
## 174 A dramatization of the disaster in April 2010, when the offshore drilling rig called the Deepwater Horizon exploded, resulting in the worst oil spill in American history.
## 175 A Hollywood fixer in the 1950s works to keep the studio's stars in line.
## 176 Eric and fellow warrior Sara, raised as members of ice Queen Freya's army, try to conceal their forbidden love as they fight to survive the wicked intentions of both Freya and her sister Ravenna.
## 177 Travis and Gabby first meet as neighbors in a small coastal town and wind up in a relationship that is tested by life's most defining events.
## 178 The Turtles get into another battle with their enemy the Shredder, who has acquired new allies: the mutant thugs Bebop and Rocksteady and the alien being Krang.
## 179 In ancient China, a group of European mercenaries encounters a secret army that maintains and defends the Great Wall of China against a horde of monstrous creatures.
## 180 In a last-ditch effort to stop a diabolical plot, a dead CIA operative's memories, secrets, and skills are implanted into a death-row inmate in hopes that he will complete the operative's mission.
## Runtime Genre Rating Metascore Votes Gross_Earning_in_Mil
## 1 118 Comedy 7.9 72 199906 5.88
## 2 108 Animation 7.1 59 138652 270.40
## 3 108 Action 8.0 65 928628 363.00
## 4 107 Animation 7.6 81 286605 248.70
## 5 117 Horror 7.3 62 443540 138.20
## 6 115 Action 7.5 72 624236 232.60
## 7 116 Drama 7.5 67 247581 10.64
## 8 116 Drama 7.9 81 618058 100.50
## 9 116 Action 7.4 70 292534 36.26
## 10 108 Animation 8.0 78 448152 341.20
## 11 106 Drama 7.4 51 217739 56.25
## 12 116 Drama 7.0 41 362433 100.00
## 13 118 Action 7.6 72 179096 2.13
## 14 106 Animation 8.4 79 213205 5.02
## 15 117 Horror 6.2 51 87133 1.33
## 16 111 Drama 7.4 99 283257 27.85
## 17 106 Crime 8.1 48 155012 NA
## 18 112 Crime 6.5 96 175005 75.40
## 19 110 Action 6.2 32 167207 126.60
## 20 114 Biography 7.1 88 187313 43.03
## 21 102 Action 7.6 79 210174 26.86
## 22 106 Adventure 7.4 52 263216 364.00
## 23 115 Action 6.3 80 68707 12.63
## 24 101 Adventure 7.9 32 116923 5.20
## 25 103 Action 7.2 66 298740 72.08
## 26 115 Biography 7.2 42 133045 12.79
## 27 117 Action 6.7 62 208608 128.30
## 28 118 Action 5.3 33 27907 0.18
## 29 112 Action 5.2 51 102918 34.92
## 30 110 Comedy 6.1 67 82656 46.84
## 31 107 Action 6.3 81 165028 127.40
## 32 118 Biography 8.0 77 220934 51.74
## 33 118 Action 6.1 23 143244 58.70
## 34 107 Action 5.5 59 86665 26.83
## 35 115 Action 5.7 60 189267 54.65
## 36 111 Comedy 6.2 55 104092 60.32
## 37 108 Action 6.0 49 92261 79.21
## 38 104 Comedy 7.3 77 109112 14.43
## 39 107 Action 7.1 68 156835 61.43
## 40 106 Comedy 6.3 72 126794 30.08
## 41 114 Action 6.1 35 100523 48.39
## 42 111 Drama 6.6 26 36786 18.71
## 43 112 Action 6.0 40 86378 82.05
## 44 103 Action 5.9 42 127704 45.54
## 45 113 Action 6.3 36 61403 14.27
## 46 118 Comedy 7.9 72 199906 5.88
## 47 108 Animation 7.1 59 138652 270.40
## 48 108 Action 8.0 65 928628 363.00
## 49 107 Animation 7.6 81 286605 248.70
## 50 117 Horror 7.3 62 443540 138.20
## 51 115 Action 7.5 72 624236 232.60
## 52 116 Drama 7.5 67 247581 10.64
## 53 116 Drama 7.9 81 618058 100.50
## 54 116 Action 7.4 70 292534 36.26
## 55 108 Animation 8.0 78 448152 341.20
## 56 106 Drama 7.4 51 217739 56.25
## 57 116 Drama 7.0 41 362433 100.00
## 58 118 Action 7.6 72 179096 2.13
## 59 106 Animation 8.4 79 213205 5.02
## 60 117 Horror 6.2 51 87133 1.33
## 61 111 Drama 7.4 99 283257 27.85
## 62 106 Crime 8.1 48 155012 NA
## 63 112 Crime 6.5 96 175005 75.40
## 64 110 Action 6.2 32 167207 126.60
## 65 114 Biography 7.1 88 187313 43.03
## 66 102 Action 7.6 79 210174 26.86
## 67 106 Adventure 7.4 52 263216 364.00
## 68 115 Action 6.3 80 68707 12.63
## 69 101 Adventure 7.9 32 116923 5.20
## 70 103 Action 7.2 66 298740 72.08
## 71 115 Biography 7.2 42 133045 12.79
## 72 117 Action 6.7 62 208608 128.30
## 73 118 Action 5.3 33 27907 0.18
## 74 112 Action 5.2 51 102918 34.92
## 75 110 Comedy 6.1 67 82656 46.84
## 76 107 Action 6.3 81 165028 127.40
## 77 118 Biography 8.0 77 220934 51.74
## 78 118 Action 6.1 23 143244 58.70
## 79 107 Action 5.5 59 86665 26.83
## 80 115 Action 5.7 60 189267 54.65
## 81 111 Comedy 6.2 55 104092 60.32
## 82 108 Action 6.0 49 92261 79.21
## 83 104 Comedy 7.3 77 109112 14.43
## 84 107 Action 7.1 68 156835 61.43
## 85 106 Comedy 6.3 72 126794 30.08
## 86 114 Action 6.1 35 100523 48.39
## 87 111 Drama 6.6 26 36786 18.71
## 88 112 Action 6.0 40 86378 82.05
## 89 103 Action 5.9 42 127704 45.54
## 90 113 Action 6.3 36 61403 14.27
## 91 118 Comedy 7.9 72 199906 5.88
## 92 108 Animation 7.1 59 138652 270.40
## 93 108 Action 8.0 65 928628 363.00
## 94 107 Animation 7.6 81 286605 248.70
## 95 117 Horror 7.3 62 443540 138.20
## 96 115 Action 7.5 72 624236 232.60
## 97 116 Drama 7.5 67 247581 10.64
## 98 116 Drama 7.9 81 618058 100.50
## 99 116 Action 7.4 70 292534 36.26
## 100 108 Animation 8.0 78 448152 341.20
## 101 106 Drama 7.4 51 217739 56.25
## 102 116 Drama 7.0 41 362433 100.00
## 103 118 Action 7.6 72 179096 2.13
## 104 106 Animation 8.4 79 213205 5.02
## 105 117 Horror 6.2 51 87133 1.33
## 106 111 Drama 7.4 99 283257 27.85
## 107 106 Crime 8.1 48 155012 NA
## 108 112 Crime 6.5 96 175005 75.40
## 109 110 Action 6.2 32 167207 126.60
## 110 114 Biography 7.1 88 187313 43.03
## 111 102 Action 7.6 79 210174 26.86
## 112 106 Adventure 7.4 52 263216 364.00
## 113 115 Action 6.3 80 68707 12.63
## 114 101 Adventure 7.9 32 116923 5.20
## 115 103 Action 7.2 66 298740 72.08
## 116 115 Biography 7.2 42 133045 12.79
## 117 117 Action 6.7 62 208608 128.30
## 118 118 Action 5.3 33 27907 0.18
## 119 112 Action 5.2 51 102918 34.92
## 120 110 Comedy 6.1 67 82656 46.84
## 121 107 Action 6.3 81 165028 127.40
## 122 118 Biography 8.0 77 220934 51.74
## 123 118 Action 6.1 23 143244 58.70
## 124 107 Action 5.5 59 86665 26.83
## 125 115 Action 5.7 60 189267 54.65
## 126 111 Comedy 6.2 55 104092 60.32
## 127 108 Action 6.0 49 92261 79.21
## 128 104 Comedy 7.3 77 109112 14.43
## 129 107 Action 7.1 68 156835 61.43
## 130 106 Comedy 6.3 72 126794 30.08
## 131 114 Action 6.1 35 100523 48.39
## 132 111 Drama 6.6 26 36786 18.71
## 133 112 Action 6.0 40 86378 82.05
## 134 103 Action 5.9 42 127704 45.54
## 135 113 Action 6.3 36 61403 14.27
## 136 118 Comedy 7.9 72 199906 5.88
## 137 108 Animation 7.1 59 138652 270.40
## 138 108 Action 8.0 65 928628 363.00
## 139 107 Animation 7.6 81 286605 248.70
## 140 117 Horror 7.3 62 443540 138.20
## 141 115 Action 7.5 72 624236 232.60
## 142 116 Drama 7.5 67 247581 10.64
## 143 116 Drama 7.9 81 618058 100.50
## 144 116 Action 7.4 70 292534 36.26
## 145 108 Animation 8.0 78 448152 341.20
## 146 106 Drama 7.4 51 217739 56.25
## 147 116 Drama 7.0 41 362433 100.00
## 148 118 Action 7.6 72 179096 2.13
## 149 106 Animation 8.4 79 213205 5.02
## 150 117 Horror 6.2 51 87133 1.33
## 151 111 Drama 7.4 99 283257 27.85
## 152 106 Crime 8.1 48 155012 NA
## 153 112 Crime 6.5 96 175005 75.40
## 154 110 Action 6.2 32 167207 126.60
## 155 114 Biography 7.1 88 187313 43.03
## 156 102 Action 7.6 79 210174 26.86
## 157 106 Adventure 7.4 52 263216 364.00
## 158 115 Action 6.3 80 68707 12.63
## 159 101 Adventure 7.9 32 116923 5.20
## 160 103 Action 7.2 66 298740 72.08
## 161 115 Biography 7.2 42 133045 12.79
## 162 117 Action 6.7 62 208608 128.30
## 163 118 Action 5.3 33 27907 0.18
## 164 112 Action 5.2 51 102918 34.92
## 165 110 Comedy 6.1 67 82656 46.84
## 166 107 Action 6.3 81 165028 127.40
## 167 118 Biography 8.0 77 220934 51.74
## 168 118 Action 6.1 23 143244 58.70
## 169 107 Action 5.5 59 86665 26.83
## 170 115 Action 5.7 60 189267 54.65
## 171 111 Comedy 6.2 55 104092 60.32
## 172 108 Action 6.0 49 92261 79.21
## 173 104 Comedy 7.3 77 109112 14.43
## 174 107 Action 7.1 68 156835 61.43
## 175 106 Comedy 6.3 72 126794 30.08
## 176 114 Action 6.1 35 100523 48.39
## 177 111 Drama 6.6 26 36786 18.71
## 178 112 Action 6.0 40 86378 82.05
## 179 103 Action 5.9 42 127704 45.54
## 180 113 Action 6.3 36 61403 14.27
## Director Actor
## 1 Matt Ross Margot Robbie
## 2 Garth Jennings Viola Davis
## 3 Tim Miller Vera Farmiga
## 4 Ron Clements Madison Wolfe
## 5 M. Night Shyamalan Frances O'Connor
## 6 Scott Derrickson George MacKay
## 7 Tom Ford Samantha Isler
## 8 Denis Villeneuve Annalise Basso
## 9 Shane Black Scarlett Johansson
## 10 Byron Howard Ryan Reynolds
## 11 Thea Sharrock Morena Baccarin
## 12 Morten Tyldum Ed Skrein
## 13 Sang-ho Yeon Octavia Spencer
## 14 Makoto Shinkai Dwayne Johnson
## 15 Nicolas Winding Refn Anya Taylor-Joy
## 16 Barry Jenkins Denzel Washington
## 17 Oriol Paulo Chris Pratt
## 18 Tate Taylor Ethan Hawke
## 19 David Yates Chiwetel Ejiofor
## 20 Todd Phillips Benedict Wong
## 21 David Mackenzie Amy Adams
## 22 Jon Favreau Michael Shannon
## 23 John Hillcoat Aaron Taylor-Johnson
## 24 Taika Waititi Scarlett Johansson
## 25 Dan Trachtenberg Andrew Garfield
## 26 John Lee Hancock Sam Worthington
## 27 Paul Feig Teresa Palmer
## 28 Ana Lily Amirpour Ryan Gosling
## 29 J Blakeson Emma Stone
## 30 Christian Ditter Rosemarie DeWitt
## 31 Rawson Marshall Thurber Russell Crowe
## 32 Garth Davis Ginnifer Goodwin
## 33 Edward Zwick Sam Claflin
## 34 Paul W.S. Anderson Janet McTeer
## 35 Justin Kurzel Henry Cavill
## 36 John Hamburg Michael Sheen
## 37 James DeMonaco Laurence Fishburne
## 38 Kelly Fremon Craig Cho Jin-woong
## 39 Peter Berg Yu-mi Jung
## 40 Ethan Coen Diego Luna
## 41 Cedric Nicolas-Troyan Donnie Yen
## 42 Ross Katz Chris Pine
## 43 Dave Green Zachary Quinto
## 44 Yimou Zhang Karl Urban
## 45 Ariel Vromen Nikolaj Coster-Waldau
## 46 Matt Ross Ryô Narita
## 47 Garth Jennings Aoi Yûki
## 48 Tim Miller Stephen Lang
## 49 Ron Clements Dylan Minnette
## 50 M. Night Shyamalan Daniel Zovatto
## 51 Scott Derrickson Anna Kendrick
## 52 Tom Ford J.K. Simmons
## 53 Denis Villeneuve Jon Bernthal
## 54 Shane Black Dan Fogler
## 55 Byron Howard Elle Fanning
## 56 Thea Sharrock Christina Hendricks
## 57 Morten Tyldum Karl Glusman
## 58 Sang-ho Yeon Pablo Schreiber
## 59 Makoto Shinkai Michael Fassbender
## 60 Nicolas Winding Refn Naomie Harris
## 61 Barry Jenkins Mario Casas
## 62 Oriol Paulo Ana Wagener
## 63 Tate Taylor Jose Coronado
## 64 David Yates Haley Bennett
## 65 Todd Phillips Justin Theroux
## 66 David Mackenzie Casey Affleck
## 67 Jon Favreau Kyle Chandler
## 68 John Hillcoat Lucas Hedges
## 69 Taika Waititi Christian Stevens
## 70 Dan Trachtenberg Liam Hemsworth
## 71 John Lee Hancock Jeff Goldblum
## 72 Paul Feig Maika Monroe
## 73 Ana Lily Amirpour Jonah Hill
## 74 J Blakeson Miles Teller
## 75 Christian Ditter Steve Lantz
## 76 Rawson Marshall Thurber Chris Pine
## 77 Garth Davis Andrew Garfield
## 78 Edward Zwick Bill Murray
## 79 Paul W.S. Anderson Ben Kingsley
## 80 Justin Kurzel Chiwetel Ejiofor
## 81 John Hamburg Riley Keough
## 82 James DeMonaco McCaul Lombardi
## 83 Kelly Fremon Craig Alicia Vikander
## 84 Peter Berg Aaron Eckhart
## 85 Ethan Coen Ella Rumpf
## 86 Cedric Nicolas-Troyan Laurent Lucas
## 87 Ross Katz Seth Rogen
## 88 Dave Green Kristen Wiig
## 89 Yimou Zhang Jonah Hill
## 90 Ariel Vromen Saori Hayami
## 91 Matt Ross Rima Te Wiata
## 92 Garth Jennings Rachel House
## 93 Tim Miller Travis Fimmel
## 94 Ron Clements Ben Foster
## 95 M. Night Shyamalan Dominic Cooper
## 96 Scott Derrickson Mary Elizabeth Winstead
## 97 Tom Ford John Gallagher Jr.
## 98 Denis Villeneuve Douglas M. Griffin
## 99 Shane Black Linda Cardellini
## 100 Byron Howard Erika Linder
## 101 Thea Sharrock Natalie Krill
## 102 Morten Tyldum Mayko Nguyen
## 103 Sang-ho Yeon Kristen Wiig
## 104 Makoto Shinkai Jason Momoa
## 105 Nicolas Winding Refn Matthew Zuk
## 106 Barry Jenkins Dakota Johnson
## 107 Oriol Paulo Rebel Wilson
## 108 Tate Taylor Leslie Mann
## 109 David Yates Kate Siegel
## 110 Todd Phillips Samantha Sloyan
## 111 David Mackenzie Dwayne Johnson
## 112 Jon Favreau Danielle Nicolet
## 113 John Hillcoat Amy Ryan
## 114 Taika Waititi Gugu Mbatha-Raw
## 115 Dan Trachtenberg Aamir Khan
## 116 John Lee Hancock Sakshi Tanwar
## 117 Paul Feig Sanya Malhotra
## 118 Ana Lily Amirpour Dev Patel
## 119 J Blakeson Nicole Kidman
## 120 Christian Ditter Rooney Mara
## 121 Rawson Marshall Thurber Will Smith
## 122 Garth Davis Ellen DeGeneres
## 123 Edward Zwick Gabriel Bateman
## 124 Paul W.S. Anderson Maria Bello
## 125 Justin Kurzel Shailene Woodley
## 126 John Hamburg Aldis Hodge
## 127 James DeMonaco Robert Knepper
## 128 Kelly Fremon Craig Ali Larter
## 129 Peter Berg Theo James
## 130 Ethan Coen Óscar Jaenada
## 131 Cedric Nicolas-Troyan Joseph Salas
## 132 Ross Katz Michael Fassbender
## 133 Dave Green Marion Cotillard
## 134 Yimou Zhang Jeremy Irons
## 135 Ariel Vromen Mark Ruffalo
## 136 Matt Ross Jared Harris
## 137 Garth Jennings Vincent Ebrahim
## 138 Tim Miller Charlie Hunnam
## 139 Ron Clements Sienna Miller
## 140 M. Night Shyamalan Tom Holland
## 141 Scott Derrickson Felicity Jones
## 142 Tom Ford Irrfan Khan
## 143 Denis Villeneuve Ben Foster
## 144 Shane Black Cedric the Entertainer
## 145 Byron Howard Frank Grillo
## 146 Thea Sharrock Elizabeth Mitchell
## 147 Morten Tyldum Joseph Julian Soria
## 148 Sang-ho Yeon Edgar Ramírez
## 149 Makoto Shinkai Pavel Ruminov
## 150 Nicolas Winding Refn Haley Lu Richardson
## 151 Barry Jenkins Zac Efron
## 152 Oriol Paulo Adam Devine
## 153 Tate Taylor Anna Kendrick
## 154 David Yates Mark Strong
## 155 Todd Phillips Michael Stuhlbarg
## 156 David Mackenzie Mark Wahlberg
## 157 Jon Favreau Douglas M. Griffin
## 158 John Hillcoat James DuMont
## 159 Taika Waititi Mateo Arias
## 160 Dan Trachtenberg Brian Cox
## 161 John Lee Hancock Emile Hirsch
## 162 Paul Feig Michael McElhatton
## 163 Ana Lily Amirpour Josh Brolin
## 164 J Blakeson George Clooney
## 165 Christian Ditter Alden Ehrenreich
## 166 Rawson Marshall Thurber Tom Hanks
## 167 Garth Davis Chris Hemsworth
## 168 Edward Zwick Teresa Palmer
## 169 Paul W.S. Anderson Alexandra Daddario
## 170 Justin Kurzel Will Arnett
## 171 John Hamburg Willem Dafoe
## 172 James DeMonaco Andy Lau
## 173 Kelly Fremon Craig Diego Luna
## 174 Peter Berg Denis Leary
## 175 Ethan Coen Ryan Reynolds
## 176 Cedric Nicolas-Troyan Gary Oldman
## 177 Ross Katz Shailene Woodley
## 178 Dave Green Theo James
## 179 Yimou Zhang Jeff Daniels
## 180 Ariel Vromen Justin Timberlake##find the average gross for each genre
avggross <- movies_df %>%
group_by(Genre) %>%
summarise(average_gross = mean(Gross_Earning_in_Mil, na.rm=TRUE)) %>%
arrange(., -average_gross)
avggross## # A tibble: 8 x 2
## Genre average_gross
## <fct> <dbl>
## 1 Animation 208.
## 2 Adventure 138.
## 3 Action 107.
## 4 Horror 80.6
## 5 Biography 62.4
## 6 Crime 57.3
## 7 Comedy 50.7
## 8 Drama 36.4Animation leads the genres with an average gross of $208.4M.