Assignment API 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.
library(httr)
library(ggplot2)
library(knitr)
#http://api.nytimes.com/svc/books/v3/lists/best-sellers/history.json?api-key=47d66eeddfc44542a8790bcba2be6e4c
api_key <- "?api-key=47d66eeddfc44542a8790bcba2be6e4c"
base_url <- "https://api.nytimes.com/svc/books/v3/lists/current/hardcover-fiction.json"
book_output <- fromJSON(paste0(base_url, api_key))
book_output## $status
## [1] "OK"
##
## $copyright
## [1] "Copyright (c) 2017 The New York Times Company. All Rights Reserved."
##
## $num_results
## [1] 15
##
## $last_modified
## [1] "2017-03-31T13:38:02-04:00"
##
## $results
## $results$list_name
## [1] "Hardcover Fiction"
##
## $results$list_name_encoded
## [1] "hardcover-fiction"
##
## $results$bestsellers_date
## [1] "2017-03-25"
##
## $results$published_date
## [1] "2017-04-09"
##
## $results$published_date_description
## [1] "latest"
##
## $results$next_published_date
## [1] ""
##
## $results$previous_published_date
## [1] "2017-04-02"
##
## $results$display_name
## [1] "Hardcover Fiction"
##
## $results$normal_list_ends_at
## [1] 15
##
## $results$updated
## [1] "WEEKLY"
##
## $results$books
## rank rank_last_week weeks_on_list asterisk dagger primary_isbn10
## 1 1 0 1 0 0 0062311158
## 2 2 0 1 0 0 0399176616
## 3 3 0 1 1 0 0553391968
## 4 4 3 7 0 0 039360909X
## 5 5 1 2 0 0 039957560X
## 6 6 0 1 0 0 1501154826
## 7 7 2 3 0 0 110188388X
## 8 8 0 1 0 0 0399576681
## 9 9 4 2 0 0 1501150324
## 10 10 0 1 0 0 1501110802
## 11 11 8 19 0 0 0670026190
## 12 12 7 6 0 0 0812995341
## 13 13 9 3 0 0 0735212171
## 14 14 11 22 0 0 0385541198
## 15 15 5 2 0 0 0062436600
## primary_isbn13 publisher
## 1 9780062311153 Morrow/HarperCollins
## 2 9780399176616 Putnam
## 3 9780553391961 Ballantine
## 4 9780393609097 Norton
## 5 9780399575600 Putnam
## 6 9781501154829 Scribner
## 7 9781101883884 Delacorte
## 8 9780399576683 Putnam
## 9 9781501150326 Gallery Books
## 10 9781501110801 Touchstone
## 11 9780670026197 Viking
## 12 9780812995343 Random House
## 13 9780735212176 Riverhead
## 14 9780385541190 Doubleday
## 15 9780062436603 Harper/HarperCollins
## description
## 1 Penn Cage, now the mayor of Natchez, Miss., investigates the secrets of his family and the South to save his, and his fatherĖs lives in the conclusion to the Natchez Burning trilogy.
## 2 Newly released from prison, Dallas Cates tries to exact revenge on the Wyoming game warden Joe Pickett, who put him there.
## 3 An unlikely relationship is tested.
## 4 A retelling of Norse folklore.
## 5 In 1911, searching for a young actress who has disappeared, the detective Isaac Bell discovers a serial killer.
## 6 A woman from rural China becomes a tea seller and eventually moves to California, where the daughter she gave up for adoption lives.
## 7 A television correspondent investigates damning allegations against the vice president of the United States.
## 8 Doc Ford, a Florida marine biologist and former government agent, investigates a series of killings near Marco Island.
## 9 The F.B.I. special agent Nicholas Drummond and his partner, Michaela Caine, track evil twins who can control the weather.
## 10 Ali Reynolds pursues a man who manipulates the children of suicides into killing themselves in the 15th novel in the series.
## 11 A Russian count undergoes 30 years of house arrest.
## 12 Visiting the grave of his recently deceased young son in 1862, Lincoln encounters a cemetery full of ghosts.
## 13 Lovers in a city overwhelmed with violence escape through mysterious doors.
## 14 A whistleblower alerts a Florida investigator to judicial corruption involving the Mob and Indian casinos.
## 15 The psychologist and investigator Maisie Dobbs gets an assignment as World War II begins.
## price title
## 1 0 MISSISSIPPI BLOOD
## 2 0 VICIOUS CIRCLE
## 3 0 IF NOT FOR YOU
## 4 0 NORSE MYTHOLOGY
## 5 0 THE CUTTHROAT
## 6 0 THE TEA GIRL OF HUMMINGBIRD LANE
## 7 0 DANGEROUS GAMES
## 8 0 MANGROVE LIGHTNING
## 9 0 THE DEVIL'S TRIANGLE
## 10 0 MAN OVERBOARD
## 11 0 A GENTLEMAN IN MOSCOW
## 12 0 LINCOLN IN THE BARDO
## 13 0 EXIT WEST
## 14 0 THE WHISTLER
## 15 0 IN THIS GRAVE HOUR
## author
## 1 Greg Iles
## 2 C J Box
## 3 Debbie Macomber
## 4 Neil Gaiman
## 5 Clive Cussler and Justin Scott
## 6 Lisa See
## 7 Danielle Steel
## 8 Randy Wayne White
## 9 Catherine Coulter and J T Ellison
## 10 J A Jance
## 11 Amor Towles
## 12 George Saunders
## 13 Mohsin Hamid
## 14 John Grisham
## 15 Jacqueline Winspear
## contributor contributor_note
## 1 by Greg Iles
## 2 by C. J. Box
## 3 by Debbie Macomber
## 4 by Neil Gaiman
## 5 by Clive Cussler and Justin Scott
## 6 by Lisa See
## 7 by Danielle Steel
## 8 by Randy Wayne White
## 9 by Catherine Coulter and J. T. Ellison
## 10 by J. A. Jance
## 11 by Amor Towles
## 12 by George Saunders
## 13 by Mohsin Hamid
## 14 by John Grisham
## 15 by Jacqueline Winspear
## book_image book_image_width
## 1 https://s1.nyt.com/du/books/images/9780062311191.jpg 328
## 2 https://s1.nyt.com/du/books/images/9780698410077.jpg 328
## 3 https://s1.nyt.com/du/books/images/9780553391978.jpg 328
## 4 https://s1.nyt.com/du/books/images/9780393609097.jpg 328
## 5 https://s1.nyt.com/du/books/images/9780399575617.jpg 328
## 6 https://s1.nyt.com/du/books/images/9781501154829.jpg 328
## 7 https://s1.nyt.com/du/books/images/9781101883884.jpg 325
## 8 https://s1.nyt.com/du/books/images/9780399576683.jpg 328
## 9 https://s1.nyt.com/du/books/images/9781501150357.jpg 328
## 10 https://s1.nyt.com/du/books/images/9781501110818.jpg 328
## 11 https://s1.nyt.com/du/books/images/9780670026197.jpg 328
## 12 https://s1.nyt.com/du/books/images/9780812995343.jpg 330
## 13 https://s1.nyt.com/du/books/images/9780735212176.jpg 329
## 14 https://s1.nyt.com/du/books/images/9780385541206.jpg 326
## 15 https://s1.nyt.com/du/books/images/9780062436610.jpg 330
## book_image_height
## 1 495
## 2 495
## 3 495
## 4 495
## 5 495
## 6 495
## 7 495
## 8 495
## 9 495
## 10 495
## 11 495
## 12 491
## 13 495
## 14 495
## 15 484
## amazon_product_url
## 1 https://www.amazon.com/Mississippi-Blood-Novel-Natchez-Burning-ebook/dp/B01HXJREHW?tag=thenewyorktim-20
## 2 https://www.amazon.com/Vicious-Circle-Joe-Pickett-Novel-ebook/dp/B01HYUVHIM?tag=thenewyorktim-20
## 3 https://www.amazon.com/If-Not-You-Debbie-Macomber-ebook/dp/B01G0GD14O?tag=thenewyorktim-20
## 4 https://www.amazon.com/Norse-Mythology-Neil-Gaiman/dp/039360909X?tag=thenewyorktim-20
## 5 https://www.amazon.com/Cutthroat-Isaac-Bell-Adventure-ebook/dp/B01HCGYXR0?tag=thenewyorktim-20
## 6 https://www.amazon.com/Tea-Girl-Hummingbird-Lane/dp/1501154826?tag=thenewyorktim-20
## 7 https://www.amazon.com/Dangerous-Games-Novel-Danielle-Steel/dp/110188388X?tag=thenewyorktim-20
## 8 https://www.amazon.com/Mangrove-Lightning-Doc-Ford-Novel/dp/0399576681?tag=thenewyorktim-20
## 9 https://www.amazon.com/Devils-Triangle-Brit-FBI-Book-ebook/dp/B01INMZL00?tag=thenewyorktim-20
## 10 https://www.amazon.com/Man-Overboard-Reynolds-Novel-Book-ebook/dp/B01HMXUSR2?tag=thenewyorktim-20
## 11 http://www.amazon.com/Gentleman-Moscow-Novel-Amor-Towles/dp/0670026190?tag=thenewyorktim-20
## 12 https://www.amazon.com/Lincoln-Bardo-Novel-George-Saunders/dp/0812995341?tag=thenewyorktim-20
## 13 https://www.amazon.com/Exit-West-Novel-Mohsin-Hamid/dp/0735212171?tag=thenewyorktim-20
## 14 https://www.amazon.com/Whistler-John-Grisham-ebook/dp/B01C1LUFFK?tag=thenewyorktim-20
## 15 https://www.amazon.com/This-Grave-Hour-Maisie-Dobbs-ebook/dp/B01HBPQV2W?tag=thenewyorktim-20
## age_group
## 1
## 2
## 3
## 4
## 5
## 6
## 7
## 8
## 9
## 10
## 11
## 12
## 13
## 14
## 15
## book_review_link
## 1
## 2
## 3
## 4
## 5
## 6
## 7
## 8
## 9
## 10
## 11 https://www.nytimes.com/2016/09/25/books/review/amor-towles-gentleman-in-moscow.html
## 12 https://www.nytimes.com/2017/02/09/books/review/lincoln-in-the-bardo-george-saunders.html
## 13 https://www.nytimes.com/2017/03/10/books/review/exit-west-mohsin-hamid.html
## 14 https://www.nytimes.com/2016/11/06/books/review/john-grisham-whistler.html
## 15
## first_chapter_link sunday_review_link article_chapter_link
## 1
## 2
## 3
## 4
## 5
## 6
## 7
## 8
## 9
## 10
## 11
## 12
## 13
## 14
## 15
## isbns
## 1 0062311158, 0062311190, 9780062311153, 9780062311191
## 2 0399176616, 0698410076, 9780399176616, 9780698410077
## 3 0553391968, 0553391976, 1524774626, 9780553391961, 9780553391978, 9781524774622
## 4 039360909X, 0393609103, 9780393609097, 9780393609103
## 5 039957560X, 0399575618, 9780399575600, 9780399575617
## 6 1501154826, 9781501154829
## 7 110188388X, 1101883898, 1524756466, 9781101883884, 9781101883891, 9781524756468
## 8 0399576681, 9780399576683
## 9 1501150324, 1501150359, 9781501150326, 9781501150357
## 10 1501110802, 1501110810, 9781501110801, 9781501110818
## 11 0670026190, 9780670026197
## 12 0812995341, 081299535X, 9780812995343, 9780812995350
## 13 0735212171, 9780735212176
## 14 0385541198, 0385541201, 0385541570, 9780385541190, 9780385541206, 9780385541572
## 15 0062436600, 0062436619, 9780062436603, 9780062436610
## buy_links
## 1 Local Booksellers, Barnes and Noble, Amazon, http://www.indiebound.org/book/9780062311153?aff=NYT, http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780062311153, https://www.amazon.com/Mississippi-Blood-Novel-Natchez-Burning-ebook/dp/B01HXJREHW?tag=thenewyorktim-20
## 2 Local Booksellers, Barnes and Noble, Amazon, http://www.indiebound.org/book/9780399176616?aff=NYT, http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780399176616, https://www.amazon.com/Vicious-Circle-Joe-Pickett-Novel-ebook/dp/B01HYUVHIM?tag=thenewyorktim-20
## 3 Local Booksellers, Barnes and Noble, Amazon, http://www.indiebound.org/book/9780553391961?aff=NYT, http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780553391961, https://www.amazon.com/If-Not-You-Debbie-Macomber-ebook/dp/B01G0GD14O?tag=thenewyorktim-20
## 4 Local Booksellers, Barnes and Noble, Amazon, http://www.indiebound.org/book/9780393609097?aff=NYT, http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780393609097, https://www.amazon.com/Norse-Mythology-Neil-Gaiman/dp/039360909X?tag=thenewyorktim-20
## 5 Local Booksellers, Barnes and Noble, Amazon, http://www.indiebound.org/book/9780399575600?aff=NYT, http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780399575600, https://www.amazon.com/Cutthroat-Isaac-Bell-Adventure-ebook/dp/B01HCGYXR0?tag=thenewyorktim-20
## 6 Local Booksellers, Barnes and Noble, Amazon, http://www.indiebound.org/book/9781501154829?aff=NYT, http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781501154829, https://www.amazon.com/Tea-Girl-Hummingbird-Lane/dp/1501154826?tag=thenewyorktim-20
## 7 Local Booksellers, Barnes and Noble, Amazon, http://www.indiebound.org/book/9781101883884?aff=NYT, http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781101883884, https://www.amazon.com/Dangerous-Games-Novel-Danielle-Steel/dp/110188388X?tag=thenewyorktim-20
## 8 Local Booksellers, Barnes and Noble, Amazon, http://www.indiebound.org/book/9780399576683?aff=NYT, http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780399576683, https://www.amazon.com/Mangrove-Lightning-Doc-Ford-Novel/dp/0399576681?tag=thenewyorktim-20
## 9 Local Booksellers, Barnes and Noble, Amazon, http://www.indiebound.org/book/9781501150326?aff=NYT, http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781501150326, https://www.amazon.com/Devils-Triangle-Brit-FBI-Book-ebook/dp/B01INMZL00?tag=thenewyorktim-20
## 10 Local Booksellers, Barnes and Noble, Amazon, http://www.indiebound.org/book/9781501110801?aff=NYT, http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781501110801, https://www.amazon.com/Man-Overboard-Reynolds-Novel-Book-ebook/dp/B01HMXUSR2?tag=thenewyorktim-20
## 11 Local Booksellers, Barnes and Noble, Amazon, http://www.indiebound.org/book/9780670026197?aff=NYT, http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780670026197, http://www.amazon.com/Gentleman-Moscow-Novel-Amor-Towles/dp/0670026190?tag=thenewyorktim-20
## 12 Local Booksellers, Barnes and Noble, Amazon, http://www.indiebound.org/book/9780812995343?aff=NYT, http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780812995343, https://www.amazon.com/Lincoln-Bardo-Novel-George-Saunders/dp/0812995341?tag=thenewyorktim-20
## 13 Local Booksellers, Barnes and Noble, Amazon, http://www.indiebound.org/book/9780735212176?aff=NYT, http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780735212176, https://www.amazon.com/Exit-West-Novel-Mohsin-Hamid/dp/0735212171?tag=thenewyorktim-20
## 14 Local Booksellers, Barnes and Noble, Amazon, http://www.indiebound.org/book/9780385541190?aff=NYT, http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780385541190, https://www.amazon.com/Whistler-John-Grisham-ebook/dp/B01C1LUFFK?tag=thenewyorktim-20
## 15 Local Booksellers, Barnes and Noble, Amazon, http://www.indiebound.org/book/9780062436603?aff=NYT, http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780062436603, https://www.amazon.com/This-Grave-Hour-Maisie-Dobbs-ebook/dp/B01HBPQV2W?tag=thenewyorktim-20
##
## $results$corrections
## list()