Assigment 9 - Web APIs
Alinzon Simon
2024-10-25
Introduction
In order to resolve this assignment an account was created in The New York Times developer Network in order to generate an API KEY.
The following packages used:
httr2: Handles the API request and response.
jsonlite: Parses JSON data.
purrr: Simplifies list and data frame manipulation (map_dfr).
DT: Display data frames interactively in R Markdown or Shiny.
dplyr: Enables flexible data frame manipulation.
ggplot2: Package for data visualization.
#install.packages("httr2")
#install.packages("jsonlite")
#install.packages("purrr")
library(httr2)
library(jsonlite)
library(purrr)
library(DT)
library(dplyr)
library(ggplot2)Define the API endpoint
To connect to the API, we use the generated API key. For security reasons, the key will not be exposed in this file. By combining the API URL with the API key, we create the full endpoint needed to access the data.
ny_kc <- fromJSON("config/ny_kc.json")
api_endpoint <- gsub(" ", "",paste("https://api.nytimes.com/svc/books/v3/lists/current/hardcover-fiction.json?api-key=",
ny_kc$key_nyt))Create a request object
To create the request, I will use previous variable created api_endpoint
req <- request(api_endpoint)
req## <httr2_request>## GET
## https://api.nytimes.com/svc/books/v3/lists/current/hardcover-fiction.json?api-key=aMLKtTGl9OTDxEvXnHadbiB9jN6ZgZB5## Body: emptyCheck for a Successful Request
When we receive a status code of 200, it indicates that the connection was successful. Although the request and the parsing of the JSON can be combined into one step, I chose to separate them to facilitate the identification of potential validation that can be added.
An alternative method to validate the connection is using
req_retry(), where we can specify the maximum number of
attempts.
connected <-FALSE
# validate connectivity with a max of tries
req |> req_retry(max_tries = 5)## <httr2_request>## GET
## https://api.nytimes.com/svc/books/v3/lists/current/hardcover-fiction.json?api-key=aMLKtTGl9OTDxEvXnHadbiB9jN6ZgZB5## Body: empty## Policies:## • retry_max_tries: 5## • retry_on_failure: FALSEresponse <- req_perform(req)
if (resp_status(response) == 200) {
#Only if we get 200 we will export the data
connected <- TRUE
#details about the connection
print(paste('The connection is Successful :',
response |>
resp_status_desc(),
' Code:',
response |>
resp_status()
))
}else{
print(paste('Failed to retrieve data:',
response |>
resp_status_desc(),
' Code:',
response |>
resp_status()
))
}## [1] "The connection is Successful : OK Code: 200"Parse the Response as JSON
Once the connection is established, the JSON body can be parsed into a variable. An additional step is to validate the content type.
#validate the content type
content_type <- response |> resp_content_type()
print(content_type)## [1] "application/json"if(connected == TRUE){
raw_json_data <- response |> resp_body_json()
}Inspect the JSON Structure
Before starting the conversion of the JSON body, it is advisable to check the structure to understand where the list of objects we want to export is stored.
str(raw_json_data)## List of 5
## $ status : chr "OK"
## $ copyright : chr "Copyright (c) 2024 The New York Times Company. All Rights Reserved."
## $ num_results : int 15
## $ last_modified: chr "2024-10-23T22:05:05-04:00"
## $ results :List of 12
## ..$ list_name : chr "Hardcover Fiction"
## ..$ list_name_encoded : chr "hardcover-fiction"
## ..$ bestsellers_date : chr "2024-10-19"
## ..$ published_date : chr "2024-11-03"
## ..$ published_date_description: chr "latest"
## ..$ next_published_date : chr ""
## ..$ previous_published_date : chr "2024-10-27"
## ..$ display_name : chr "Hardcover Fiction"
## ..$ normal_list_ends_at : int 15
## ..$ updated : chr "WEEKLY"
## ..$ books :List of 15
## .. ..$ :List of 26
## .. .. ..$ rank : int 1
## .. .. ..$ rank_last_week : int 0
## .. .. ..$ weeks_on_list : int 1
## .. .. ..$ asterisk : int 0
## .. .. ..$ dagger : int 0
## .. .. ..$ primary_isbn10 : chr "031656379X"
## .. .. ..$ primary_isbn13 : chr "9780316563796"
## .. .. ..$ publisher : chr "Little, Brown"
## .. .. ..$ description : chr "The sixth book in the Ballard and Bosch series. Bosch’s daughter, Maddie, becomes a new volunteer on the cold case unit."
## .. .. ..$ price : chr "0.00"
## .. .. ..$ title : chr "THE WAITING"
## .. .. ..$ author : chr "Michael Connelly"
## .. .. ..$ contributor : chr "by Michael Connelly"
## .. .. ..$ contributor_note : chr ""
## .. .. ..$ book_image : chr "https://storage.googleapis.com/du-prd/books/images/9780316563796.jpg"
## .. .. ..$ book_image_width : int 323
## .. .. ..$ book_image_height : int 500
## .. .. ..$ amazon_product_url : chr "https://www.amazon.com/dp/031656379X?tag=thenewyorktim-20"
## .. .. ..$ age_group : chr ""
## .. .. ..$ book_review_link : chr ""
## .. .. ..$ first_chapter_link : chr ""
## .. .. ..$ sunday_review_link : chr ""
## .. .. ..$ article_chapter_link: chr ""
## .. .. ..$ isbns :List of 3
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "031656379X"
## .. .. .. .. ..$ isbn13: chr "9780316563796"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0316580791"
## .. .. .. .. ..$ isbn13: chr "9780316580793"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0316563811"
## .. .. .. .. ..$ isbn13: chr "9780316563819"
## .. .. ..$ buy_links :List of 5
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Amazon"
## .. .. .. .. ..$ url : chr "https://www.amazon.com/dp/031656379X?tag=thenewyorktim-20"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Apple Books"
## .. .. .. .. ..$ url : chr "https://goto.applebooks.apple/9780316563796?at=10lIEQ"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Barnes and Noble"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780316563796"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Books-A-Million"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BWAITING%2FMic"| __truncated__
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Bookshop.org"
## .. .. .. .. ..$ url : chr "https://bookshop.org/a/3546/9780316563796"
## .. .. ..$ book_uri : chr "nyt://book/02a9b619-657e-5ed7-a70e-fd8fb9eba9e6"
## .. ..$ :List of 26
## .. .. ..$ rank : int 2
## .. .. ..$ rank_last_week : int 1
## .. .. ..$ weeks_on_list : int 4
## .. .. ..$ asterisk : int 0
## .. .. ..$ dagger : int 0
## .. .. ..$ primary_isbn10 : chr "0593449592"
## .. .. ..$ primary_isbn13 : chr "9780593449592"
## .. .. ..$ publisher : chr "Random House"
## .. .. ..$ description : chr "A man in search of the father he never knew encounters a single mom and rumors circulate of the nearby appearan"| __truncated__
## .. .. ..$ price : chr "0.00"
## .. .. ..$ title : chr "COUNTING MIRACLES"
## .. .. ..$ author : chr "Nicholas Sparks"
## .. .. ..$ contributor : chr "by Nicholas Sparks"
## .. .. ..$ contributor_note : chr ""
## .. .. ..$ book_image : chr "https://storage.googleapis.com/du-prd/books/images/9780593449592.jpg"
## .. .. ..$ book_image_width : int 330
## .. .. ..$ book_image_height : int 500
## .. .. ..$ amazon_product_url : chr "https://www.amazon.com/dp/0593449592?tag=thenewyorktim-20"
## .. .. ..$ age_group : chr ""
## .. .. ..$ book_review_link : chr ""
## .. .. ..$ first_chapter_link : chr ""
## .. .. ..$ sunday_review_link : chr ""
## .. .. ..$ article_chapter_link: chr ""
## .. .. ..$ isbns :List of 2
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593449592"
## .. .. .. .. ..$ isbn13: chr "9780593449592"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593449606"
## .. .. .. .. ..$ isbn13: chr "9780593449608"
## .. .. ..$ buy_links :List of 5
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Amazon"
## .. .. .. .. ..$ url : chr "https://www.amazon.com/dp/0593449592?tag=thenewyorktim-20"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Apple Books"
## .. .. .. .. ..$ url : chr "https://goto.applebooks.apple/9780593449592?at=10lIEQ"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Barnes and Noble"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593449592"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Books-A-Million"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FCOUNTING%2BMIRACLES"| __truncated__
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Bookshop.org"
## .. .. .. .. ..$ url : chr "https://bookshop.org/a/3546/9780593449592"
## .. .. ..$ book_uri : chr "nyt://book/974caeee-6bf0-524c-809c-29bfdd99d65f"
## .. ..$ :List of 26
## .. .. ..$ rank : int 3
## .. .. ..$ rank_last_week : int 4
## .. .. ..$ weeks_on_list : int 37
## .. .. ..$ asterisk : int 0
## .. .. ..$ dagger : int 0
## .. .. ..$ primary_isbn10 : chr "1250178630"
## .. .. ..$ primary_isbn13 : chr "9781250178633"
## .. .. ..$ publisher : chr "St. Martin's"
## .. .. ..$ description : chr "In 1965, a nursing student follows her brother to serve during the Vietnam War and returns to a divided America."
## .. .. ..$ price : chr "0.00"
## .. .. ..$ title : chr "THE WOMEN"
## .. .. ..$ author : chr "Kristin Hannah"
## .. .. ..$ contributor : chr "by Kristin Hannah"
## .. .. ..$ contributor_note : chr ""
## .. .. ..$ book_image : chr "https://storage.googleapis.com/du-prd/books/images/9781250178633.jpg"
## .. .. ..$ book_image_width : int 333
## .. .. ..$ book_image_height : int 500
## .. .. ..$ amazon_product_url : chr "https://www.amazon.com/dp/1250178630?tag=thenewyorktim-20"
## .. .. ..$ age_group : chr ""
## .. .. ..$ book_review_link : chr ""
## .. .. ..$ first_chapter_link : chr ""
## .. .. ..$ sunday_review_link : chr ""
## .. .. ..$ article_chapter_link: chr ""
## .. .. ..$ isbns :List of 2
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "1250178630"
## .. .. .. .. ..$ isbn13: chr "9781250178633"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "1250178657"
## .. .. .. .. ..$ isbn13: chr "9781250178657"
## .. .. ..$ buy_links :List of 5
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Amazon"
## .. .. .. .. ..$ url : chr "https://www.amazon.com/dp/1250178630?tag=thenewyorktim-20"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Apple Books"
## .. .. .. .. ..$ url : chr "https://goto.applebooks.apple/9781250178633?at=10lIEQ"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Barnes and Noble"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781250178633"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Books-A-Million"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BWOMEN%2FKrist"| __truncated__
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Bookshop.org"
## .. .. .. .. ..$ url : chr "https://bookshop.org/a/3546/9781250178633"
## .. .. ..$ book_uri : chr "nyt://book/9ce735af-71cf-5ff3-a367-43ee07e3fdd7"
## .. ..$ :List of 26
## .. .. ..$ rank : int 4
## .. .. ..$ rank_last_week : int 3
## .. .. ..$ weeks_on_list : int 4
## .. .. ..$ asterisk : int 0
## .. .. ..$ dagger : int 0
## .. .. ..$ primary_isbn10 : chr "0374602638"
## .. .. ..$ primary_isbn13 : chr "9780374602635"
## .. .. ..$ publisher : chr "Farrar, Straus and Giroux"
## .. .. ..$ description : chr "After the passing of their father, seemingly different brothers engage in relationships and seek ways to cope."
## .. .. ..$ price : chr "0.00"
## .. .. ..$ title : chr "INTERMEZZO"
## .. .. ..$ author : chr "Sally Rooney"
## .. .. ..$ contributor : chr "by Sally Rooney"
## .. .. ..$ contributor_note : chr ""
## .. .. ..$ book_image : chr "https://storage.googleapis.com/du-prd/books/images/9780374602635.jpg"
## .. .. ..$ book_image_width : int 326
## .. .. ..$ book_image_height : int 500
## .. .. ..$ amazon_product_url : chr "https://www.amazon.com/dp/0374602638?tag=thenewyorktim-20"
## .. .. ..$ age_group : chr ""
## .. .. ..$ book_review_link : chr ""
## .. .. ..$ first_chapter_link : chr ""
## .. .. ..$ sunday_review_link : chr ""
## .. .. ..$ article_chapter_link: chr ""
## .. .. ..$ isbns :List of 2
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0374602638"
## .. .. .. .. ..$ isbn13: chr "9780374602635"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0374602646"
## .. .. .. .. ..$ isbn13: chr "9780374602642"
## .. .. ..$ buy_links :List of 5
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Amazon"
## .. .. .. .. ..$ url : chr "https://www.amazon.com/dp/0374602638?tag=thenewyorktim-20"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Apple Books"
## .. .. .. .. ..$ url : chr "https://goto.applebooks.apple/9780374602635?at=10lIEQ"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Barnes and Noble"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780374602635"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Books-A-Million"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FINTERMEZZO%2FSally%"| __truncated__
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Bookshop.org"
## .. .. .. .. ..$ url : chr "https://bookshop.org/a/3546/9780374602635"
## .. .. ..$ book_uri : chr "nyt://book/a3bcdd05-312a-566b-90ec-df50e894bce6"
## .. ..$ :List of 26
## .. .. ..$ rank : int 5
## .. .. ..$ rank_last_week : int 6
## .. .. ..$ weeks_on_list : int 50
## .. .. ..$ asterisk : int 0
## .. .. ..$ dagger : int 0
## .. .. ..$ primary_isbn10 : chr "1649374178"
## .. .. ..$ primary_isbn13 : chr "9781649374172"
## .. .. ..$ publisher : chr "Red Tower"
## .. .. ..$ description : chr "The second book in the Empyrean series. Violet Sorrengail’s next round of training might require her to betray "| __truncated__
## .. .. ..$ price : chr "0.00"
## .. .. ..$ title : chr "IRON FLAME"
## .. .. ..$ author : chr "Rebecca Yarros"
## .. .. ..$ contributor : chr "by Rebecca Yarros"
## .. .. ..$ contributor_note : chr ""
## .. .. ..$ book_image : chr "https://storage.googleapis.com/du-prd/books/images/9781649374172.jpg"
## .. .. ..$ book_image_width : int 309
## .. .. ..$ book_image_height : int 500
## .. .. ..$ amazon_product_url : chr "https://www.amazon.com/dp/1649374178?tag=thenewyorktim-20"
## .. .. ..$ age_group : chr ""
## .. .. ..$ book_review_link : chr ""
## .. .. ..$ first_chapter_link : chr ""
## .. .. ..$ sunday_review_link : chr ""
## .. .. ..$ article_chapter_link: chr ""
## .. .. ..$ isbns :List of 2
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "1649374178"
## .. .. .. .. ..$ isbn13: chr "9781649374172"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "1705085083"
## .. .. .. .. ..$ isbn13: chr "9781705085080"
## .. .. ..$ buy_links :List of 5
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Amazon"
## .. .. .. .. ..$ url : chr "https://www.amazon.com/dp/1649374178?tag=thenewyorktim-20"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Apple Books"
## .. .. .. .. ..$ url : chr "https://goto.applebooks.apple/9781649374172?at=10lIEQ"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Barnes and Noble"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374172"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Books-A-Million"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FIRON%2BFLAME%2FRebe"| __truncated__
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Bookshop.org"
## .. .. .. .. ..$ url : chr "https://bookshop.org/a/3546/9781649374172"
## .. .. ..$ book_uri : chr "nyt://book/d3c570c9-3c3a-5c8b-a740-85ea5e92bfc9"
## .. ..$ :List of 26
## .. .. ..$ rank : int 6
## .. .. ..$ rank_last_week : int 2
## .. .. ..$ weeks_on_list : int 2
## .. .. ..$ asterisk : int 0
## .. .. ..$ dagger : int 0
## .. .. ..$ primary_isbn10 : chr "1250355664"
## .. .. ..$ primary_isbn13 : chr "9781250355669"
## .. .. ..$ publisher : chr "Bramble"
## .. .. ..$ description : chr "Astraea must decide whether to sneak in as a substitute in the trials that will determine the safety of her kingdom."
## .. .. ..$ price : chr "0.00"
## .. .. ..$ title : chr "THE STARS ARE DYING"
## .. .. ..$ author : chr "Chloe C. Peñaranda"
## .. .. ..$ contributor : chr "by Chloe C. Peñaranda"
## .. .. ..$ contributor_note : chr ""
## .. .. ..$ book_image : chr "https://storage.googleapis.com/du-prd/books/images/9781250355669.jpg"
## .. .. ..$ book_image_width : int 341
## .. .. ..$ book_image_height : int 500
## .. .. ..$ amazon_product_url : chr "https://www.amazon.com/dp/1250355664?tag=thenewyorktim-20"
## .. .. ..$ age_group : chr ""
## .. .. ..$ book_review_link : chr ""
## .. .. ..$ first_chapter_link : chr ""
## .. .. ..$ sunday_review_link : chr ""
## .. .. ..$ article_chapter_link: chr ""
## .. .. ..$ isbns :List of 2
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "1250355664"
## .. .. .. .. ..$ isbn13: chr "9781250355669"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "1250370442"
## .. .. .. .. ..$ isbn13: chr "9781250370440"
## .. .. ..$ buy_links :List of 5
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Amazon"
## .. .. .. .. ..$ url : chr "https://www.amazon.com/dp/1250355664?tag=thenewyorktim-20"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Apple Books"
## .. .. .. .. ..$ url : chr "https://goto.applebooks.apple/9781250355669?at=10lIEQ"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Barnes and Noble"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781250355669"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Books-A-Million"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BSTARS%2BARE%2"| __truncated__
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Bookshop.org"
## .. .. .. .. ..$ url : chr "https://bookshop.org/a/3546/9781250355669"
## .. .. ..$ book_uri : chr "nyt://book/00d75ee8-72b6-5ca0-a903-a770b5b6901c"
## .. ..$ :List of 26
## .. .. ..$ rank : int 7
## .. .. ..$ rank_last_week : int 0
## .. .. ..$ weeks_on_list : int 1
## .. .. ..$ asterisk : int 0
## .. .. ..$ dagger : int 0
## .. .. ..$ primary_isbn10 : chr "0593817028"
## .. .. ..$ primary_isbn13 : chr "9780593817025"
## .. .. ..$ publisher : chr "Ace"
## .. .. ..$ description : chr "Aspeth Honori joins the Royal Artifactual Guild and partners with a minotaur to save her family."
## .. .. ..$ price : chr "0.00"
## .. .. ..$ title : chr "BULL MOON RISING"
## .. .. ..$ author : chr "Ru Dixon"
## .. .. ..$ contributor : chr "by Ruby Dixon"
## .. .. ..$ contributor_note : chr ""
## .. .. ..$ book_image : chr "https://storage.googleapis.com/du-prd/books/images/9780593817025.jpg"
## .. .. ..$ book_image_width : int 356
## .. .. ..$ book_image_height : int 500
## .. .. ..$ amazon_product_url : chr "https://www.amazon.com/dp/0593817028?tag=thenewyorktim-20"
## .. .. ..$ age_group : chr ""
## .. .. ..$ book_review_link : chr ""
## .. .. ..$ first_chapter_link : chr ""
## .. .. ..$ sunday_review_link : chr ""
## .. .. ..$ article_chapter_link: chr ""
## .. .. ..$ isbns :List of 1
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593817028"
## .. .. .. .. ..$ isbn13: chr "9780593817025"
## .. .. ..$ buy_links :List of 5
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Amazon"
## .. .. .. .. ..$ url : chr "https://www.amazon.com/dp/0593817028?tag=thenewyorktim-20"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Apple Books"
## .. .. .. .. ..$ url : chr "https://goto.applebooks.apple/9780593817025?at=10lIEQ"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Barnes and Noble"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593817025"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Books-A-Million"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FBULL%2BMOON%2BRISIN"| __truncated__
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Bookshop.org"
## .. .. .. .. ..$ url : chr "https://bookshop.org/a/3546/9780593817025"
## .. .. ..$ book_uri : chr "nyt://book/7767b28f-4f7d-5125-aea9-1ae57ba46fd3"
## .. ..$ :List of 26
## .. .. ..$ rank : int 8
## .. .. ..$ rank_last_week : int 5
## .. .. ..$ weeks_on_list : int 2
## .. .. ..$ asterisk : int 0
## .. .. ..$ dagger : int 0
## .. .. ..$ primary_isbn10 : chr "1538770385"
## .. .. ..$ primary_isbn13 : chr "9781538770382"
## .. .. ..$ publisher : chr "Grand Central"
## .. .. ..$ description : chr "The 28th book in the Kay Scarpetta Series. Scarpetta investigates the death of a former lover."
## .. .. ..$ price : chr "0.00"
## .. .. ..$ title : chr "IDENTITY UNKNOWN"
## .. .. ..$ author : chr "Patricia Cornwell"
## .. .. ..$ contributor : chr "by Patricia Cornwell"
## .. .. ..$ contributor_note : chr ""
## .. .. ..$ book_image : chr "https://storage.googleapis.com/du-prd/books/images/9781538770382.jpg"
## .. .. ..$ book_image_width : int 331
## .. .. ..$ book_image_height : int 500
## .. .. ..$ amazon_product_url : chr "https://www.amazon.com/dp/1538770385?tag=thenewyorktim-20"
## .. .. ..$ age_group : chr ""
## .. .. ..$ book_review_link : chr ""
## .. .. ..$ first_chapter_link : chr ""
## .. .. ..$ sunday_review_link : chr ""
## .. .. ..$ article_chapter_link: chr ""
## .. .. ..$ isbns :List of 3
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "1538770385"
## .. .. .. .. ..$ isbn13: chr "9781538770382"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "1538770431"
## .. .. .. .. ..$ isbn13: chr "9781538770436"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "1538770415"
## .. .. .. .. ..$ isbn13: chr "9781538770412"
## .. .. ..$ buy_links :List of 5
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Amazon"
## .. .. .. .. ..$ url : chr "https://www.amazon.com/dp/1538770385?tag=thenewyorktim-20"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Apple Books"
## .. .. .. .. ..$ url : chr "https://goto.applebooks.apple/9781538770382?at=10lIEQ"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Barnes and Noble"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781538770382"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Books-A-Million"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FIDENTITY%2BUNKNOWN%"| __truncated__
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Bookshop.org"
## .. .. .. .. ..$ url : chr "https://bookshop.org/a/3546/9781538770382"
## .. .. ..$ book_uri : chr "nyt://book/3ebef85f-33bf-57c4-b9c8-86120e2ef599"
## .. ..$ :List of 26
## .. .. ..$ rank : int 9
## .. .. ..$ rank_last_week : int 0
## .. .. ..$ weeks_on_list : int 1
## .. .. ..$ asterisk : int 0
## .. .. ..$ dagger : int 0
## .. .. ..$ primary_isbn10 : chr "0593725336"
## .. .. ..$ primary_isbn13 : chr "9780593725337"
## .. .. ..$ publisher : chr "Ballantine"
## .. .. ..$ description : chr "A woman on a solo holiday retreat encounters complications with a small town’s main store proprietor."
## .. .. ..$ price : chr "0.00"
## .. .. ..$ title : chr "A CHRISTMAS DUET"
## .. .. ..$ author : chr "Debbie Macomber"
## .. .. ..$ contributor : chr "by Debbie Macomber"
## .. .. ..$ contributor_note : chr ""
## .. .. ..$ book_image : chr "https://storage.googleapis.com/du-prd/books/images/9780593725337.jpg"
## .. .. ..$ book_image_width : int 340
## .. .. ..$ book_image_height : int 500
## .. .. ..$ amazon_product_url : chr "https://www.amazon.com/dp/0593725336?tag=thenewyorktim-20"
## .. .. ..$ age_group : chr ""
## .. .. ..$ book_review_link : chr ""
## .. .. ..$ first_chapter_link : chr ""
## .. .. ..$ sunday_review_link : chr ""
## .. .. ..$ article_chapter_link: chr ""
## .. .. ..$ isbns :List of 3
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr ""
## .. .. .. .. ..$ isbn13: chr ""
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593725336"
## .. .. .. .. ..$ isbn13: chr "9780593725337"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593725344"
## .. .. .. .. ..$ isbn13: chr "9780593725344"
## .. .. ..$ buy_links :List of 5
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Amazon"
## .. .. .. .. ..$ url : chr "https://www.amazon.com/dp/0593725336?tag=thenewyorktim-20"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Apple Books"
## .. .. .. .. ..$ url : chr "https://goto.applebooks.apple/9780593725337?at=10lIEQ"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Barnes and Noble"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593725337"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Books-A-Million"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FA%2BCHRISTMAS%2BDUE"| __truncated__
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Bookshop.org"
## .. .. .. .. ..$ url : chr "https://bookshop.org/a/3546/9780593725337"
## .. .. ..$ book_uri : chr "nyt://book/ffad7c1d-8665-507b-be11-76f962d3419c"
## .. ..$ :List of 26
## .. .. ..$ rank : int 10
## .. .. ..$ rank_last_week : int 8
## .. .. ..$ weeks_on_list : int 3
## .. .. ..$ asterisk : int 0
## .. .. ..$ dagger : int 0
## .. .. ..$ primary_isbn10 : chr "031640389X"
## .. .. ..$ primary_isbn13 : chr "9780316403894"
## .. .. ..$ publisher : chr "Little, Brown"
## .. .. ..$ description : chr "An act of heroism by an Illinois pub owner may lead to his undoing."
## .. .. ..$ price : chr "0.00"
## .. .. ..$ title : chr "LIES HE TOLD ME"
## .. .. ..$ author : chr "James Patterson and David Ellis"
## .. .. ..$ contributor : chr "by James Patterson and David Ellis"
## .. .. ..$ contributor_note : chr ""
## .. .. ..$ book_image : chr "https://storage.googleapis.com/du-prd/books/images/9780316403894.jpg"
## .. .. ..$ book_image_width : int 331
## .. .. ..$ book_image_height : int 500
## .. .. ..$ amazon_product_url : chr "https://www.amazon.com/dp/031640389X?tag=thenewyorktim-20"
## .. .. ..$ age_group : chr ""
## .. .. ..$ book_review_link : chr ""
## .. .. ..$ first_chapter_link : chr ""
## .. .. ..$ sunday_review_link : chr ""
## .. .. ..$ article_chapter_link: chr ""
## .. .. ..$ isbns :List of 2
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "031640389X"
## .. .. .. .. ..$ isbn13: chr "9780316403894"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "031640439X"
## .. .. .. .. ..$ isbn13: chr "9780316404396"
## .. .. ..$ buy_links :List of 5
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Amazon"
## .. .. .. .. ..$ url : chr "https://www.amazon.com/dp/031640389X?tag=thenewyorktim-20"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Apple Books"
## .. .. .. .. ..$ url : chr "https://goto.applebooks.apple/9780316403894?at=10lIEQ"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Barnes and Noble"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780316403894"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Books-A-Million"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FLIES%2BHE%2BTOLD%2B"| __truncated__
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Bookshop.org"
## .. .. .. .. ..$ url : chr "https://bookshop.org/a/3546/9780316403894"
## .. .. ..$ book_uri : chr "nyt://book/679690c4-c012-5a67-9cb5-1a1b219085ac"
## .. ..$ :List of 26
## .. .. ..$ rank : int 11
## .. .. ..$ rank_last_week : int 10
## .. .. ..$ weeks_on_list : int 6
## .. .. ..$ asterisk : int 0
## .. .. ..$ dagger : int 0
## .. .. ..$ primary_isbn10 : chr "0593798600"
## .. .. ..$ primary_isbn13 : chr "9780593798607"
## .. .. ..$ publisher : chr "Crown"
## .. .. ..$ description : chr "Passengers on a short and seemingly unremarkable flight learn how and when they are going to die."
## .. .. ..$ price : chr "0.00"
## .. .. ..$ title : chr "HERE ONE MOMENT"
## .. .. ..$ author : chr "Liane Moriarty"
## .. .. ..$ contributor : chr "by Liane Moriarty"
## .. .. ..$ contributor_note : chr ""
## .. .. ..$ book_image : chr "https://storage.googleapis.com/du-prd/books/images/9780593798607.jpg"
## .. .. ..$ book_image_width : int 329
## .. .. ..$ book_image_height : int 500
## .. .. ..$ amazon_product_url : chr "https://www.amazon.com/dp/0593798600?tag=thenewyorktim-20"
## .. .. ..$ age_group : chr ""
## .. .. ..$ book_review_link : chr ""
## .. .. ..$ first_chapter_link : chr ""
## .. .. ..$ sunday_review_link : chr ""
## .. .. ..$ article_chapter_link: chr ""
## .. .. ..$ isbns :List of 3
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593798600"
## .. .. .. .. ..$ isbn13: chr "9780593798607"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593798619"
## .. .. .. .. ..$ isbn13: chr "9780593798614"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593948262"
## .. .. .. .. ..$ isbn13: chr "9780593948262"
## .. .. ..$ buy_links :List of 5
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Amazon"
## .. .. .. .. ..$ url : chr "https://www.amazon.com/dp/0593798600?tag=thenewyorktim-20"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Apple Books"
## .. .. .. .. ..$ url : chr "https://goto.applebooks.apple/9780593798607?at=10lIEQ"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Barnes and Noble"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593798607"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Books-A-Million"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FHERE%2BONE%2BMOMENT"| __truncated__
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Bookshop.org"
## .. .. .. .. ..$ url : chr "https://bookshop.org/a/3546/9780593798607"
## .. .. ..$ book_uri : chr "nyt://book/7e99e658-bd91-5488-a007-2bd74a8ef613"
## .. ..$ :List of 26
## .. .. ..$ rank : int 12
## .. .. ..$ rank_last_week : int 11
## .. .. ..$ weeks_on_list : int 16
## .. .. ..$ asterisk : int 0
## .. .. ..$ dagger : int 0
## .. .. ..$ primary_isbn10 : chr "0593418913"
## .. .. ..$ primary_isbn13 : chr "9780593418918"
## .. .. ..$ publisher : chr "Riverhead"
## .. .. ..$ description : chr "When a 13-year-old girl disappears from an Adirondack summer camp in 1975, secrets kept by the Van Laar family emerge."
## .. .. ..$ price : chr "0.00"
## .. .. ..$ title : chr "THE GOD OF THE WOODS"
## .. .. ..$ author : chr "Liz Moore"
## .. .. ..$ contributor : chr "by Liz Moore"
## .. .. ..$ contributor_note : chr ""
## .. .. ..$ book_image : chr "https://storage.googleapis.com/du-prd/books/images/9780593418918.jpg"
## .. .. ..$ book_image_width : int 331
## .. .. ..$ book_image_height : int 500
## .. .. ..$ amazon_product_url : chr "https://www.amazon.com/dp/0593418913?tag=thenewyorktim-20"
## .. .. ..$ age_group : chr ""
## .. .. ..$ book_review_link : chr ""
## .. .. ..$ first_chapter_link : chr ""
## .. .. ..$ sunday_review_link : chr ""
## .. .. ..$ article_chapter_link: chr ""
## .. .. ..$ isbns :List of 3
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593418913"
## .. .. .. .. ..$ isbn13: chr "9780593418918"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "059341893X"
## .. .. .. .. ..$ isbn13: chr "9780593418932"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593867793"
## .. .. .. .. ..$ isbn13: chr "9780593867792"
## .. .. ..$ buy_links :List of 5
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Amazon"
## .. .. .. .. ..$ url : chr "https://www.amazon.com/dp/0593418913?tag=thenewyorktim-20"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Apple Books"
## .. .. .. .. ..$ url : chr "https://goto.applebooks.apple/9780593418918?at=10lIEQ"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Barnes and Noble"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593418918"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Books-A-Million"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BGOD%2BOF%2BTH"| __truncated__
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Bookshop.org"
## .. .. .. .. ..$ url : chr "https://bookshop.org/a/3546/9780593418918"
## .. .. ..$ book_uri : chr "nyt://book/76d129f6-ab9c-591c-b25e-9a2758250c07"
## .. ..$ :List of 26
## .. .. ..$ rank : int 13
## .. .. ..$ rank_last_week : int 14
## .. .. ..$ weeks_on_list : int 6
## .. .. ..$ asterisk : int 0
## .. .. ..$ dagger : int 0
## .. .. ..$ primary_isbn10 : chr "0593446097"
## .. .. ..$ primary_isbn13 : chr "9780593446096"
## .. .. ..$ publisher : chr "Random House"
## .. .. ..$ description : chr "As a murder casts a pall on a town in Maine, Lucy Barton, Olive Kitteridge and Bob Burgess share stories and seek meaning."
## .. .. ..$ price : chr "0.00"
## .. .. ..$ title : chr "TELL ME EVERYTHING"
## .. .. ..$ author : chr "Elizabeth Strout"
## .. .. ..$ contributor : chr "by Elizabeth Strout"
## .. .. ..$ contributor_note : chr ""
## .. .. ..$ book_image : chr "https://storage.googleapis.com/du-prd/books/images/9780593446096.jpg"
## .. .. ..$ book_image_width : int 331
## .. .. ..$ book_image_height : int 500
## .. .. ..$ amazon_product_url : chr "https://www.amazon.com/dp/0593446097?tag=thenewyorktim-20"
## .. .. ..$ age_group : chr ""
## .. .. ..$ book_review_link : chr ""
## .. .. ..$ first_chapter_link : chr ""
## .. .. ..$ sunday_review_link : chr ""
## .. .. ..$ article_chapter_link: chr ""
## .. .. ..$ isbns :List of 2
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593446097"
## .. .. .. .. ..$ isbn13: chr "9780593446096"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593446100"
## .. .. .. .. ..$ isbn13: chr "9780593446102"
## .. .. ..$ buy_links :List of 5
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Amazon"
## .. .. .. .. ..$ url : chr "https://www.amazon.com/dp/0593446097?tag=thenewyorktim-20"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Apple Books"
## .. .. .. .. ..$ url : chr "https://goto.applebooks.apple/9780593446096?at=10lIEQ"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Barnes and Noble"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593446096"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Books-A-Million"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTELL%2BME%2BEVERYTH"| __truncated__
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Bookshop.org"
## .. .. .. .. ..$ url : chr "https://bookshop.org/a/3546/9780593446096"
## .. .. ..$ book_uri : chr "nyt://book/3f5b9449-8053-58fe-b24d-67c77f14d384"
## .. ..$ :List of 26
## .. .. ..$ rank : int 14
## .. .. ..$ rank_last_week : int 0
## .. .. ..$ weeks_on_list : int 16
## .. .. ..$ asterisk : int 0
## .. .. ..$ dagger : int 0
## .. .. ..$ primary_isbn10 : chr "0385550367"
## .. .. ..$ primary_isbn13 : chr "9780385550369"
## .. .. ..$ publisher : chr "Doubleday"
## .. .. ..$ description : chr "A reimagining of “Adventures of Huckleberry Finn” shines a different light on Mark Twain's classic, revealing n"| __truncated__
## .. .. ..$ price : chr "0.00"
## .. .. ..$ title : chr "JAMES"
## .. .. ..$ author : chr "Percival Everett"
## .. .. ..$ contributor : chr "by Percival Everett"
## .. .. ..$ contributor_note : chr ""
## .. .. ..$ book_image : chr "https://storage.googleapis.com/du-prd/books/images/9780385550369.jpg"
## .. .. ..$ book_image_width : int 333
## .. .. ..$ book_image_height : int 500
## .. .. ..$ amazon_product_url : chr "https://www.amazon.com/dp/0385550367?tag=thenewyorktim-20"
## .. .. ..$ age_group : chr ""
## .. .. ..$ book_review_link : chr ""
## .. .. ..$ first_chapter_link : chr ""
## .. .. ..$ sunday_review_link : chr ""
## .. .. ..$ article_chapter_link: chr ""
## .. .. ..$ isbns :List of 2
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0385550367"
## .. .. .. .. ..$ isbn13: chr "9780385550369"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0385550375"
## .. .. .. .. ..$ isbn13: chr "9780385550376"
## .. .. ..$ buy_links :List of 5
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Amazon"
## .. .. .. .. ..$ url : chr "https://www.amazon.com/dp/0385550367?tag=thenewyorktim-20"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Apple Books"
## .. .. .. .. ..$ url : chr "https://goto.applebooks.apple/9780385550369?at=10lIEQ"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Barnes and Noble"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780385550369"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Books-A-Million"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FJAMES%2FPercival%2B"| __truncated__
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Bookshop.org"
## .. .. .. .. ..$ url : chr "https://bookshop.org/a/3546/9780385550369"
## .. .. ..$ book_uri : chr "nyt://book/5788b098-426a-5f2c-a318-475692df69ee"
## .. ..$ :List of 26
## .. .. ..$ rank : int 15
## .. .. ..$ rank_last_week : int 12
## .. .. ..$ weeks_on_list : int 14
## .. .. ..$ asterisk : int 0
## .. .. ..$ dagger : int 0
## .. .. ..$ primary_isbn10 : chr "0593798872"
## .. .. ..$ primary_isbn13 : chr "9780593798874"
## .. .. ..$ publisher : chr "Crown"
## .. .. ..$ description : chr "Questions arise when a boy saves the daughter of a wealthy family amid a string of disappearances in a Missouri town in 1975."
## .. .. ..$ price : chr "0.00"
## .. .. ..$ title : chr "ALL THE COLORS OF THE DARK"
## .. .. ..$ author : chr "Chris Whitaker"
## .. .. ..$ contributor : chr "by Chris Whitaker"
## .. .. ..$ contributor_note : chr ""
## .. .. ..$ book_image : chr "https://storage.googleapis.com/du-prd/books/images/9780593798874.jpg"
## .. .. ..$ book_image_width : int 328
## .. .. ..$ book_image_height : int 500
## .. .. ..$ amazon_product_url : chr "https://www.amazon.com/dp/0593798872?tag=thenewyorktim-20"
## .. .. ..$ age_group : chr ""
## .. .. ..$ book_review_link : chr ""
## .. .. ..$ first_chapter_link : chr ""
## .. .. ..$ sunday_review_link : chr ""
## .. .. ..$ article_chapter_link: chr ""
## .. .. ..$ isbns :List of 4
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593798872"
## .. .. .. .. ..$ isbn13: chr "9780593798874"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593798880"
## .. .. .. .. ..$ isbn13: chr "9780593798881"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593949005"
## .. .. .. .. ..$ isbn13: chr "9780593949009"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ isbn10: chr "0593943333"
## .. .. .. .. ..$ isbn13: chr "9780593943335"
## .. .. ..$ buy_links :List of 5
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Amazon"
## .. .. .. .. ..$ url : chr "https://www.amazon.com/dp/0593798872?tag=thenewyorktim-20"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Apple Books"
## .. .. .. .. ..$ url : chr "https://goto.applebooks.apple/9780593798874?at=10lIEQ"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Barnes and Noble"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593798874"
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Books-A-Million"
## .. .. .. .. ..$ url : chr "https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FALL%2BTHE%2BCOLORS%"| __truncated__
## .. .. .. ..$ :List of 2
## .. .. .. .. ..$ name: chr "Bookshop.org"
## .. .. .. .. ..$ url : chr "https://bookshop.org/a/3546/9780593798874"
## .. .. ..$ book_uri : chr "nyt://book/4a3574a1-cb25-5910-a11e-f97ffb3508bd"
## ..$ corrections : list()Create a Data Frame from JSON Response
After analyzing the structure, we found that
raw_json_data returns a list of lists. To
convert it into a data frame, we will use map_dfr().
- Extract the book list
raw_json_data$results$books. - Convert the list of books into a data frame.
- Display the new data frame.
# 1. Extract the book list
obj_list <- raw_json_data$results$books
# 2. Convert the list of books into a data frame
obj_df <- map_dfr(obj_list, ~as.data.frame(.x, stringsAsFactors = FALSE))
#3. Display the new data frame
datatable(obj_df,
options = list(pageLength = 3,
scrollX = TRUE))Add Metadata to the Data Frame
Now the metadata will also be exported and added to the previously
created obj_df, allowing us to include this information as
part of the results.
- Retrieve the fields from
raw_json_data$results:list_namelist_name_encodedbestsellers_datepublished_date
- Extract the values into a vector.
- Add new columns to the previously created
obj_df, placing them at the front. - Display the updated data frame.
# 1. Get the fields in results raw_json_data$results
result_columns <- c("list_name", "list_name_encoded", "bestsellers_date", "published_date")
# 2. Extract the return into a vector
metadata <- raw_json_data$results[result_columns]
# 3. Add new columns into the previous obj_df created
obj_df <- obj_df |>
mutate(
list_name = metadata$list_name,
list_name_encoded = metadata$list_name_encoded,
bestsellers_date = metadata$bestsellers_date,
published_date = metadata$published_date
)|>
select(list_name, list_name_encoded, bestsellers_date, published_date, everything())
# 4. Display the updated data frame
datatable(obj_df,
options = list(pageLength = 3,
scrollX = TRUE))Visualization
After identifying all the available columns, I decided to focus on weeks_on_list, which indicates the number of weeks each book has been listed on the bestseller list.
This Geo bar chart illustrates the duration that each book has spent on the bestseller list, highlighting that IRON FLAME had the longest duration among the titles.
# Unique columns
unique_columns <- unique(colnames(obj_df))
print(unique_columns)## [1] "list_name" "list_name_encoded" "bestsellers_date"
## [4] "published_date" "rank" "rank_last_week"
## [7] "weeks_on_list" "asterisk" "dagger"
## [10] "primary_isbn10" "primary_isbn13" "publisher"
## [13] "description" "price" "title"
## [16] "author" "contributor" "contributor_note"
## [19] "book_image" "book_image_width" "book_image_height"
## [22] "amazon_product_url" "age_group" "book_review_link"
## [25] "first_chapter_link" "sunday_review_link" "article_chapter_link"
## [28] "isbns.isbn10" "isbns.isbn13" "isbns.isbn10.1"
## [31] "isbns.isbn13.1" "isbns.isbn10.2" "isbns.isbn13.2"
## [34] "buy_links.name" "buy_links.url" "buy_links.name.1"
## [37] "buy_links.url.1" "buy_links.name.2" "buy_links.url.2"
## [40] "buy_links.name.3" "buy_links.url.3" "buy_links.name.4"
## [43] "buy_links.url.4" "book_uri" "isbns.isbn10.3"
## [46] "isbns.isbn13.3"ggplot(obj_df, aes(x = reorder(title, -weeks_on_list), y = weeks_on_list)) +
geom_bar(stat = "identity", fill = NA, color = "Orange", size = 1) +
labs(title = "Weeks on Best Sellers List", x = "Book Title", y = "Weeks on List") +
scale_y_continuous(breaks = seq(0, max(obj_df$weeks_on_list), by = 5)) + #Specifies the breaks on the y-axis
theme_minimal() +
coord_flip()