I’m going to use the jsonlite package to read in the JSON and transform it to a dataframe.
library(jsonlite)Storing the apiKey (hidden) and url:
url <- "https://api.nytimes.com/svc/books/v3/lists/current/hardcover-fiction.json?api-key="
api <- paste(url,apiKey,sep="")Using fromJSON, I read in the data to latest_fiction, and found the book data in the nested list books inside results:
latest_fiction <- fromJSON(api)
df <- as.data.frame(latest_fiction$results$books)
head(df)## rank rank_last_week weeks_on_list asterisk dagger primary_isbn10
## 1 1 0 1 0 0 0385548923
## 2 2 0 1 0 0 0063251922
## 3 3 2 7 0 0 1668002175
## 4 4 1 2 0 0 1538719827
## 5 5 4 5 0 0 059344955X
## 6 6 5 3 0 0 1984818384
## primary_isbn13 publisher
## 1 9780385548922 Doubleday
## 2 9780063251922 Harper
## 3 9781668002179 Scribner
## 4 9781538719824 Grand Central
## 5 9780593449554 Random House
## 6 9781984818386 Ballantine
## description
## 1 Two childhood friends follow in their fathers’ footsteps, which puts them on opposite sides of the law.
## 2 A reimagining of Charles Dickens’s “David Copperfield” set in the mountains of southern Appalachia.
## 3 A high school kid inherits a shed that is a portal to another world where good and evil are at war.
## 4 The seventh book in the Memory Man series. Decker works with a new partner to investigate a double homicide.
## 5 Musicians from different backgrounds are attracted to each other and a mother flees with her son from an abusive husband.
## 6 After returning to her hometown, Olivia McAfee’s son gets accused of killing his crush.
## price title author
## 1 0.00 THE BOYS FROM BILOXI John Grisham
## 2 0.00 DEMON COPPERHEAD Barbara Kingsolver
## 3 0.00 FAIRY TALE Stephen King
## 4 0.00 LONG SHADOWS David Baldacci
## 5 0.00 DREAMLAND Nicholas Sparks
## 6 0.00 MAD HONEY Jodi Picoult and Jennifer Finney Boylan
## contributor contributor_note
## 1 by John Grisham
## 2 by Barbara Kingsolver
## 3 by Stephen King
## 4 by David Baldacci
## 5 by Nicholas Sparks
## 6 by Jodi Picoult and Jennifer Finney Boylan
## book_image
## 1 https://storage.googleapis.com/du-prd/books/images/9780385548922.jpg
## 2 https://storage.googleapis.com/du-prd/books/images/9780063251922.jpg
## 3 https://storage.googleapis.com/du-prd/books/images/9781668002179.jpg
## 4 https://storage.googleapis.com/du-prd/books/images/9781538719824.jpg
## 5 https://storage.googleapis.com/du-prd/books/images/9780593449554.jpg
## 6 https://storage.googleapis.com/du-prd/books/images/9781984818386.jpg
## book_image_width book_image_height
## 1 329 500
## 2 329 500
## 3 329 500
## 4 331 500
## 5 331 500
## 6 328 500
## amazon_product_url age_group
## 1 https://www.amazon.com/dp/0385548923?tag=NYTBSREV-20
## 2 https://www.amazon.com/dp/0063251922?tag=NYTBSREV-20
## 3 https://www.amazon.com/dp/1668002175?tag=NYTBSREV-20
## 4 https://www.amazon.com/dp/1538719827?tag=NYTBSREV-20
## 5 https://www.amazon.com/dp/059344955X?tag=NYTBSREV-20
## 6 https://www.amazon.com/dp/1984818384?tag=NYTBSREV-20
## book_review_link first_chapter_link sunday_review_link article_chapter_link
## 1
## 2
## 3
## 4
## 5
## 6
## isbns
## 1 0385548923, 0385548931, 9780385548922, 9780385548939
## 2 0063251922, 006325199X, 9780063251922, 9780063251991
## 3 , 1668002175, 1668002183, 1797145282, , 9781668002179, 9781668002186, 9781797145280
## 4 1538719827, 1538739763, 1538719819, 1538719797, 9781538719824, 9781538739761, 9781538719817, 9781538719794
## 5 059344955X, 0593449568, 0593633237, 0593633229, 9780593449554, 9780593449561, 9780593633236, 9780593633229
## 6 1984818384, 1984818392, 9781984818386, 9781984818393
## buy_links
## 1 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0385548923?tag=NYTBSREV-20, https://goto.applebooks.apple/9780385548922?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780385548922, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FTHE%252BBOYS%252BFROM%252BBILOXI%252FJohn%252BGrisham%252F9780385548922&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DTHE%252BBOYS%252BFROM%252BBILOXI%252BJohn%252BGrisham, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9780385548922&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DTHE%2BBOYS%2BFROM%2BBILOXI, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9780385548922%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DTHE%2BBOYS%2BFROM%2BBILOXI%2BJohn%2BGrisham%26aff%3DNYT
## 2 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0063251922?tag=NYTBSREV-20, https://goto.applebooks.apple/9780063251922?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780063251922, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FDEMON%252BCOPPERHEAD%252FBarbara%252BKingsolver%252F9780063251922&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DDEMON%252BCOPPERHEAD%252BBarbara%252BKingsolver, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9780063251922&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DDEMON%2BCOPPERHEAD, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9780063251922%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DDEMON%2BCOPPERHEAD%2BBarbara%2BKingsolver%26aff%3DNYT
## 3 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1668002175?tag=NYTBSREV-20, https://goto.applebooks.apple/9781668002179?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781668002179, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FFAIRY%252BTALE%252FStephen%252BKing%252F9781668002179&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DFAIRY%252BTALE%252BStephen%252BKing, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781668002179&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DFAIRY%2BTALE, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781668002179%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DFAIRY%2BTALE%2BStephen%2BKing%26aff%3DNYT
## 4 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1538719827?tag=NYTBSREV-20, https://goto.applebooks.apple/9781538719824?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781538719824, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FLONG%252BSHADOWS%252FDavid%252BBaldacci%252F9781538719824&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DLONG%252BSHADOWS%252BDavid%252BBaldacci, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781538719824&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DLONG%2BSHADOWS, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781538719824%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DLONG%2BSHADOWS%2BDavid%2BBaldacci%26aff%3DNYT
## 5 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/059344955X?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593449554?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593449554, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FDREAMLAND%252FNicholas%252BSparks%252F9780593449554&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DDREAMLAND%252BNicholas%252BSparks, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9780593449554&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DDREAMLAND, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9780593449554%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DDREAMLAND%2BNicholas%2BSparks%26aff%3DNYT
## 6 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1984818384?tag=NYTBSREV-20, https://goto.applebooks.apple/9781984818386?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781984818386, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FMAD%252BHONEY%252FJodi%252BPicoult%252Band%252BJennifer%252BFinney%252BBoylan%252F9781984818386&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DMAD%252BHONEY%252BJodi%252BPicoult%252Band%252BJennifer%252BFinney%252BBoylan, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781984818386&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DMAD%2BHONEY, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781984818386%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DMAD%2BHONEY%2BJodi%2BPicoult%2Band%2BJennifer%2BFinney%2BBoylan%26aff%3DNYT
## book_uri
## 1 nyt://book/b59f42c0-d9d0-5535-bf4b-21e5d04d3a46
## 2 nyt://book/dd6e4f9d-d082-552d-b888-7276a25b5aca
## 3 nyt://book/1c203c2d-147d-5639-8e0c-009ba6f15698
## 4 nyt://book/b14c0c7a-c260-5808-b5db-b72e7a45772f
## 5 nyt://book/61e3a1f0-08db-5240-9ee0-72308b3b9b9d
## 6 nyt://book/8af7bc3e-8c1e-5bb1-820c-06169fac15b1names() in conjunction with view() gives me a starting point to tidy my dataframe for future analysis.
names(df)## [1] "rank" "rank_last_week" "weeks_on_list"
## [4] "asterisk" "dagger" "primary_isbn10"
## [7] "primary_isbn13" "publisher" "description"
## [10] "price" "title" "author"
## [13] "contributor" "contributor_note" "book_image"
## [16] "book_image_width" "book_image_height" "amazon_product_url"
## [19] "age_group" "book_review_link" "first_chapter_link"
## [22] "sunday_review_link" "article_chapter_link" "isbns"
## [25] "buy_links" "book_uri"Previewing a subset of the dataframe:
cols = c(11,12,1:3)
head(df[cols])## title author rank
## 1 THE BOYS FROM BILOXI John Grisham 1
## 2 DEMON COPPERHEAD Barbara Kingsolver 2
## 3 FAIRY TALE Stephen King 3
## 4 LONG SHADOWS David Baldacci 4
## 5 DREAMLAND Nicholas Sparks 5
## 6 MAD HONEY Jodi Picoult and Jennifer Finney Boylan 6
## rank_last_week weeks_on_list
## 1 0 1
## 2 0 1
## 3 2 7
## 4 1 2
## 5 4 5
## 6 5 3