Elina Azrilyan

Week 9 Assignment

Data 607 - Fall 2018

The New York Times web site provides a rich set of APIs, as described here: http://developer.nytimes.com/docs 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 to an R dataframe.

Bestseller Books

The following script pulls the list of 5 best seller books as of published date 1/1/2017:

library(kableExtra)# manipulate table styles
## Warning: package 'dplyr' was built under R version 3.5.1
#Code below is adopted from the following webpage https://cran.r-project.org/web/packages/jsonlite/vignettes/json-apis.html)

API_key <- "&api-key=f361bb0197534003a98e682f6c560185"
url <- "http://api.nytimes.com/svc/books/v3/lists/overview.json?published_date=2017-01-01"
req <- fromJSON(paste0(url, API_key))
bestsellers <- req$results$list
category1 <- bestsellers[[1, "books"]]
kable(subset(category1, select = c("author", "title", "publisher", "description")))%>% kable_styling(bootstrap_options = c("striped", "condensed"))
author title publisher description
John Grisham THE WHISTLER Doubleday A whistleblower alerts a Florida investigator to judicial corruption involving the Mob and Indian casinos.
James Patterson CROSS THE LINE Little, Brown Detective Alex Cross and his wife, Bree, team up to catch a killer causing chaos in Washington, D.C.
Fredrik Backman A MAN CALLED OVE Washington Square A curmudgeon’s gruff exterior masks a generosity of spirit. Originally published in Sweden in 2014.
W Bruce Cameron A DOG’S PURPOSE Forge Books A canine narrator undergoes a series of reincarnations.
James Rollins THE SEVENTH PLAGUE Morrow/HarperCollins The 12th Sigma Force thriller follows a deadly pathogen in Egypt and a Russian assassin in the Arctic.

Critics picks films

The following pulls a list of 20 critics pick movies:

API_key <- "&api-key=f361bb0197534003a98e682f6c560185"
url <- "https://api.nytimes.com/svc/movies/v2/reviews/search.json?critics-pick=Y"
req <- fromJSON(paste0(url, API_key))
topfilms <- req$results
kable(subset(topfilms, select = c("headline", "summary_short", "display_title", "critics_pick")))%>% kable_styling(bootstrap_options = c("striped", "condensed"))
headline summary_short display_title critics_pick
Review: In ‘Burning,’ Love Ignites a Divided World The great South Korean director Lee Chang-dong’s latest involves three characters subsumed by desire and rage. Burning 1
Review: In ‘A Bread Factory,’ Local Artists Face Off Against the World An ambitious, sprawling film about the efforts of a community arts center to survive, “A Bread Factory” is a major new work by a singular American artist. A Bread Factory, Part One 1
Review: In ‘A Bread Factory,’ Local Artists Face Off Against the World An ambitious, sprawling film about the efforts of a community arts center to survive, “A Bread Factory” is a major new work by a singular American artist. A Bread Factory, Part Two 1
Review: ‘Monrovia, Indiana’ Is a Sharp, Lyrical Look at Small-Town America Frederick Wiseman’s visit to Trump country finds that there is more to life than politics, and more to democracy than ideology. Monrovia, Indiana 1
Review: Sniffing Out Guilt in a Strangely Engaging ‘Border’ The film, adapted from a short story by the writer of “Let the Right One In,” follows a security guard with an unusual gift. Border 1
Review: In ‘Shirkers,’ Stolen Footage and Dashed Dreams Sandi Tan’s captivating documentary about the theft of her first movie by a charismatic con man is both mystery and manhunt. Shirkers 1
Review: In ‘Vaya,’ Three Travelers Find Danger in Johannesburg The fate of strangers are darkly intertwined in Akin Omotoso’s electric and empathetic film. Vaya 1
Review: In ‘1985,’ a Young Man Hides a Plague From His Family The film is a moving cinematic sketch of a HIV-infected, closeted gay man living through the height of the AIDS crisis. 1985 1
Review: ‘Life and Nothing More’ Places Family in the Center Antonio Méndez Esparza’s keenly observed indie alludes to many hot-button issues but keeps them largely in the background. Life & Nothing More 1
Review: In ‘Wildlife,’ Passions Run Rampant The film, directed by Paul Dano and starring Carey Mulligan and Jake Gyllenhaal, is a domestic drama both sad and terrifying. Wildlife 1
Review: Bright Young Men Stoop to Scam in ‘Nigerian Prince’ This engaging debut feature film by Faraday Okoro asks if there is an honest way for young people to thrive in a country like today’s Nigeria. Nigerian Prince 1
Review: ‘On Her Shoulders’ Follows Nobel Peace Prize Winner Nadia Murad The documentary spotlights the hope and weariness of Murad, who was held captive by the Islamic State in Northern Iraq. On Her Shoulders 1
Review: ‘The Guilty’ Places a Troubled Police Officer on Hold Gustav Moller’s ingeniously lean thriller builds tension from little more than one police officer, two rooms and a frantic telephone call from a kidnapped woman. The Guilty 1
‘Halloween’ 1978: The Times Finally Reviews a Horror Classic We didn’t review “Halloween” in 1978 because of a newspaper strike. Forty years later, our critic takes a new look at John Carpenter’s masterpiece. Halloween 1
Review: A Restless Spirit Haunts a Family in ‘A Season in France’ Dangerous uncertainty, and a bit of hope, hangs over a family seeking political asylum in Mahamat-Saleh Haroun’s latest feature. A Season in France 1
Review: Melissa McCarthy Is Criminally Good in ‘Can You Ever Forgive Me?’ Marielle Heller directs a true story of literary fraud, set amid the bookstores and gay bars of early ’90s Manhattan. Can You Ever Forgive Me 1
Review: ‘Charm City’ Vividly Captures the Streets of Baltimore Marilyn Ness’s documentary is dedicated to the memory of the more than 1,000 people said to be killed in Baltimore during the film’s making. Charm City 1
Review: Paul Butterfield’s Story Is Told in ‘Horn From the Heart’ A documentary explores the life of the blues musician who was prominent in the 1960s and ’70s. Horn from the Heart: The Paul Butterfield Story 1
Review: ‘Watergate’ Shocks Anew With Its True Tale of Political Scandal Charles Ferguson delivers a comprehensive documentary about the not-so-distant past, with its eye very much on the present. Watergate 1
Review: In ‘Barbara,’ a Fictional Biopic of a French Chanteuse It’s a film of scenes rather than of one unified narrative, but each scene is a showcase for the magnificent talents of its star. Barbara 1