The purpose of the assignment 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.

Load Package

library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr     1.1.0     ✔ readr     2.1.4
## ✔ forcats   1.0.0     ✔ stringr   1.5.0
## ✔ ggplot2   3.4.1     ✔ tibble    3.2.0
## ✔ lubridate 1.9.2     ✔ tidyr     1.3.0
## ✔ purrr     1.0.1     
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## ℹ Use the ]8;;http://conflicted.r-lib.org/conflicted package]8;; to force all conflicts to become errors
library(httr)
library(jsonlite)
## 
## Attaching package: 'jsonlite'
## 
## The following object is masked from 'package:purrr':
## 
##     flatten

Pulling the API

The NYT API will be focusing on the graphic books and manga published by VIZ media, a famous publisher known for japanese manga, and see how many books are in the top-selling list.

#set up base and other paths for API
api_base <- "https://api.nytimes.com/svc/books/v3"
api_book <- "/lists/current/graphic-books-and-manga"
api_key <- ".json?api-key="
my_key <- read.delim("nyt_api_key.txt", header = FALSE) #the API is stored locally
## Warning in read.table(file = file, header = header, sep = sep, quote = quote, :
## incomplete final line found by readTableHeader on 'nyt_api_key.txt'
api_url <- paste0(api_base, api_book, api_key, my_key)

# extract data from api link
raw_api_data <- GET(api_url)

# check status of the API
http_status(raw_api_data)
## $category
## [1] "Success"
## 
## $reason
## [1] "OK"
## 
## $message
## [1] "Success: (200) OK"

Turn raw JSON into a dataframe

#convert json to dataframe
json_book_data <- fromJSON(rawToChar(raw_api_data$content))
book_data <- as.data.frame(json_book_data$results$books)

knitr::kable(book_data)
rank rank_last_week weeks_on_list asterisk dagger primary_isbn10 primary_isbn13 publisher description price title author contributor contributor_note book_image book_image_width book_image_height amazon_product_url age_group book_review_link first_chapter_link sunday_review_link article_chapter_link isbns buy_links book_uri
1 0 0 0 0 1338846620 9781338846621 Scholastic The fourth book in the Cat Kid Comic Club series. After doing their chores, baby frogs work together to create more mini-comics. 0.00 COLLABORATIONS Dav Pilkey by Dav Pilkey https://storage.googleapis.com/du-prd/books/images/9781338846621.jpg 338 500 https://www.amazon.com/dp/1338846620?tag=NYTBSREV-20 1338846620 , 1338846639 , 9781338846621, 9781338846638 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/dp/1338846620?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781338846621?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781338846621 , 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%252FCOLLABORATIONS%252FDav%252BPilkey%252F9781338846621&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DCOLLABORATIONS%252BDav%252BPilkey, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781338846621&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DCOLLABORATIONS , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781338846621%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DCOLLABORATIONS%2BDav%2BPilkey%26aff%3DNYT nyt://book/82b8b5ef-13af-5d86-980b-cd84e69bffe1
2 0 0 0 0 1338730894 9781338730890 Scholastic The sixth book in the Wings of Fire graphic novel series; adapted by Barry Deutsch and Rachel Swirsky. 0.00 MOON RISING Tui T. Sutherland. by Tui T. Sutherland. Illustrated by Mike Holmes Illustrated by Mike Holmes https://storage.googleapis.com/du-prd/books/images/9781338730890.jpg 333 500 https://www.amazon.com/dp/1338730894?tag=NYTBSREV-20 1338730894 , 1338730908 , 9781338730890, 9781338730906 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/dp/1338730894?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781338730890?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781338730890 , 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%252FMOON%252BRISING%252FTui%252BT.%252BSutherland.%252F9781338730890&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DMOON%252BRISING%252BTui%252BT.%252BSutherland., https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781338730890&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DMOON%2BRISING , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781338730890%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DMOON%2BRISING%2BTui%2BT.%2BSutherland.%26aff%3DNYT nyt://book/1ad57511-86a6-5fb2-85c3-02f6a28a04eb
3 0 0 0 0 1974734749 9781974734740 VIZ Media Midoriya goes off on his own to draw the villains away and heroes outside Japan seek to join the fight. 0.00 MY HERO ACADEMIA, VOL. 33 Kohei Horikoshi by Kohei Horikoshi https://storage.googleapis.com/du-prd/books/images/9781974734740.jpg 333 500 https://www.amazon.com/dp/1974734749?tag=NYTBSREV-20 1974734749 , 9781974734740 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/dp/1974734749?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781974734740?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781974734740 , 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%252FMY%252BHERO%252BACADEMIA%25252C%252BVOL.%252B33%252FKohei%252BHorikoshi%252F9781974734740&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DMY%252BHERO%252BACADEMIA%25252C%252BVOL.%252B33%252BKohei%252BHorikoshi, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781974734740&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DMY%2BHERO%2BACADEMIA%252C%2BVOL.%2B33 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781974734740%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DMY%2BHERO%2BACADEMIA%252C%2BVOL.%2B33%2BKohei%2BHorikoshi%26aff%3DNYT nyt://book/720bd038-f775-51e7-b786-1c20bef00439
4 0 0 0 0 1338616102 9781338616101 Scholastic The 13th book in the Baby-sitters Club graphic novel series. Mary Anne receives a bad-luck charm in the mail with instructions to wear it. 0.00 MARY ANNE’S BAD LUCK MYSTERY Ann M. Martin. by Ann M. Martin. Illustrated by Cynthia Yuan Cheng Illustrated by Cynthia Yuan Cheng https://storage.googleapis.com/du-prd/books/images/9781338616101.jpg 344 500 https://www.amazon.com/dp/1338616102?tag=NYTBSREV-20 1338616102 , 133875551X , 1338616110 , 9781338616101, 9781338755510, 9781338616118 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/dp/1338616102?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781338616101?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781338616101 , 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%252FMARY%252BANNE%252527S%252BBAD%252BLUCK%252BMYSTERY%252FAnn%252BM.%252BMartin.%252F9781338616101&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DMARY%252BANNE%252527S%252BBAD%252BLUCK%252BMYSTERY%252BAnn%252BM.%252BMartin., https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781338616101&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DMARY%2BANNE%2527S%2BBAD%2BLUCK%2BMYSTERY , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781338616101%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DMARY%2BANNE%2527S%2BBAD%2BLUCK%2BMYSTERY%2BAnn%2BM.%2BMartin.%26aff%3DNYT nyt://book/3c8b48b0-ff27-5880-bed1-31f146d58c82
5 0 0 0 0 1250793785 9781250793782 First Second The fifth installment of the series that is based on the podcast from the McElroy family. Taako, Magnus and Merle are trapped in a time loop in a small mining town. 0.00 THE ADVENTURE ZONE: THE ELEVENTH HOUR Clint McElroy et al. by Clint McElroy et al. Illustrated by Carey Pietsch Illustrated by Carey Pietsch https://storage.googleapis.com/du-prd/books/images/9781250793782.jpg 333 500 https://www.amazon.com/dp/1250793785?tag=NYTBSREV-20 1250793785 , 1250793793 , 9781250793782, 9781250793799 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/dp/1250793785?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781250793782?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781250793782 , 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%252BADVENTURE%252BZONE%25253A%252BTHE%252BELEVENTH%252BHOUR%252FClint%252BMcElroy%252Bet%252Bal.%252F9781250793782&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DTHE%252BADVENTURE%252BZONE%25253A%252BTHE%252BELEVENTH%252BHOUR%252BClint%252BMcElroy%252Bet%252Bal., https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781250793782&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DTHE%2BADVENTURE%2BZONE%253A%2BTHE%2BELEVENTH%2BHOUR , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781250793782%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DTHE%2BADVENTURE%2BZONE%253A%2BTHE%2BELEVENTH%2BHOUR%2BClint%2BMcElroy%2Bet%2Bal.%26aff%3DNYT nyt://book/9111f2c0-433a-5e0d-be1f-7f7172f49d9c
6 0 0 0 0 1974709930 9781974709939 VIZ Media A poor young man who was betrayed by someone he once trusted discovers he has the power of a devil inside him. 0.00 CHAINSAW MAN, VOL. 1 Tatsuki Fujimoto by Tatsuki Fujimoto https://storage.googleapis.com/du-prd/books/images/9781974709939.jpg 333 499 https://www.amazon.com/Chainsaw-Man-Vol-1/dp/1974709930?tag=NYTBSREV-20 1974709930 , 9781974709939 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/Chainsaw-Man-Vol-1/dp/1974709930?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781974709939?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781974709939 , 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%252FCHAINSAW%252BMAN%25252C%252BVOL.%252B1%252FTatsuki%252BFujimoto%252F9781974709939&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DCHAINSAW%252BMAN%25252C%252BVOL.%252B1%252BTatsuki%252BFujimoto, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781974709939&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DCHAINSAW%2BMAN%252C%2BVOL.%2B1 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781974709939%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DCHAINSAW%2BMAN%252C%2BVOL.%2B1%2BTatsuki%2BFujimoto%26aff%3DNYT nyt://book/873b6d83-f384-519a-9070-6b27e37869e6
7 0 0 0 0 1338762583 9781338762587 Scholastic The sixth book in the Baby-sitters Little Sister graphic novel series. Karen hopes to have one big party to bring the whole family together. 0.00 KAREN’S BIRTHDAY Ann M. Martin. by Ann M. Martin. Illustrated by Katy Farina Illustrated by Katy Farina https://storage.googleapis.com/du-prd/books/images/9781338762587.jpg 333 500 https://www.amazon.com/dp/1338762583?tag=NYTBSREV-20 1338762583 , 1338776614 , 9781338762587, 9781338776614 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/dp/1338762583?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781338762587?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781338762587 , 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%252FKAREN%252527S%252BBIRTHDAY%252FAnn%252BM.%252BMartin.%252F9781338762587&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DKAREN%252527S%252BBIRTHDAY%252BAnn%252BM.%252BMartin., https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781338762587&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DKAREN%2527S%2BBIRTHDAY , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781338762587%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DKAREN%2527S%2BBIRTHDAY%2BAnn%2BM.%2BMartin.%26aff%3DNYT nyt://book/1d89a2e0-d78f-5cf6-ad0c-bfec4d023ea3
8 0 0 0 0 1338535625 9781338535624 Scholastic The ninth book in the Dog Man series. After turning in his badge, the canine cop is determined not to just roll over. 0.00 GRIME AND PUNISHMENT Dav Pilkey by Dav Pilkey https://storage.googleapis.com/du-prd/books/images/9781338535624.jpg 338 500 https://www.amazon.com/dp/1338535625?tag=NYTBSREV-20 1338535625 , 1338535633 , 9781338535624, 9781338535631 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/dp/1338535625?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781338535624?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781338535624 , 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%252FGRIME%252BAND%252BPUNISHMENT%252FDav%252BPilkey%252F9781338535624&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DGRIME%252BAND%252BPUNISHMENT%252BDav%252BPilkey, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781338535624&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DGRIME%2BAND%2BPUNISHMENT , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781338535624%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DGRIME%2BAND%2BPUNISHMENT%2BDav%2BPilkey%26aff%3DNYT nyt://book/b0d57bad-c889-5e85-bccd-7ea1f7df7bff
9 0 0 0 0 1974700526 9781974700523 VIZ Media A young charcoal seller must avenge his family by destroying the demon that slaughtered them. 0.00 DEMON SLAYER: KIMETSU NO YAIBA, VOL. 1 Koyoharu Gotouge by Koyoharu Gotouge https://storage.googleapis.com/du-prd/books/images/9781974700523.jpg 333 500 https://www.amazon.com/dp/1974700526?tag=NYTBSREV-20 1974700526 , 1974710610 , 1974729117 , 9781974700523, 9781974710614, 9781974729111 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/dp/1974700526?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781974700523?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781974700523 , 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%252BSLAYER%25253A%252BKIMETSU%252BNO%252BYAIBA%25252C%252BVOL.%252B1%252FKoyoharu%252BGotouge%252F9781974700523&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DDEMON%252BSLAYER%25253A%252BKIMETSU%252BNO%252BYAIBA%25252C%252BVOL.%252B1%252BKoyoharu%252BGotouge, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781974700523&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DDEMON%2BSLAYER%253A%2BKIMETSU%2BNO%2BYAIBA%252C%2BVOL.%2B1 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781974700523%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DDEMON%2BSLAYER%253A%2BKIMETSU%2BNO%2BYAIBA%252C%2BVOL.%2B1%2BKoyoharu%2BGotouge%26aff%3DNYT nyt://book/529da937-7dbe-5d13-ad16-a39fa239791b
10 0 0 0 0 1338680455 9781338680454 Scholastic The 10th book in the Dog Man series. Can the power of love overcome the darkness and despair created by new villains? 0.00 MOTHERING HEIGHTS Dav Pilkey by Dav Pilkey https://storage.googleapis.com/du-prd/books/images/9781338680454.jpg 338 500 https://www.amazon.com/dp/1338680455?tag=NYTBSREV-20 1338680455 , 1338680471 , 1338680463 , 9781338680454, 9781338680478, 9781338680461 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/dp/1338680455?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781338680454?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781338680454 , 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%252FMOTHERING%252BHEIGHTS%252FDav%252BPilkey%252F9781338680454&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DMOTHERING%252BHEIGHTS%252BDav%252BPilkey, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781338680454&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DMOTHERING%2BHEIGHTS , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781338680454%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DMOTHERING%2BHEIGHTS%2BDav%2BPilkey%26aff%3DNYT nyt://book/f5823fce-ef79-5334-b592-3de792fac91d
11 0 0 0 0 1250852560 9781250852564 First Second Cilantro the Chameleon’s first field assignment brings her into close contact with a sheep-led workers’ rights revolt and an alien invasion conspiracy. 0.00 INVESTIGATORS: AGENTS OF S.U.I.T. John Patrick Green and Christopher Hastings. by John Patrick Green and Christopher Hastings. Illustrated by Pat Lewis Illustrated by Pat Lewis https://storage.googleapis.com/du-prd/books/images/9781250852564.jpg 339 500 https://www.amazon.com/dp/1250852560?tag=NYTBSREV-20 , 1250852560 , , 9781250852564 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/dp/1250852560?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781250852564?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781250852564 , 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%252FINVESTIGATORS%25253A%252BAGENTS%252BOF%252BS.U.I.T.%252FJohn%252BPatrick%252BGreen%252Band%252BChristopher%252BHastings.%252F9781250852564&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DINVESTIGATORS%25253A%252BAGENTS%252BOF%252BS.U.I.T.%252BJohn%252BPatrick%252BGreen%252Band%252BChristopher%252BHastings., https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781250852564&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DINVESTIGATORS%253A%2BAGENTS%2BOF%2BS.U.I.T. , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781250852564%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DINVESTIGATORS%253A%2BAGENTS%2BOF%2BS.U.I.T.%2BJohn%2BPatrick%2BGreen%2Band%2BChristopher%2BHastings.%26aff%3DNYT nyt://book/2fd909cd-785a-596d-9535-38198aea6f21
12 0 0 0 0 1646091647 9781646091645 Square Enix When their relationship status is questioned at karaoke, Marin and Wakana focus more on cosplay. 0.00 MY DRESS-UP DARLING 07 Shinichi Fukuda by Shinichi Fukuda https://storage.googleapis.com/du-prd/books/images/9781646091645.jpg 348 500 https://www.amazon.com/dp/1646091647?tag=NYTBSREV-20 1646091647 , 9781646091645 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/dp/1646091647?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781646091645?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781646091645 , 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%252FMY%252BDRESS-UP%252BDARLING%252B07%252FShinichi%252BFukuda%252F9781646091645&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DMY%252BDRESS-UP%252BDARLING%252B07%252BShinichi%252BFukuda, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781646091645&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DMY%2BDRESS-UP%2BDARLING%2B07 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781646091645%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DMY%2BDRESS-UP%2BDARLING%2B07%2BShinichi%2BFukuda%26aff%3DNYT nyt://book/f2cdb315-1f6f-50c2-b818-cbcabc1ce29f
13 0 0 0 0 1338236598 9781338236590 Scholastic The seventh book in the Dog Man series. A new villain has a bone to pick with Dog Man while Petey the Cat starts a new life. 0.00 FOR WHOM THE BALL ROLLS Dav Pilkey by Dav Pilkey https://storage.googleapis.com/du-prd/books/images/9781338236590.jpg 338 500 https://www.amazon.com/dp/1338236598?tag=NYTBSREV-20 1338236598 , 9781338236590 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/dp/1338236598?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781338236590?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781338236590 , 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%252FFOR%252BWHOM%252BTHE%252BBALL%252BROLLS%252FDav%252BPilkey%252F9781338236590&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DFOR%252BWHOM%252BTHE%252BBALL%252BROLLS%252BDav%252BPilkey, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781338236590&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DFOR%2BWHOM%2BTHE%2BBALL%2BROLLS , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781338236590%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DFOR%2BWHOM%2BTHE%2BBALL%2BROLLS%2BDav%2BPilkey%26aff%3DNYT nyt://book/4ba2daae-6658-559b-8a81-bc932033edc9
14 0 0 0 0 1974715469 9781974715466 VIZ Media A master spy must pass himself off as a family man to infiltrate a private school, but his new wife is an assassin and adopted child is a telepath. 0.00 SPY X FAMILY, VOL. 1 Tatsuya Endo by Tatsuya Endo https://storage.googleapis.com/du-prd/books/images/9781974715466.jpg 333 500 https://www.amazon.com/dp/1974715469?tag=NYTBSREV-20 1974715469 , 9781974715466 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/dp/1974715469?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781974715466?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781974715466 , 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%252FSPY%252BX%252BFAMILY%25252C%252BVOL.%252B1%252FTatsuya%252BEndo%252F9781974715466&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DSPY%252BX%252BFAMILY%25252C%252BVOL.%252B1%252BTatsuya%252BEndo, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781974715466&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DSPY%2BX%2BFAMILY%252C%2BVOL.%2B1 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781974715466%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DSPY%2BX%2BFAMILY%252C%2BVOL.%2B1%2BTatsuya%2BEndo%26aff%3DNYT nyt://book/3b0bacbf-992a-5733-97ac-a4e6505267e9
15 0 0 0 0 1338617435 9781338617436 Scholastic Charlie and Nick deal with the ups and downs of high school at the same time they grow closer together. 0.00 HEARTSTOPPER, VOL. 1 Alice Oseman by Alice Oseman https://storage.googleapis.com/du-prd/books/images/9781338617436.jpg 333 500 https://www.amazon.com/dp/1338617435?tag=NYTBSREV-20 1338617435 , 1444951386 , 1338617443 , 9781338617436, 9781444951387, 9781338617443 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/dp/1338617435?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781338617436?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781338617436 , 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%252FHEARTSTOPPER%25252C%252BVOL.%252B1%252FAlice%252BOseman%252F9781338617436&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DHEARTSTOPPER%25252C%252BVOL.%252B1%252BAlice%252BOseman, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781338617436&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DHEARTSTOPPER%252C%2BVOL.%2B1 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781338617436%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DHEARTSTOPPER%252C%2BVOL.%2B1%2BAlice%2BOseman%26aff%3DNYT nyt://book/8ecf7177-0fa5-5ca5-a58f-909dbd99abe7

View only books from the publisher, VIZ media

viz_book_data <- subset(book_data, book_data$publisher == 'VIZ Media', select = c("rank", "publisher", "title", "author", "description"))

knitr::kable(viz_book_data)
rank publisher title author description
3 3 VIZ Media MY HERO ACADEMIA, VOL. 33 Kohei Horikoshi Midoriya goes off on his own to draw the villains away and heroes outside Japan seek to join the fight.
6 6 VIZ Media CHAINSAW MAN, VOL. 1 Tatsuki Fujimoto A poor young man who was betrayed by someone he once trusted discovers he has the power of a devil inside him.
9 9 VIZ Media DEMON SLAYER: KIMETSU NO YAIBA, VOL. 1 Koyoharu Gotouge A young charcoal seller must avenge his family by destroying the demon that slaughtered them.
14 14 VIZ Media SPY X FAMILY, VOL. 1 Tatsuya Endo A master spy must pass himself off as a family man to infiltrate a private school, but his new wife is an assassin and adopted child is a telepath.

Conclusion

In conclusion, APIs can be useful tools in extracting raw json data effectively.