Assignment 9

Goal

The New York Times web site provides a rich set of APIs, as described here. You’ll need to start by signing up for an API key. Your task is to choose one of the New York Times APIs, construct an interface in R to read in the JSON data, and transform it into an R DataFrame.

Register for API Key and Retrieve the Data

Read the data having movie reviews of Harry Potter, GOdfather and Jurassic Park from the API.

nyt_key <- "VnkQnIsatF3PkvjPsr78YUYFUtkfIvdz"
url_1 <- "https://api.nytimes.com/svc/movies/v2/reviews/search.json?query=harry%20potter&api-key="

data_1 <- fromJSON (paste0(url_1,nyt_key))

url_2 <- "https://api.nytimes.com/svc/movies/v2/reviews/search.json?query=godfather&api-key="

data_2 <- fromJSON (paste0(url_2,nyt_key))

url_3 <- "https://api.nytimes.com/svc/movies/v2/reviews/search.json?query=jurassic%20park&api-key="

data_3 <- fromJSON (paste0(url_3,nyt_key))

Create DataFrame

Load into 3 data frames

data_1 <- data.frame(data_1)
data_2 <- data.frame(data_2)
data_3 <- data.frame(data_3)

Tidy the data

The 3 dataframes are combined into a single data frame ‘final’. The required coloumns are selected from the dataframe and the columns are renamed.

final <- dplyr::bind_rows(data_1,data_2,data_3)

final <- final %>% select(results.display_title, results.byline, results.headline, results.summary_short, results.publication_date)

names <- c('Title', 'Author', 'Headline', 'Short Summary', 'Date of Publication')

colnames(final) <- names

datatable(final)

Show entries

Search:

	Title	Author	Headline	Short Summary	Date of Publication
1	Harry Potter and the Deathly Hallows: Part 2	MANOHLA DARGIS	Class Dismissed	Childhood ends with tears and howls and swirls of smoke, the shock of mortality and bittersweet smiles in the grave, deeply satisfying final movie in the “Harry Potter” series.	2011-07-13
2	Harry Potter and the Deathly Hallows: Part 1	A. O. SCOTT	Time for Young Wizards to Put Away Childish Things	There is an especially somber and scary coloration to this installment, as Harry Potter faces a perilous grown-up world.	2010-11-18
3	Harry Potter and the Half-Blood Prince	MANOHLA DARGIS	In Latest ‘Harry Potter,’ Rage and Hormones	The latest big-screen iteration of the global “Harry Potter” phenomenon has begun to show signs of stress.	2009-07-14
4	Harry Potter and the Order of the Phoenix	A. O. SCOTT	Hogwarts Under Siege	The latest Harry Potter movie begins with a spot of unpleasantness at the Dursleys and ends with Harry facing down Lord Voldemort.	2007-07-10
5	Harry Potter and the Prisoner of Azkaban	A. O. Scott	An Adolescent Wizard Meets a Grown-Up Moviemaker	Alfonso Cuarón, taking the franchise over from Christopher Columbus, injects this third Potter picture with a shadowy, sensual mood. The look is grainier and grimier, and the themes are a bit darker and more unsettling than in "Sorcerer's Stone" or "Chamber of Secrets." There is less Quidditch and more Snape, which is all to the good, as are the efforts of new cast members like Michael Gambon (taking over for Richard Harris as Albus Dumbledore), Emma Thompson (as a batty divination teacher), David Thewlis (as the latest defense-against-the-dark-arts master) and Gary Oldman, who brings his adaptable villainy to the title role. The film's major weakness, sad to say, is Harry himself. Approaching adolescence, Daniel Radcliffe may also be reaching the limit of his range as an actor; he seems unable to summon the complex, volatile emotions that the story, with its notes of grief and rage amid the usual boarding-school intrigue, demands. Still, Mr. Cuarón breathes some new life — and a new sense of mystery — into a series whose charms are in danger of declining due to over-familiarity. — A. O. Scott	2004-06-03
6	Harry Potter and the Chamber of Secrets	A. O. Scott	Harry Potter and the Chamber of Secrets (Movie)	A little better than the first installment — and a whole lot longer — mostly thanks to improved special effects and a darker, more gripping story. Fans of J.K. Rowling's books are once again more likely to be satisfied than thrilled, since Chris Columbus and the screenwriter Steve Kloves follow her novel, the second in the Harry Potter series, scrupulously. But their adaptation is plodding where the book is swift, and solemnly portentous without enough leavening wit. The highly distinguished grownup cast includes Richard Harris in his final screen role and Kenneth Branagh as a self-adoring teacher. — A. O. Scott	2002-11-15
7	Harry Potter and the Sorcerer's Stone	Elvis Mitchell	Harry Potter and the Sorcerer's Stone (Movie)	This film adaptation of the J. K. Rowling novel opens with a familiar sight to Harry Potter fans: the dry-witted giant Hagrid (Robbie Coltrane) and Professor McGonagall (Maggie Smith) dropping a baby at the Doorstep of Destiny. Years later Harry (Daniel Radcliffe) winds up in Hogwarts, an English boarding school for wizards. While shopping for his magic equipment, Harry comes across the Sorcerer's Stone, a bedeviled jewel whose power affects his first year at the enchanted school. The most highly awaited movie of the year has a dreary, literal-minded competence, following the letter of the law as laid down by the book's author. The film comes across as a covers act by an extremely competent tribute band — not the real thing but an incredible simulation — and there's an audience for this sort of thing. But watching "Harry Potter" is like seeing "Beatlemania" staged in the Hollywood Bowl, where the cheers and screams will drown out whatever's unfolding onstage. – Elvis Mitchell	2001-11-16
8	The Black Godfather	BEN KENIGSBERG	‘The Black Godfather’ Review: The Music Executive Who Made It All Happen	Reginald Hudlin’s documentary about Clarence Avant includes many golden anecdotes.	2019-06-06
9	Square Grouper: The Godfathers of Ganja	RACHEL SALTZ	Adventures in the Drug Trades	“Square Grouper” is a documentary about pot smuggling in South Florida in the 1970s and ’80s.	2011-04-14
10	Tokyo Godfathers	A. O. Scott	Three Down-and-Outs Rescue a Foundling From the Trash	Another marvel from Satoshi Kon, whose first two films, "Perfect Blue" and "Millennium Actress," have already pushed Japanese feature-length animation toward greater realism and wilder fantasy. Loosely based on "3 Godfathers," John Ford's maudlin 1948 western, this movie, a sweet fable of decency amid the down and out, also has echoes of Chaplin and Capra. Three homeless people — an embittered alcoholic, a middle-aged transvestite and a teenage runaway — find an abandoned baby on Christmas Eve. As they try to reunite the foundling with her parents, they revisit their own unhappy lives, and travel through a city rendered with unbelievable precision and tinted with undeniable love. The potentially sticky sentiments of the story are balanced by a crazily inventive narrative and by Mr. Kon's cool, obsessively detailed visual style. At the end, the skyscrapers of Tokyo wriggle and dance to a Japanese-language techno version of Beethoven's "Ode to Joy," which pretty much sums up this indescribable, unforgettable movie. — A. O. Scott	2004-01-16

Showing 1 to 10 of 20 entries

Previous1 2Next

Conclusion

The data was read successfully from API and loaded into dataframes. Necessary tidying was done to the ‘final’ dataframe.