Week 9 Assignment
Nnaemezue Obi-Eyisi
April 2, 2017
Load required libraries
In this Assignment I chose the NYT Movie Reviews API
Let’s construct the interface and load the NY Times Movie Reviews API into R and making it Reproducible
Input your Movie Reviews API url
url <- "https://api.nytimes.com/svc/movies/v2/reviews/search.json"input your Movie Reviews API KEY
API_KEY <- "69fd59fc9cba44bea3e79d6fc6556487"
moviereviews_api_key <- paste0("&api-key=", API_KEY)Input Filter query
#Search query for a keyword
search_term <- "spider"
query <- paste0("?query=",search_term)Create retrieve a data frame from the results of the “Spider” Search in Movie Reviews list
link <- paste0(url, query, moviereviews_api_key)
Movie_Data_frame <- fromJSON(link)Let’s look at the structure and class Movie_Data_frames
class(Movie_Data_frame)## [1] "list"str(Movie_Data_frame)## List of 5
## $ status : chr "OK"
## $ copyright : chr "Copyright (c) 2017 The New York Times Company. All Rights Reserved."
## $ has_more : logi FALSE
## $ num_results: int 12
## $ results :'data.frame': 12 obs. of 11 variables:
## ..$ display_title : chr [1:12] "The Amazing Spider-Man 2" "Big Ass Spider!" "The Amazing Spider-Man" "Louise Bourgeois: The Spider, the Mistress and the Tangerine" ...
## ..$ mpaa_rating : chr [1:12] "PG-13" "PG-13" "PG-13" "Not Rated" ...
## ..$ critics_pick : int [1:12] 0 0 0 0 0 0 1 1 0 0 ...
## ..$ byline : chr [1:12] "MANOHLA DARGIS" "NEIL GENZLINGER" "MANOHLA DARGIS" "NATHAN LEE" ...
## ..$ headline : chr [1:12] "Hey, Evildoers, Here<U+0092>s Webbing in Your Eye""| __truncated__ "Only an Exterminator Can Save the World" "A Teenage Transformation Like No Other" "Portrait of a Haunted Artist Who Befriended Giant Spiders" ...
## ..$ summary_short : chr [1:12] "Peter Parker wrestles with relationship troubles between bouts with the Green Goblin and Gwen Stacy in <U+0093>The Amazing Spider-Man "| __truncated__ "<U+0093>Big Ass Spider!<U+0094>: the title says it all.""| __truncated__ "<U+0093>The Amazing Spider-Man<U+0094> is a resuscitated studio product held aloft by its stars, Andrew Garfield and Emma Stone.""| __truncated__ "This uncommonly elegant and evocative portrait of Louise Bourgeois reveals much about the haunting and haunted master while lea"| __truncated__ ...
## ..$ publication_date: chr [1:12] "2014-05-01" "2013-10-17" "2012-07-02" "2008-06-25" ...
## ..$ opening_date : chr [1:12] "2014-05-02" NA "2012-07-03" "2008-06-25" ...
## ..$ date_updated : chr [1:12] "2016-03-30 07:07:43" "2016-03-30 07:03:19" "2016-03-30 06:53:52" "2016-03-30 07:08:35" ...
## ..$ link :'data.frame': 12 obs. of 3 variables:
## .. ..$ type : chr [1:12] "article" "article" "article" "article" ...
## .. ..$ url : chr [1:12] "http://www.nytimes.com/2014/05/02/movies/andrew-garfield-returns-in-the-amazing-spider-man-2.html" "http://www.nytimes.com/2013/10/18/movies/big-ass-spider-a-horror-comedy-by-mike-mendez.html" "http://www.nytimes.com/2012/07/03/movies/review-the-amazing-spider-man-with-andrew-garfield.html" "http://www.nytimes.com/2008/06/25/movies/25loui.html" ...
## .. ..$ suggested_link_text: chr [1:12] "Read the New York Times Review of The Amazing Spider-Man 2" "Read the New York Times Review of Big Ass Spider!" "Read the New York Times Review of The Amazing Spider-Man" "Read the New York Times Review of Louise Bourgeois: The Spider, the Mistress and the Tangerine" ...
## ..$ multimedia :'data.frame': 12 obs. of 4 variables:
## .. ..$ type : chr [1:12] "mediumThreeByTwo210" "mediumThreeByTwo210" NA NA ...
## .. ..$ src : chr [1:12] "https://static01.nyt.com/images/2014/05/02/arts/02SPIDERMAN/02SPIDERMAN-mediumThreeByTwo210.jpg" "https://static01.nyt.com/images/2013/10/18/arts/18RDP_BIGSPIDER_SPAN/SPIDER-mediumThreeByTwo210.jpg" NA NA ...
## .. ..$ width : int [1:12] 210 210 NA NA NA NA NA NA NA NA ...
## .. ..$ height: int [1:12] 140 140 NA NA NA NA NA NA NA NA ...Movie Reviews Results Dataframe
Movie_Data_frame$results## display_title
## 1 The Amazing Spider-Man 2
## 2 Big Ass Spider!
## 3 The Amazing Spider-Man
## 4 Louise Bourgeois: The Spider, the Mistress and the Tangerine
## 5 The Spiderwick Chronicles
## 6 Spider-Man 3
## 7 Spider-Man 2
## 8 Spider
## 9 Ziggy Stardust and the Spiders From Mars
## 10 Spider-Man
## 11 Along Came A Spider
## 12 Kiss of the Spider Woman
## mpaa_rating critics_pick byline
## 1 PG-13 0 MANOHLA DARGIS
## 2 PG-13 0 NEIL GENZLINGER
## 3 PG-13 0 MANOHLA DARGIS
## 4 Not Rated 0 NATHAN LEE
## 5 PG 0 A. O. SCOTT
## 6 PG-13 0 MANOHLA DARGIS
## 7 PG-13 1 A. O. Scott
## 8 R 1 Stephen Holden
## 9 PG 0 Dave Kehr
## 10 PG-13 0 A. O. Scott
## 11 R 0 Elvis Mitchell
## 12 R 1 Janet Maslin
## headline
## 1 Hey, Evildoers, Here<U+0092>s Webbing in Your Eye
## 2 Only an Exterminator Can Save the World
## 3 A Teenage Transformation Like No Other
## 4 Portrait of a Haunted Artist Who Befriended Giant Spiders
## 5 A House Divided by Old Magic and New Residents
## 6 Superhero Sandbagged
## 7 Putting Action After Feelings of a Superhero
## 8 Spider (Movie)
## 9 Ziggy Stardust and Spiders From Mars (Show)
## 10 Spider-Man (Movie)
## 11 Along Came a Spider (Movie)
## 12 KISS OF THE SPIDER WOMAN (MOVIE)
## summary_short
## 1 Peter Parker wrestles with relationship troubles between bouts with the Green Goblin and Gwen Stacy in <U+0093>The Amazing Spider-Man 2,<U+0094> which introduces Jamie Foxx as the villain Electro.
## 2 <U+0093>Big Ass Spider!<U+0094>: the title says it all.
## 3 <U+0093>The Amazing Spider-Man<U+0094> is a resuscitated studio product held aloft by its stars, Andrew Garfield and Emma Stone.
## 4 This uncommonly elegant and evocative portrait of Louise Bourgeois reveals much about the haunting and haunted master while leaving intact the thing you cannot explain.
## 5 Instead of the kind of inspired imaginative synergy that distinguished the <U+0093>Lord of the Rings,<U+0094> <U+0093>The Spiderwick Chronicles<U+0094> feels more like a sloppy, secondhand pander.
## 6 If ever a movie had a case of the blues and the blahs, it<U+0092>s <U+0093>Spider-Man 3,<U+0094> a sequel that is fizzled rather than fizzy.
## 7 This wonderfully vibrant entertainment <U+0097> surely one of the best comic-book movies ever <U+0097> reminds us that being a superhero is not all fun and games. The first hour is a Pop Art chronicle of suffering and indignity, as poor Peter Parker (Tobey Maguire) struggles with the loneliness and frustration of being an anonymous urban crime fighter. His powers are waning, he has lost the respect of the woman he loves, and even Aunt May (Rosemary Harris) seems a little disappointed in him. Meanwhile, a new supervillain, the tragic and terrifying Doc Ock (Mr. Molina), rampages through New York on mechanical arms with minds of their own. There is plenty of noise and color, and some so-so special effects, but the real thrill comes from Sam Raimi's devotion to his hero's complex, conflicted emotional life, and to the melancholy, grown-up love story that develops between Peter and MJ (Kirsten Dunst), who comes into her own as a strong and decisive character, while still fulfilling the traditional comic-book girlfriend duties of screaming, getting kidnapped and being rescued. <U+0097> A. O. Scott
## 8 David Cronenberg's bleak minimalist film, adapted from Patrick McGrath's novel (with a screenplay by the author), crawls into the mind of Dennis Cleg (Ralph Fiennes), a paranoid-schizophrenic man in his 30's who is discharged from a mental hospital into a grim halfway house near where he grew up in East London. The desolate urban environment mirrors the mental condition of a man whose warped memories of a homicide two decades earlier come flooding back as he revisits childhood landmarks. Mr. Fiennes's mumbling, agitated psychotic is an uncompromising portrait of a sad, creepy wreck. Miranda Richardson is equally disturbing in the dual roles of his demure mother and a Cockney tart who personify the mother-whore dichotomy that obsesses Dennis. The recurrent imagery of spider webs, jigsaw puzzles and tangled string adds an extra layer of poetic creepiness. — Stephen Holden\r\n
## 9 The apotheosis of glam rock in the early 1970's was David Bowie's 1972-73 Ziggy Stardust and the Spiders From Mars tour. With boldly stated gender-bending, Mr. Bowie sang in character as Ziggy wearing heavy eye shadow, teased orange hair and costumes that accentuated his slender build and spectacular gams. The final concert of the tour, on July 3, 1973, at the Hammersmith Odeon in the suburbs of London, was filmed by the veteran documentarian D. A. Pennebaker. Though "Ziggy" has circulated since 1983 on the midnight show circuit and was long available on video, it is only now receiving its New York theatrical premiere. It is billed as a "restored version," though the sound is still fuzzy and the image only occasionally rises to the level of murk. But for fans familiar with the material, "Ziggy Stardust" should be a satisfyingly nostalgic experience. — Dave Kehr\r\n
## 10 The most amazing thing about Sam Raimi's franchise-launching adaptation of the 40-year-old Marvel comic book is that its high-tech special effects are overshadowed by witty writing and inventive performances. Tobey Maguire rediscovers the smart, alienated adolescent underneath the superhero's mask, and mocks the heroic crime-fighter conceit without subverting it. Mr. Raimi and the screenwriter David Koepp are masters of pop realism, tossing off easy jokes and corny sentiment with gratifying enthusiasm. The romance between Peter Parker and Mary Jane Watson (Kirsten Dunst) is as ripe as an old Hollywood melodrama, and a minor-key conclusion like something out of Henry James. The cold, thin computer-generated action sequences and a fatigued performance by Willem Dafoe dampen the fun a little, but Mr. Maguire, Ms. Dunst and J. K. Simmons, in an uproarious turn as the irascible tabloid editor J. Jonah Jameson, manage to save the day. <U+0097> A. O. Scott \r\n
## 11 Morgan Freeman plays Dr. Alex Cross, a forensic psychologist who is soon knee deep in a high-profile kidnapping case. An archvillain named Soneji has abducted a senator's daughter from her private school, a crime he is determined to make as big as the Lindbergh case. "Spider" couldn't be better served than it is by Mr. Freeman, whose prickly smarts and silken impatience bring believability to a classless, underdeveloped thriller. Still, he is wasted in this impersonal film. Sadder still, it was directed by Lee Tamahori, whose fresh "Once Were Warriors" was all insolent temperament. Shackled to this by-the-numbers picture, all he can do is keep things in focus. <U+0097> Elvis Mitchell\r\n
## 12 Homosexual film buff and political rebel share prison cell in Latin America. Pungent, original drama. Hurt's Oscar.
## publication_date opening_date date_updated link.type
## 1 2014-05-01 2014-05-02 2016-03-30 07:07:43 article
## 2 2013-10-17 <NA> 2016-03-30 07:03:19 article
## 3 2012-07-02 2012-07-03 2016-03-30 06:53:52 article
## 4 2008-06-25 2008-06-25 2016-03-30 07:08:35 article
## 5 2008-02-14 2008-02-14 2016-03-30 07:03:30 article
## 6 2007-05-04 2007-05-04 2016-03-30 07:17:55 article
## 7 2004-06-29 2004-06-30 2016-03-30 07:28:13 article
## 8 2003-02-28 <NA> 2016-03-30 07:06:01 article
## 9 2002-07-10 <NA> 2016-03-30 06:53:57 article
## 10 2002-05-03 2002-05-03 2016-03-30 06:58:50 article
## 11 2001-04-06 2001-04-06 2016-03-30 06:57:55 article
## 12 1985-07-26 1985-07-26 2016-03-30 06:55:33 article
## link.url
## 1 http://www.nytimes.com/2014/05/02/movies/andrew-garfield-returns-in-the-amazing-spider-man-2.html
## 2 http://www.nytimes.com/2013/10/18/movies/big-ass-spider-a-horror-comedy-by-mike-mendez.html
## 3 http://www.nytimes.com/2012/07/03/movies/review-the-amazing-spider-man-with-andrew-garfield.html
## 4 http://www.nytimes.com/2008/06/25/movies/25loui.html
## 5 http://www.nytimes.com/2008/02/14/movies/14spid.html
## 6 http://www.nytimes.com/2007/05/04/movies/04spid.html
## 7 http://www.nytimes.com/movie/review?res=9901E0DB1438F93AA15755C0A9629C8B63
## 8 http://www.nytimes.com/movie/review?res=9903E5DE123CF93BA15751C0A9659C8B63
## 9 http://www.nytimes.com/movie/review?res=9B00EFD71730F933A25754C0A9649C8B63
## 10 http://www.nytimes.com/movie/review?res=9C03E0DE1331F930A35756C0A9649C8B63
## 11 http://www.nytimes.com/movie/review?res=9A0CEFD7143EF935A35757C0A9679C8B63
## 12 http://www.nytimes.com/movie/review?res=9407E6D81238F935A15754C0A963948260
## link.suggested_link_text
## 1 Read the New York Times Review of The Amazing Spider-Man 2
## 2 Read the New York Times Review of Big Ass Spider!
## 3 Read the New York Times Review of The Amazing Spider-Man
## 4 Read the New York Times Review of Louise Bourgeois: The Spider, the Mistress and the Tangerine
## 5 Read the New York Times Review of The Spiderwick Chronicles
## 6 Read the New York Times Review of Spider-Man 3
## 7 Read the New York Times Review of Spider-Man 2
## 8 Read the New York Times Review of Spider
## 9 Read the New York Times Review of Ziggy Stardust and the Spiders From Mars
## 10 Read the New York Times Review of Spider-Man
## 11 Read the New York Times Review of Along Came A Spider
## 12 Read the New York Times Review of Kiss of the Spider Woman
## multimedia.type
## 1 mediumThreeByTwo210
## 2 mediumThreeByTwo210
## 3 <NA>
## 4 <NA>
## 5 <NA>
## 6 <NA>
## 7 <NA>
## 8 <NA>
## 9 <NA>
## 10 <NA>
## 11 <NA>
## 12 <NA>
## multimedia.src
## 1 https://static01.nyt.com/images/2014/05/02/arts/02SPIDERMAN/02SPIDERMAN-mediumThreeByTwo210.jpg
## 2 https://static01.nyt.com/images/2013/10/18/arts/18RDP_BIGSPIDER_SPAN/SPIDER-mediumThreeByTwo210.jpg
## 3 <NA>
## 4 <NA>
## 5 <NA>
## 6 <NA>
## 7 <NA>
## 8 <NA>
## 9 <NA>
## 10 <NA>
## 11 <NA>
## 12 <NA>
## multimedia.width multimedia.height
## 1 210 140
## 2 210 140
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## 7 NA NA
## 8 NA NA
## 9 NA NA
## 10 NA NA
## 11 NA NA
## 12 NA NAView the link Data frame
Movie_Data_frame$results$link## type
## 1 article
## 2 article
## 3 article
## 4 article
## 5 article
## 6 article
## 7 article
## 8 article
## 9 article
## 10 article
## 11 article
## 12 article
## url
## 1 http://www.nytimes.com/2014/05/02/movies/andrew-garfield-returns-in-the-amazing-spider-man-2.html
## 2 http://www.nytimes.com/2013/10/18/movies/big-ass-spider-a-horror-comedy-by-mike-mendez.html
## 3 http://www.nytimes.com/2012/07/03/movies/review-the-amazing-spider-man-with-andrew-garfield.html
## 4 http://www.nytimes.com/2008/06/25/movies/25loui.html
## 5 http://www.nytimes.com/2008/02/14/movies/14spid.html
## 6 http://www.nytimes.com/2007/05/04/movies/04spid.html
## 7 http://www.nytimes.com/movie/review?res=9901E0DB1438F93AA15755C0A9629C8B63
## 8 http://www.nytimes.com/movie/review?res=9903E5DE123CF93BA15751C0A9659C8B63
## 9 http://www.nytimes.com/movie/review?res=9B00EFD71730F933A25754C0A9649C8B63
## 10 http://www.nytimes.com/movie/review?res=9C03E0DE1331F930A35756C0A9649C8B63
## 11 http://www.nytimes.com/movie/review?res=9A0CEFD7143EF935A35757C0A9679C8B63
## 12 http://www.nytimes.com/movie/review?res=9407E6D81238F935A15754C0A963948260
## suggested_link_text
## 1 Read the New York Times Review of The Amazing Spider-Man 2
## 2 Read the New York Times Review of Big Ass Spider!
## 3 Read the New York Times Review of The Amazing Spider-Man
## 4 Read the New York Times Review of Louise Bourgeois: The Spider, the Mistress and the Tangerine
## 5 Read the New York Times Review of The Spiderwick Chronicles
## 6 Read the New York Times Review of Spider-Man 3
## 7 Read the New York Times Review of Spider-Man 2
## 8 Read the New York Times Review of Spider
## 9 Read the New York Times Review of Ziggy Stardust and the Spiders From Mars
## 10 Read the New York Times Review of Spider-Man
## 11 Read the New York Times Review of Along Came A Spider
## 12 Read the New York Times Review of Kiss of the Spider WomanView the MultiMedia Data frame
Movie_resultsdf <-Movie_Data_frame$results
Movie_resultsdf## display_title
## 1 The Amazing Spider-Man 2
## 2 Big Ass Spider!
## 3 The Amazing Spider-Man
## 4 Louise Bourgeois: The Spider, the Mistress and the Tangerine
## 5 The Spiderwick Chronicles
## 6 Spider-Man 3
## 7 Spider-Man 2
## 8 Spider
## 9 Ziggy Stardust and the Spiders From Mars
## 10 Spider-Man
## 11 Along Came A Spider
## 12 Kiss of the Spider Woman
## mpaa_rating critics_pick byline
## 1 PG-13 0 MANOHLA DARGIS
## 2 PG-13 0 NEIL GENZLINGER
## 3 PG-13 0 MANOHLA DARGIS
## 4 Not Rated 0 NATHAN LEE
## 5 PG 0 A. O. SCOTT
## 6 PG-13 0 MANOHLA DARGIS
## 7 PG-13 1 A. O. Scott
## 8 R 1 Stephen Holden
## 9 PG 0 Dave Kehr
## 10 PG-13 0 A. O. Scott
## 11 R 0 Elvis Mitchell
## 12 R 1 Janet Maslin
## headline
## 1 Hey, Evildoers, Here<U+0092>s Webbing in Your Eye
## 2 Only an Exterminator Can Save the World
## 3 A Teenage Transformation Like No Other
## 4 Portrait of a Haunted Artist Who Befriended Giant Spiders
## 5 A House Divided by Old Magic and New Residents
## 6 Superhero Sandbagged
## 7 Putting Action After Feelings of a Superhero
## 8 Spider (Movie)
## 9 Ziggy Stardust and Spiders From Mars (Show)
## 10 Spider-Man (Movie)
## 11 Along Came a Spider (Movie)
## 12 KISS OF THE SPIDER WOMAN (MOVIE)
## summary_short
## 1 Peter Parker wrestles with relationship troubles between bouts with the Green Goblin and Gwen Stacy in <U+0093>The Amazing Spider-Man 2,<U+0094> which introduces Jamie Foxx as the villain Electro.
## 2 <U+0093>Big Ass Spider!<U+0094>: the title says it all.
## 3 <U+0093>The Amazing Spider-Man<U+0094> is a resuscitated studio product held aloft by its stars, Andrew Garfield and Emma Stone.
## 4 This uncommonly elegant and evocative portrait of Louise Bourgeois reveals much about the haunting and haunted master while leaving intact the thing you cannot explain.
## 5 Instead of the kind of inspired imaginative synergy that distinguished the <U+0093>Lord of the Rings,<U+0094> <U+0093>The Spiderwick Chronicles<U+0094> feels more like a sloppy, secondhand pander.
## 6 If ever a movie had a case of the blues and the blahs, it<U+0092>s <U+0093>Spider-Man 3,<U+0094> a sequel that is fizzled rather than fizzy.
## 7 This wonderfully vibrant entertainment <U+0097> surely one of the best comic-book movies ever <U+0097> reminds us that being a superhero is not all fun and games. The first hour is a Pop Art chronicle of suffering and indignity, as poor Peter Parker (Tobey Maguire) struggles with the loneliness and frustration of being an anonymous urban crime fighter. His powers are waning, he has lost the respect of the woman he loves, and even Aunt May (Rosemary Harris) seems a little disappointed in him. Meanwhile, a new supervillain, the tragic and terrifying Doc Ock (Mr. Molina), rampages through New York on mechanical arms with minds of their own. There is plenty of noise and color, and some so-so special effects, but the real thrill comes from Sam Raimi's devotion to his hero's complex, conflicted emotional life, and to the melancholy, grown-up love story that develops between Peter and MJ (Kirsten Dunst), who comes into her own as a strong and decisive character, while still fulfilling the traditional comic-book girlfriend duties of screaming, getting kidnapped and being rescued. <U+0097> A. O. Scott
## 8 David Cronenberg's bleak minimalist film, adapted from Patrick McGrath's novel (with a screenplay by the author), crawls into the mind of Dennis Cleg (Ralph Fiennes), a paranoid-schizophrenic man in his 30's who is discharged from a mental hospital into a grim halfway house near where he grew up in East London. The desolate urban environment mirrors the mental condition of a man whose warped memories of a homicide two decades earlier come flooding back as he revisits childhood landmarks. Mr. Fiennes's mumbling, agitated psychotic is an uncompromising portrait of a sad, creepy wreck. Miranda Richardson is equally disturbing in the dual roles of his demure mother and a Cockney tart who personify the mother-whore dichotomy that obsesses Dennis. The recurrent imagery of spider webs, jigsaw puzzles and tangled string adds an extra layer of poetic creepiness. — Stephen Holden\r\n
## 9 The apotheosis of glam rock in the early 1970's was David Bowie's 1972-73 Ziggy Stardust and the Spiders From Mars tour. With boldly stated gender-bending, Mr. Bowie sang in character as Ziggy wearing heavy eye shadow, teased orange hair and costumes that accentuated his slender build and spectacular gams. The final concert of the tour, on July 3, 1973, at the Hammersmith Odeon in the suburbs of London, was filmed by the veteran documentarian D. A. Pennebaker. Though "Ziggy" has circulated since 1983 on the midnight show circuit and was long available on video, it is only now receiving its New York theatrical premiere. It is billed as a "restored version," though the sound is still fuzzy and the image only occasionally rises to the level of murk. But for fans familiar with the material, "Ziggy Stardust" should be a satisfyingly nostalgic experience. — Dave Kehr\r\n
## 10 The most amazing thing about Sam Raimi's franchise-launching adaptation of the 40-year-old Marvel comic book is that its high-tech special effects are overshadowed by witty writing and inventive performances. Tobey Maguire rediscovers the smart, alienated adolescent underneath the superhero's mask, and mocks the heroic crime-fighter conceit without subverting it. Mr. Raimi and the screenwriter David Koepp are masters of pop realism, tossing off easy jokes and corny sentiment with gratifying enthusiasm. The romance between Peter Parker and Mary Jane Watson (Kirsten Dunst) is as ripe as an old Hollywood melodrama, and a minor-key conclusion like something out of Henry James. The cold, thin computer-generated action sequences and a fatigued performance by Willem Dafoe dampen the fun a little, but Mr. Maguire, Ms. Dunst and J. K. Simmons, in an uproarious turn as the irascible tabloid editor J. Jonah Jameson, manage to save the day. <U+0097> A. O. Scott \r\n
## 11 Morgan Freeman plays Dr. Alex Cross, a forensic psychologist who is soon knee deep in a high-profile kidnapping case. An archvillain named Soneji has abducted a senator's daughter from her private school, a crime he is determined to make as big as the Lindbergh case. "Spider" couldn't be better served than it is by Mr. Freeman, whose prickly smarts and silken impatience bring believability to a classless, underdeveloped thriller. Still, he is wasted in this impersonal film. Sadder still, it was directed by Lee Tamahori, whose fresh "Once Were Warriors" was all insolent temperament. Shackled to this by-the-numbers picture, all he can do is keep things in focus. <U+0097> Elvis Mitchell\r\n
## 12 Homosexual film buff and political rebel share prison cell in Latin America. Pungent, original drama. Hurt's Oscar.
## publication_date opening_date date_updated link.type
## 1 2014-05-01 2014-05-02 2016-03-30 07:07:43 article
## 2 2013-10-17 <NA> 2016-03-30 07:03:19 article
## 3 2012-07-02 2012-07-03 2016-03-30 06:53:52 article
## 4 2008-06-25 2008-06-25 2016-03-30 07:08:35 article
## 5 2008-02-14 2008-02-14 2016-03-30 07:03:30 article
## 6 2007-05-04 2007-05-04 2016-03-30 07:17:55 article
## 7 2004-06-29 2004-06-30 2016-03-30 07:28:13 article
## 8 2003-02-28 <NA> 2016-03-30 07:06:01 article
## 9 2002-07-10 <NA> 2016-03-30 06:53:57 article
## 10 2002-05-03 2002-05-03 2016-03-30 06:58:50 article
## 11 2001-04-06 2001-04-06 2016-03-30 06:57:55 article
## 12 1985-07-26 1985-07-26 2016-03-30 06:55:33 article
## link.url
## 1 http://www.nytimes.com/2014/05/02/movies/andrew-garfield-returns-in-the-amazing-spider-man-2.html
## 2 http://www.nytimes.com/2013/10/18/movies/big-ass-spider-a-horror-comedy-by-mike-mendez.html
## 3 http://www.nytimes.com/2012/07/03/movies/review-the-amazing-spider-man-with-andrew-garfield.html
## 4 http://www.nytimes.com/2008/06/25/movies/25loui.html
## 5 http://www.nytimes.com/2008/02/14/movies/14spid.html
## 6 http://www.nytimes.com/2007/05/04/movies/04spid.html
## 7 http://www.nytimes.com/movie/review?res=9901E0DB1438F93AA15755C0A9629C8B63
## 8 http://www.nytimes.com/movie/review?res=9903E5DE123CF93BA15751C0A9659C8B63
## 9 http://www.nytimes.com/movie/review?res=9B00EFD71730F933A25754C0A9649C8B63
## 10 http://www.nytimes.com/movie/review?res=9C03E0DE1331F930A35756C0A9649C8B63
## 11 http://www.nytimes.com/movie/review?res=9A0CEFD7143EF935A35757C0A9679C8B63
## 12 http://www.nytimes.com/movie/review?res=9407E6D81238F935A15754C0A963948260
## link.suggested_link_text
## 1 Read the New York Times Review of The Amazing Spider-Man 2
## 2 Read the New York Times Review of Big Ass Spider!
## 3 Read the New York Times Review of The Amazing Spider-Man
## 4 Read the New York Times Review of Louise Bourgeois: The Spider, the Mistress and the Tangerine
## 5 Read the New York Times Review of The Spiderwick Chronicles
## 6 Read the New York Times Review of Spider-Man 3
## 7 Read the New York Times Review of Spider-Man 2
## 8 Read the New York Times Review of Spider
## 9 Read the New York Times Review of Ziggy Stardust and the Spiders From Mars
## 10 Read the New York Times Review of Spider-Man
## 11 Read the New York Times Review of Along Came A Spider
## 12 Read the New York Times Review of Kiss of the Spider Woman
## multimedia.type
## 1 mediumThreeByTwo210
## 2 mediumThreeByTwo210
## 3 <NA>
## 4 <NA>
## 5 <NA>
## 6 <NA>
## 7 <NA>
## 8 <NA>
## 9 <NA>
## 10 <NA>
## 11 <NA>
## 12 <NA>
## multimedia.src
## 1 https://static01.nyt.com/images/2014/05/02/arts/02SPIDERMAN/02SPIDERMAN-mediumThreeByTwo210.jpg
## 2 https://static01.nyt.com/images/2013/10/18/arts/18RDP_BIGSPIDER_SPAN/SPIDER-mediumThreeByTwo210.jpg
## 3 <NA>
## 4 <NA>
## 5 <NA>
## 6 <NA>
## 7 <NA>
## 8 <NA>
## 9 <NA>
## 10 <NA>
## 11 <NA>
## 12 <NA>
## multimedia.width multimedia.height
## 1 210 140
## 2 210 140
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## 7 NA NA
## 8 NA NA
## 9 NA NA
## 10 NA NA
## 11 NA NA
## 12 NA NALets combine the 3 dataframes into one to form a hollistic view of the entire Movie Review dataframe when a keyword “Spider” is searched
Entire_movie_DF <-cbind(Movie_Data_frame$results[,c(-10,-11)],Movie_Data_frame$results$link,Movie_Data_frame$results$multimedia)
Entire_movie_DF## display_title
## 1 The Amazing Spider-Man 2
## 2 Big Ass Spider!
## 3 The Amazing Spider-Man
## 4 Louise Bourgeois: The Spider, the Mistress and the Tangerine
## 5 The Spiderwick Chronicles
## 6 Spider-Man 3
## 7 Spider-Man 2
## 8 Spider
## 9 Ziggy Stardust and the Spiders From Mars
## 10 Spider-Man
## 11 Along Came A Spider
## 12 Kiss of the Spider Woman
## mpaa_rating critics_pick byline
## 1 PG-13 0 MANOHLA DARGIS
## 2 PG-13 0 NEIL GENZLINGER
## 3 PG-13 0 MANOHLA DARGIS
## 4 Not Rated 0 NATHAN LEE
## 5 PG 0 A. O. SCOTT
## 6 PG-13 0 MANOHLA DARGIS
## 7 PG-13 1 A. O. Scott
## 8 R 1 Stephen Holden
## 9 PG 0 Dave Kehr
## 10 PG-13 0 A. O. Scott
## 11 R 0 Elvis Mitchell
## 12 R 1 Janet Maslin
## headline
## 1 Hey, Evildoers, Here<U+0092>s Webbing in Your Eye
## 2 Only an Exterminator Can Save the World
## 3 A Teenage Transformation Like No Other
## 4 Portrait of a Haunted Artist Who Befriended Giant Spiders
## 5 A House Divided by Old Magic and New Residents
## 6 Superhero Sandbagged
## 7 Putting Action After Feelings of a Superhero
## 8 Spider (Movie)
## 9 Ziggy Stardust and Spiders From Mars (Show)
## 10 Spider-Man (Movie)
## 11 Along Came a Spider (Movie)
## 12 KISS OF THE SPIDER WOMAN (MOVIE)
## summary_short
## 1 Peter Parker wrestles with relationship troubles between bouts with the Green Goblin and Gwen Stacy in <U+0093>The Amazing Spider-Man 2,<U+0094> which introduces Jamie Foxx as the villain Electro.
## 2 <U+0093>Big Ass Spider!<U+0094>: the title says it all.
## 3 <U+0093>The Amazing Spider-Man<U+0094> is a resuscitated studio product held aloft by its stars, Andrew Garfield and Emma Stone.
## 4 This uncommonly elegant and evocative portrait of Louise Bourgeois reveals much about the haunting and haunted master while leaving intact the thing you cannot explain.
## 5 Instead of the kind of inspired imaginative synergy that distinguished the <U+0093>Lord of the Rings,<U+0094> <U+0093>The Spiderwick Chronicles<U+0094> feels more like a sloppy, secondhand pander.
## 6 If ever a movie had a case of the blues and the blahs, it<U+0092>s <U+0093>Spider-Man 3,<U+0094> a sequel that is fizzled rather than fizzy.
## 7 This wonderfully vibrant entertainment <U+0097> surely one of the best comic-book movies ever <U+0097> reminds us that being a superhero is not all fun and games. The first hour is a Pop Art chronicle of suffering and indignity, as poor Peter Parker (Tobey Maguire) struggles with the loneliness and frustration of being an anonymous urban crime fighter. His powers are waning, he has lost the respect of the woman he loves, and even Aunt May (Rosemary Harris) seems a little disappointed in him. Meanwhile, a new supervillain, the tragic and terrifying Doc Ock (Mr. Molina), rampages through New York on mechanical arms with minds of their own. There is plenty of noise and color, and some so-so special effects, but the real thrill comes from Sam Raimi's devotion to his hero's complex, conflicted emotional life, and to the melancholy, grown-up love story that develops between Peter and MJ (Kirsten Dunst), who comes into her own as a strong and decisive character, while still fulfilling the traditional comic-book girlfriend duties of screaming, getting kidnapped and being rescued. <U+0097> A. O. Scott
## 8 David Cronenberg's bleak minimalist film, adapted from Patrick McGrath's novel (with a screenplay by the author), crawls into the mind of Dennis Cleg (Ralph Fiennes), a paranoid-schizophrenic man in his 30's who is discharged from a mental hospital into a grim halfway house near where he grew up in East London. The desolate urban environment mirrors the mental condition of a man whose warped memories of a homicide two decades earlier come flooding back as he revisits childhood landmarks. Mr. Fiennes's mumbling, agitated psychotic is an uncompromising portrait of a sad, creepy wreck. Miranda Richardson is equally disturbing in the dual roles of his demure mother and a Cockney tart who personify the mother-whore dichotomy that obsesses Dennis. The recurrent imagery of spider webs, jigsaw puzzles and tangled string adds an extra layer of poetic creepiness. — Stephen Holden\r\n
## 9 The apotheosis of glam rock in the early 1970's was David Bowie's 1972-73 Ziggy Stardust and the Spiders From Mars tour. With boldly stated gender-bending, Mr. Bowie sang in character as Ziggy wearing heavy eye shadow, teased orange hair and costumes that accentuated his slender build and spectacular gams. The final concert of the tour, on July 3, 1973, at the Hammersmith Odeon in the suburbs of London, was filmed by the veteran documentarian D. A. Pennebaker. Though "Ziggy" has circulated since 1983 on the midnight show circuit and was long available on video, it is only now receiving its New York theatrical premiere. It is billed as a "restored version," though the sound is still fuzzy and the image only occasionally rises to the level of murk. But for fans familiar with the material, "Ziggy Stardust" should be a satisfyingly nostalgic experience. — Dave Kehr\r\n
## 10 The most amazing thing about Sam Raimi's franchise-launching adaptation of the 40-year-old Marvel comic book is that its high-tech special effects are overshadowed by witty writing and inventive performances. Tobey Maguire rediscovers the smart, alienated adolescent underneath the superhero's mask, and mocks the heroic crime-fighter conceit without subverting it. Mr. Raimi and the screenwriter David Koepp are masters of pop realism, tossing off easy jokes and corny sentiment with gratifying enthusiasm. The romance between Peter Parker and Mary Jane Watson (Kirsten Dunst) is as ripe as an old Hollywood melodrama, and a minor-key conclusion like something out of Henry James. The cold, thin computer-generated action sequences and a fatigued performance by Willem Dafoe dampen the fun a little, but Mr. Maguire, Ms. Dunst and J. K. Simmons, in an uproarious turn as the irascible tabloid editor J. Jonah Jameson, manage to save the day. <U+0097> A. O. Scott \r\n
## 11 Morgan Freeman plays Dr. Alex Cross, a forensic psychologist who is soon knee deep in a high-profile kidnapping case. An archvillain named Soneji has abducted a senator's daughter from her private school, a crime he is determined to make as big as the Lindbergh case. "Spider" couldn't be better served than it is by Mr. Freeman, whose prickly smarts and silken impatience bring believability to a classless, underdeveloped thriller. Still, he is wasted in this impersonal film. Sadder still, it was directed by Lee Tamahori, whose fresh "Once Were Warriors" was all insolent temperament. Shackled to this by-the-numbers picture, all he can do is keep things in focus. <U+0097> Elvis Mitchell\r\n
## 12 Homosexual film buff and political rebel share prison cell in Latin America. Pungent, original drama. Hurt's Oscar.
## publication_date opening_date date_updated type
## 1 2014-05-01 2014-05-02 2016-03-30 07:07:43 article
## 2 2013-10-17 <NA> 2016-03-30 07:03:19 article
## 3 2012-07-02 2012-07-03 2016-03-30 06:53:52 article
## 4 2008-06-25 2008-06-25 2016-03-30 07:08:35 article
## 5 2008-02-14 2008-02-14 2016-03-30 07:03:30 article
## 6 2007-05-04 2007-05-04 2016-03-30 07:17:55 article
## 7 2004-06-29 2004-06-30 2016-03-30 07:28:13 article
## 8 2003-02-28 <NA> 2016-03-30 07:06:01 article
## 9 2002-07-10 <NA> 2016-03-30 06:53:57 article
## 10 2002-05-03 2002-05-03 2016-03-30 06:58:50 article
## 11 2001-04-06 2001-04-06 2016-03-30 06:57:55 article
## 12 1985-07-26 1985-07-26 2016-03-30 06:55:33 article
## url
## 1 http://www.nytimes.com/2014/05/02/movies/andrew-garfield-returns-in-the-amazing-spider-man-2.html
## 2 http://www.nytimes.com/2013/10/18/movies/big-ass-spider-a-horror-comedy-by-mike-mendez.html
## 3 http://www.nytimes.com/2012/07/03/movies/review-the-amazing-spider-man-with-andrew-garfield.html
## 4 http://www.nytimes.com/2008/06/25/movies/25loui.html
## 5 http://www.nytimes.com/2008/02/14/movies/14spid.html
## 6 http://www.nytimes.com/2007/05/04/movies/04spid.html
## 7 http://www.nytimes.com/movie/review?res=9901E0DB1438F93AA15755C0A9629C8B63
## 8 http://www.nytimes.com/movie/review?res=9903E5DE123CF93BA15751C0A9659C8B63
## 9 http://www.nytimes.com/movie/review?res=9B00EFD71730F933A25754C0A9649C8B63
## 10 http://www.nytimes.com/movie/review?res=9C03E0DE1331F930A35756C0A9649C8B63
## 11 http://www.nytimes.com/movie/review?res=9A0CEFD7143EF935A35757C0A9679C8B63
## 12 http://www.nytimes.com/movie/review?res=9407E6D81238F935A15754C0A963948260
## suggested_link_text
## 1 Read the New York Times Review of The Amazing Spider-Man 2
## 2 Read the New York Times Review of Big Ass Spider!
## 3 Read the New York Times Review of The Amazing Spider-Man
## 4 Read the New York Times Review of Louise Bourgeois: The Spider, the Mistress and the Tangerine
## 5 Read the New York Times Review of The Spiderwick Chronicles
## 6 Read the New York Times Review of Spider-Man 3
## 7 Read the New York Times Review of Spider-Man 2
## 8 Read the New York Times Review of Spider
## 9 Read the New York Times Review of Ziggy Stardust and the Spiders From Mars
## 10 Read the New York Times Review of Spider-Man
## 11 Read the New York Times Review of Along Came A Spider
## 12 Read the New York Times Review of Kiss of the Spider Woman
## type
## 1 mediumThreeByTwo210
## 2 mediumThreeByTwo210
## 3 <NA>
## 4 <NA>
## 5 <NA>
## 6 <NA>
## 7 <NA>
## 8 <NA>
## 9 <NA>
## 10 <NA>
## 11 <NA>
## 12 <NA>
## src
## 1 https://static01.nyt.com/images/2014/05/02/arts/02SPIDERMAN/02SPIDERMAN-mediumThreeByTwo210.jpg
## 2 https://static01.nyt.com/images/2013/10/18/arts/18RDP_BIGSPIDER_SPAN/SPIDER-mediumThreeByTwo210.jpg
## 3 <NA>
## 4 <NA>
## 5 <NA>
## 6 <NA>
## 7 <NA>
## 8 <NA>
## 9 <NA>
## 10 <NA>
## 11 <NA>
## 12 <NA>
## width height
## 1 210 140
## 2 210 140
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## 7 NA NA
## 8 NA NA
## 9 NA NA
## 10 NA NA
## 11 NA NA
## 12 NA NAwhat is the most common Mpaa_rating for “Spider” Movies
Movie_Ratings <- Movie_resultsdf %>%
group_by(mpaa_rating) %>%
summarise(count=n())
table(Movie_resultsdf$mpaa_rating)##
## Not Rated PG PG-13 R
## 1 2 6 3barplot(table(Movie_resultsdf$mpaa_rating))
Let’s try another movie #input your Movie Reviews API KEY
#input API KEY
API_KEY <- "69fd59fc9cba44bea3e79d6fc6556487"
moviereviews_api_key <- paste0("&api-key=", API_KEY)
#input Search term
search_term <- "james+bOnd"
query <- paste0("?query=",search_term)
#input Critics pick
pick <- "Y"
critics <- paste0("?critics-pick=",pick)Create retrieve a data frame from the results of the “James bondr” Search in Movie Reviews list
link2 <- paste0(url, query,critics, moviereviews_api_key)
Movie_Data_frame2 <- fromJSON(link2)
Movie_Data_frame2## $status
## [1] "OK"
##
## $copyright
## [1] "Copyright (c) 2017 The New York Times Company. All Rights Reserved."
##
## $has_more
## [1] FALSE
##
## $num_results
## [1] 0
##
## $results
## list()