Step2 Convert into a Dataframe
#JSON file
books_parsed<-fromJSON(content(books_api, "text"))
books_parsed
## $status
## [1] "OK"
##
## $copyright
## [1] "Copyright (c) 2018 The New York Times Company. All Rights Reserved."
##
## $num_results
## [1] 15
##
## $last_modified
## [1] "2018-10-24T22:38:01-04:00"
##
## $results
## list_name display_name bestsellers_date published_date
## 1 Hardcover Fiction Hardcover Fiction 2018-10-20 2018-11-04
## 2 Hardcover Fiction Hardcover Fiction 2018-10-20 2018-11-04
## 3 Hardcover Fiction Hardcover Fiction 2018-10-20 2018-11-04
## 4 Hardcover Fiction Hardcover Fiction 2018-10-20 2018-11-04
## 5 Hardcover Fiction Hardcover Fiction 2018-10-20 2018-11-04
## 6 Hardcover Fiction Hardcover Fiction 2018-10-20 2018-11-04
## 7 Hardcover Fiction Hardcover Fiction 2018-10-20 2018-11-04
## 8 Hardcover Fiction Hardcover Fiction 2018-10-20 2018-11-04
## 9 Hardcover Fiction Hardcover Fiction 2018-10-20 2018-11-04
## 10 Hardcover Fiction Hardcover Fiction 2018-10-20 2018-11-04
## 11 Hardcover Fiction Hardcover Fiction 2018-10-20 2018-11-04
## 12 Hardcover Fiction Hardcover Fiction 2018-10-20 2018-11-04
## 13 Hardcover Fiction Hardcover Fiction 2018-10-20 2018-11-04
## 14 Hardcover Fiction Hardcover Fiction 2018-10-20 2018-11-04
## 15 Hardcover Fiction Hardcover Fiction 2018-10-20 2018-11-04
## rank rank_last_week weeks_on_list asterisk dagger
## 1 1 0 1 0 0
## 2 2 1 2 0 0
## 3 3 0 1 0 0
## 4 4 6 3 0 0
## 5 5 4 2 0 0
## 6 6 2 2 0 0
## 7 7 7 2 0 0
## 8 8 9 4 0 0
## 9 9 5 2 0 0
## 10 10 0 1 0 0
## 11 11 10 7 0 0
## 12 12 3 2 0 0
## 13 13 0 1 0 0
## 14 14 11 3 0 0
## 15 15 8 2 0 0
## amazon_product_url
## 1 https://www.amazon.com/Every-Breath-Nicholas-Sparks/dp/1538728524?tag=NYTBS-20
## 2 https://www.amazon.com/Next-Person-You-Meet-Heaven/dp/006229444X?tag=NYTBS-20
## 3 https://www.amazon.com/Unsheltered-Novel-Barbara-Kingsolver/dp/0062684566?tag=NYTBS-20
## 4 https://www.amazon.com/Spark-Light-Novel-Jodi-Picoult-ebook/dp/B07B73H2BX?tag=NYTBS-20
## 5 https://www.amazon.com/Ambush-Michael-Bennett-Book-11-ebook/dp/B079L52TTB?tag=NYTBS-20
## 6 https://www.amazon.com/Holy-Ghost-Virgil-Flowers-Novel-ebook/dp/B079DXLLPC?tag=NYTBS-20
## 7 https://www.amazon.com/Witch-Elm-Novel-Tana-French-ebook/dp/B07C1XRQVJ?tag=NYTBS-20
## 8 https://www.amazon.com/Red-Mitch-Rapp-Novel-Book-ebook/dp/B07B3WJ9X7?tag=NYTBS-20
## 9 https://www.amazon.com/Winter-Paradise-Elin-Hilderbrand/dp/0316435511?tag=NYTBS-20
## 10 https://www.amazon.com/When-We-Were-Young-Baxter/dp/1501170015?tag=NYTBS-20
## 11 https://www.amazon.com/Where-Crawdads-Sing-Delia-Owens/dp/0735219095?tag=NYTBS-20
## 12 https://www.amazon.com/Clockmakers-Daughter-Novel-Kate-Morton/dp/1451649398?tag=NYTBS-20
## 13 https://www.amazon.com/Desperate-Measures-Stone-Barrington-Novel-ebook/dp/B0796D79WK?tag=NYTBS-20
## 14 https://www.amazon.com/Alaskan-Holiday-Novel-Debbie-Macomber-ebook/dp/B078VTZV9X?tag=NYTBS-20
## 15 https://www.amazon.com/Killing-Commendatore-novel-Haruki-Murakami/dp/052552004X?tag=NYTBS-20
## isbns
## 1 1538728524, 1538715775, 1538728532, 9781538728529, 9781538763995, 9781538728536
## 2 006229444X, 0062294466, 9780062294449, 9780062294463
## 3 0062684566, 0062684744, 9780062684561, 9780062684745
## 4 0345544986, 0345544994, 9780345544988, 9780345544995
## 5 0316273988, 0316414697, 9780316273985, 9780316414692
## 6 0735217327, 0735217335, 9780735217324, 9780735217331
## 7 0735224625, 0735224633, 1984882686, 9780735224629, 9780735224636, 9781984882684
## 8 1501190598, 150119061X, 1508252394, 9781501190599, 9781501190612, 9781508252399
## 9 0316435511, 0316435503, 9780316435512, 9780316435505
## 10 1501170015, 9781501170010
## 11 0735219095, 0735219117, 0525640371, 9780735219090, 9780735219113, 9780525640370
## 12 1451649398, 1451649436, 9781451649390, 9781451649437
## 13 0735219222, 0735219249, 9780735219229, 9780735219243
## 14 0399181288, 0399181296, 1984833561, 9780399181283, 9780399181290, 9781984833563
## 15 052552004X, 0525520058, 9780525520047, 9780525520054
## book_details
## 1 EVERY BREATH, Difficult choices surface when Hope Anderson and Tru Walls meet in a North Carolina seaside town., by Nicholas Sparks, Nicholas Sparks, , 0, , Grand Central, 9781538728529, 1538728524
## 2 THE NEXT PERSON YOU MEET IN HEAVEN, The sequel to "The Five People You Meet in Heaven" follows Annie on her heavenly journey., by Mitch Albom, Mitch Albom, , 0, , Harper, 9780062294449, 006229444X
## 3 UNSHELTERED, Intertwined stories of two families who live in different centuries on the same street corner in Vineland, N.J., by Barbara Kingsolver, Barbara Kingsolver, , 0, , Harper, 9780062684561, 0062684566
## 4 A SPARK OF LIGHT, The lives of patients, doctors and activists intersect when a gunman holds them all hostage in a woman's health center in Mississippi., by Jodi Picoult, Jodi Picoult, , 0, , Ballantine, 9780345544988, 0345544986
## 5 AMBUSH, Michael Bennett discovers that an assassin is targeting him and his family., by James Patterson and James O. Born, James Patterson and James O Born, , 0, , Little, Brown, 9780316273985, 0316273988
## 6 HOLY GHOST, Virgil Flowers investigates shootings in a Minnesota town following an attempt to revive its ailing economy., by John Sandford, John Sandford, , 0, , Putnam, 9780735217324, 0735217327
## 7 THE WITCH ELM, After Toby Hennessy retreats to his familys ancestral home, a skull discovered in the backyard exposes his family's past., by Tana French, Tana French, , 0, , Viking, 9780735224629, 0735224625
## 8 VINCE FLYNN: RED WAR, When the Russian prime minister plots to invade the Baltics, only Mitch Rapp can stop him., by Kyle Mills, Kyle Mills, , 0, , Emily Bestler/Atria, 9781501190599, 1501190598
## 9 WINTER IN PARADISE, Irene Steele uncovers her husbands secret life on a Caribbean island following his death., by Elin Hilderbrand, Elin Hilderbrand, , 0, , Little, Brown, 9780316435512, 0316435511
## 10 WHEN WE WERE YOUNG, The reality of Noah and Emily Carters marriage is different from the one curated for their social media followers., by Karen Kingsbury, Karen Kingsbury, , 0, , Howard, 9781501170010, 1501170015
## 11 WHERE THE CRAWDADS SING, In a quiet town on the North Carolina coast in 1969, a woman who survived alone in the marsh becomes a murder suspect., by Delia Owens, Delia Owens, , 0, , Putnam, 9780735219090, 0735219095
## 12 THE CLOCKMAKER'S DAUGHTER, A century-old mystery at the Birchwood Manor on the Thames connects the lives of an archivist and artist., by Kate Morton, Kate Morton, , 0, , Atria, 9781451649390, 1451649398
## 13 DESPERATE MEASURES, The 47th book in the Stone Barrington series., by Stuart Woods, Stuart Woods, , 0, , Putnam, 9780735219229, 0735219222
## 14 ALASKAN HOLIDAY, A Seattleite cook stuck in remote Ponder, Alaska, grapples with her feelings for the local swordsmith., by Debbie Macomber, Debbie Macomber, , 0, , Ballantine, 9780399181283, 0399181288
## 15 KILLING COMMENDATORE, The discovery of an unseen work in an artists attic unleashes a series of bizarre occurrences that a painter must navigate., by Haruki Murakami, Haruki Murakami, , 0, , Knopf, 9780525520047, 052552004X
## reviews
## 1 , , ,
## 2 , , ,
## 3 , , ,
## 4 , , ,
## 5 , , ,
## 6 , , ,
## 7 https://www.nytimes.com/2018/10/10/books/review/tana-french-witch-elm.html, , ,
## 8 , , ,
## 9 , , ,
## 10 , , ,
## 11 , , ,
## 12 , , ,
## 13 , , ,
## 14 , , ,
## 15 https://www.nytimes.com/2018/10/16/books/review/haruki-murakami-killing-commendatore.html, , ,
#Get only the results
df<-data.frame(books_parsed$results)
head(df)
#From the results get the books details in a table
library(kableExtra)
kable(df$book_details)
|
title
|
description
|
contributor
|
author
|
contributor_note
|
price
|
age_group
|
publisher
|
primary_isbn13
|
primary_isbn10
|
|
EVERY BREATH
|
Difficult choices surface when Hope Anderson and Tru Walls meet in a North Carolina seaside town.
|
by Nicholas Sparks
|
Nicholas Sparks
|
|
0
|
|
Grand Central
|
9781538728529
|
1538728524
|
|
|
title
|
description
|
contributor
|
author
|
contributor_note
|
price
|
age_group
|
publisher
|
primary_isbn13
|
primary_isbn10
|
|
THE NEXT PERSON YOU MEET IN HEAVEN
|
The sequel to “The Five People You Meet in Heaven” follows Annie on her heavenly journey.
|
by Mitch Albom
|
Mitch Albom
|
|
0
|
|
Harper
|
9780062294449
|
006229444X
|
|
|
title
|
description
|
contributor
|
author
|
contributor_note
|
price
|
age_group
|
publisher
|
primary_isbn13
|
primary_isbn10
|
|
UNSHELTERED
|
Intertwined stories of two families who live in different centuries on the same street corner in Vineland, N.J.
|
by Barbara Kingsolver
|
Barbara Kingsolver
|
|
0
|
|
Harper
|
9780062684561
|
0062684566
|
|
|
title
|
description
|
contributor
|
author
|
contributor_note
|
price
|
age_group
|
publisher
|
primary_isbn13
|
primary_isbn10
|
|
A SPARK OF LIGHT
|
The lives of patients, doctors and activists intersect when a gunman holds them all hostage in a woman’s health center in Mississippi.
|
by Jodi Picoult
|
Jodi Picoult
|
|
0
|
|
Ballantine
|
9780345544988
|
0345544986
|
|
|
title
|
description
|
contributor
|
author
|
contributor_note
|
price
|
age_group
|
publisher
|
primary_isbn13
|
primary_isbn10
|
|
AMBUSH
|
Michael Bennett discovers that an assassin is targeting him and his family.
|
by James Patterson and James O. Born
|
James Patterson and James O Born
|
|
0
|
|
Little, Brown
|
9780316273985
|
0316273988
|
|
|
title
|
description
|
contributor
|
author
|
contributor_note
|
price
|
age_group
|
publisher
|
primary_isbn13
|
primary_isbn10
|
|
HOLY GHOST
|
Virgil Flowers investigates shootings in a Minnesota town following an attempt to revive its ailing economy.
|
by John Sandford
|
John Sandford
|
|
0
|
|
Putnam
|
9780735217324
|
0735217327
|
|
|
title
|
description
|
contributor
|
author
|
contributor_note
|
price
|
age_group
|
publisher
|
primary_isbn13
|
primary_isbn10
|
|
THE WITCH ELM
|
After Toby Hennessy retreats to his familys ancestral home, a skull discovered in the backyard exposes his family’s past.
|
by Tana French
|
Tana French
|
|
0
|
|
Viking
|
9780735224629
|
0735224625
|
|
|
title
|
description
|
contributor
|
author
|
contributor_note
|
price
|
age_group
|
publisher
|
primary_isbn13
|
primary_isbn10
|
|
VINCE FLYNN: RED WAR
|
When the Russian prime minister plots to invade the Baltics, only Mitch Rapp can stop him.
|
by Kyle Mills
|
Kyle Mills
|
|
0
|
|
Emily Bestler/Atria
|
9781501190599
|
1501190598
|
|
|
title
|
description
|
contributor
|
author
|
contributor_note
|
price
|
age_group
|
publisher
|
primary_isbn13
|
primary_isbn10
|
|
WINTER IN PARADISE
|
Irene Steele uncovers her husbands secret life on a Caribbean island following his death.
|
by Elin Hilderbrand
|
Elin Hilderbrand
|
|
0
|
|
Little, Brown
|
9780316435512
|
0316435511
|
|
|
title
|
description
|
contributor
|
author
|
contributor_note
|
price
|
age_group
|
publisher
|
primary_isbn13
|
primary_isbn10
|
|
WHEN WE WERE YOUNG
|
The reality of Noah and Emily Carters marriage is different from the one curated for their social media followers.
|
by Karen Kingsbury
|
Karen Kingsbury
|
|
0
|
|
Howard
|
9781501170010
|
1501170015
|
|
|
title
|
description
|
contributor
|
author
|
contributor_note
|
price
|
age_group
|
publisher
|
primary_isbn13
|
primary_isbn10
|
|
WHERE THE CRAWDADS SING
|
In a quiet town on the North Carolina coast in 1969, a woman who survived alone in the marsh becomes a murder suspect.
|
by Delia Owens
|
Delia Owens
|
|
0
|
|
Putnam
|
9780735219090
|
0735219095
|
|
|
title
|
description
|
contributor
|
author
|
contributor_note
|
price
|
age_group
|
publisher
|
primary_isbn13
|
primary_isbn10
|
|
THE CLOCKMAKER’S DAUGHTER
|
A century-old mystery at the Birchwood Manor on the Thames connects the lives of an archivist and artist.
|
by Kate Morton
|
Kate Morton
|
|
0
|
|
Atria
|
9781451649390
|
1451649398
|
|
|
title
|
description
|
contributor
|
author
|
contributor_note
|
price
|
age_group
|
publisher
|
primary_isbn13
|
primary_isbn10
|
|
DESPERATE MEASURES
|
The 47th book in the Stone Barrington series.
|
by Stuart Woods
|
Stuart Woods
|
|
0
|
|
Putnam
|
9780735219229
|
0735219222
|
|
|
title
|
description
|
contributor
|
author
|
contributor_note
|
price
|
age_group
|
publisher
|
primary_isbn13
|
primary_isbn10
|
|
ALASKAN HOLIDAY
|
A Seattleite cook stuck in remote Ponder, Alaska, grapples with her feelings for the local swordsmith.
|
by Debbie Macomber
|
Debbie Macomber
|
|
0
|
|
Ballantine
|
9780399181283
|
0399181288
|
|
|
title
|
description
|
contributor
|
author
|
contributor_note
|
price
|
age_group
|
publisher
|
primary_isbn13
|
primary_isbn10
|
|
KILLING COMMENDATORE
|
The discovery of an unseen work in an artists attic unleashes a series of bizarre occurrences that a painter must navigate.
|
by Haruki Murakami
|
Haruki Murakami
|
|
0
|
|
Knopf
|
9780525520047
|
052552004X
|
|
#Print all the best sellers books
for (i in 1:15){
print(df$book_details[i])
}
## [[1]]
## title
## 1 EVERY BREATH
## description
## 1 Difficult choices surface when Hope Anderson and Tru Walls meet in a North Carolina seaside town.
## contributor author contributor_note price age_group
## 1 by Nicholas Sparks Nicholas Sparks 0
## publisher primary_isbn13 primary_isbn10
## 1 Grand Central 9781538728529 1538728524
##
## [[1]]
## title
## 1 THE NEXT PERSON YOU MEET IN HEAVEN
## description
## 1 The sequel to "The Five People You Meet in Heaven" follows Annie on her heavenly journey.
## contributor author contributor_note price age_group publisher
## 1 by Mitch Albom Mitch Albom 0 Harper
## primary_isbn13 primary_isbn10
## 1 9780062294449 006229444X
##
## [[1]]
## title
## 1 UNSHELTERED
## description
## 1 Intertwined stories of two families who live in different centuries on the same street corner in Vineland, N.J.
## contributor author contributor_note price
## 1 by Barbara Kingsolver Barbara Kingsolver 0
## age_group publisher primary_isbn13 primary_isbn10
## 1 Harper 9780062684561 0062684566
##
## [[1]]
## title
## 1 A SPARK OF LIGHT
## description
## 1 The lives of patients, doctors and activists intersect when a gunman holds them all hostage in a woman's health center in Mississippi.
## contributor author contributor_note price age_group publisher
## 1 by Jodi Picoult Jodi Picoult 0 Ballantine
## primary_isbn13 primary_isbn10
## 1 9780345544988 0345544986
##
## [[1]]
## title
## 1 AMBUSH
## description
## 1 Michael Bennett discovers that an assassin is targeting him and his family.
## contributor author
## 1 by James Patterson and James O. Born James Patterson and James O Born
## contributor_note price age_group publisher primary_isbn13
## 1 0 Little, Brown 9780316273985
## primary_isbn10
## 1 0316273988
##
## [[1]]
## title
## 1 HOLY GHOST
## description
## 1 Virgil Flowers investigates shootings in a Minnesota town following an attempt to revive its ailing economy.
## contributor author contributor_note price age_group
## 1 by John Sandford John Sandford 0
## publisher primary_isbn13 primary_isbn10
## 1 Putnam 9780735217324 0735217327
##
## [[1]]
## title
## 1 THE WITCH ELM
## description
## 1 After Toby Hennessy retreats to his familys ancestral home, a skull discovered in the backyard exposes his family's past.
## contributor author contributor_note price age_group publisher
## 1 by Tana French Tana French 0 Viking
## primary_isbn13 primary_isbn10
## 1 9780735224629 0735224625
##
## [[1]]
## title
## 1 VINCE FLYNN: RED WAR
## description
## 1 When the Russian prime minister plots to invade the Baltics, only Mitch Rapp can stop him.
## contributor author contributor_note price age_group
## 1 by Kyle Mills Kyle Mills 0
## publisher primary_isbn13 primary_isbn10
## 1 Emily Bestler/Atria 9781501190599 1501190598
##
## [[1]]
## title
## 1 WINTER IN PARADISE
## description
## 1 Irene Steele uncovers her husbands secret life on a Caribbean island following his death.
## contributor author contributor_note price age_group
## 1 by Elin Hilderbrand Elin Hilderbrand 0
## publisher primary_isbn13 primary_isbn10
## 1 Little, Brown 9780316435512 0316435511
##
## [[1]]
## title
## 1 WHEN WE WERE YOUNG
## description
## 1 The reality of Noah and Emily Carters marriage is different from the one curated for their social media followers.
## contributor author contributor_note price age_group
## 1 by Karen Kingsbury Karen Kingsbury 0
## publisher primary_isbn13 primary_isbn10
## 1 Howard 9781501170010 1501170015
##
## [[1]]
## title
## 1 WHERE THE CRAWDADS SING
## description
## 1 In a quiet town on the North Carolina coast in 1969, a woman who survived alone in the marsh becomes a murder suspect.
## contributor author contributor_note price age_group publisher
## 1 by Delia Owens Delia Owens 0 Putnam
## primary_isbn13 primary_isbn10
## 1 9780735219090 0735219095
##
## [[1]]
## title
## 1 THE CLOCKMAKER'S DAUGHTER
## description
## 1 A century-old mystery at the Birchwood Manor on the Thames connects the lives of an archivist and artist.
## contributor author contributor_note price age_group publisher
## 1 by Kate Morton Kate Morton 0 Atria
## primary_isbn13 primary_isbn10
## 1 9781451649390 1451649398
##
## [[1]]
## title description
## 1 DESPERATE MEASURES The 47th book in the Stone Barrington series.
## contributor author contributor_note price age_group publisher
## 1 by Stuart Woods Stuart Woods 0 Putnam
## primary_isbn13 primary_isbn10
## 1 9780735219229 0735219222
##
## [[1]]
## title
## 1 ALASKAN HOLIDAY
## description
## 1 A Seattleite cook stuck in remote Ponder, Alaska, grapples with her feelings for the local swordsmith.
## contributor author contributor_note price age_group
## 1 by Debbie Macomber Debbie Macomber 0
## publisher primary_isbn13 primary_isbn10
## 1 Ballantine 9780399181283 0399181288
##
## [[1]]
## title
## 1 KILLING COMMENDATORE
## description
## 1 The discovery of an unseen work in an artists attic unleashes a series of bizarre occurrences that a painter must navigate.
## contributor author contributor_note price age_group
## 1 by Haruki Murakami Haruki Murakami 0
## publisher primary_isbn13 primary_isbn10
## 1 Knopf 9780525520047 052552004X