The New York Times web site provides a rich set of APIs, as described here: http://developer.nytimes.com/docs You’ll need to start by signing up for an API key. Your task is to choose one of the New York Times APIs, construct an interface in R to read in the JSON data, and transform it to an R dataframe.
# This is the code chunk for reading in the results of the call to the NYT Books API into R as a data frame
library(jsonlite)
library(tidyverse)
## -- Attaching packages --------------------------------------------------- tidyverse 1.2.1 --
## v ggplot2 3.1.0 v purrr 0.3.2
## v tibble 2.1.1 v dplyr 0.8.0.1
## v tidyr 0.8.3 v stringr 1.4.0
## v readr 1.3.1 v forcats 0.4.0
## Warning: package 'ggplot2' was built under R version 3.5.3
## Warning: package 'tibble' was built under R version 3.5.3
## Warning: package 'tidyr' was built under R version 3.5.3
## Warning: package 'purrr' was built under R version 3.5.3
## -- Conflicts ------------------------------------------------------ tidyverse_conflicts() --
## x dplyr::filter() masks stats::filter()
## x purrr::flatten() masks jsonlite::flatten()
## x dplyr::lag() masks stats::lag()
library(httr)
## Warning: package 'httr' was built under R version 3.5.3
library(dplyr)
NYTIMES_KEY="r6dRVdNUe4IQIRGmFAyJ9VCjOvVukrUP"
NYTURL = "https://api.nytimes.com/svc/books/v3/"
RELATIVEURL = "/lists/names.json?query=paperback-nonfiction&bestsellers-date=2019-03-30"
URL = paste0(NYTURL, RELATIVEURL,"&api-key=",NYTIMES_KEY)
request <- fromJSON(URL, flatten = TRUE)
str(request)
## List of 4
## $ status : chr "OK"
## $ copyright : chr "Copyright (c) 2019 The New York Times Company. All Rights Reserved."
## $ num_results: int 55
## $ results :'data.frame': 55 obs. of 6 variables:
## ..$ list_name : chr [1:55] "Combined Print and E-Book Fiction" "Combined Print and E-Book Nonfiction" "Hardcover Fiction" "Hardcover Nonfiction" ...
## ..$ display_name : chr [1:55] "Combined Print & E-Book Fiction" "Combined Print & E-Book Nonfiction" "Hardcover Fiction" "Hardcover Nonfiction" ...
## ..$ list_name_encoded : chr [1:55] "combined-print-and-e-book-fiction" "combined-print-and-e-book-nonfiction" "hardcover-fiction" "hardcover-nonfiction" ...
## ..$ oldest_published_date: chr [1:55] "2011-02-13" "2011-02-13" "2008-06-08" "2008-06-08" ...
## ..$ newest_published_date: chr [1:55] "2019-04-07" "2019-04-07" "2019-04-07" "2019-04-07" ...
## ..$ updated : chr [1:55] "WEEKLY" "WEEKLY" "WEEKLY" "WEEKLY" ...
#request$status
#request$num_results
#request$results
book.lists.df<-as.data.frame(request$results)
book.lists.df
## list_name
## 1 Combined Print and E-Book Fiction
## 2 Combined Print and E-Book Nonfiction
## 3 Hardcover Fiction
## 4 Hardcover Nonfiction
## 5 Trade Fiction Paperback
## 6 Mass Market Paperback
## 7 Paperback Nonfiction
## 8 E-Book Fiction
## 9 E-Book Nonfiction
## 10 Hardcover Advice
## 11 Paperback Advice
## 12 Advice How-To and Miscellaneous
## 13 Chapter Books
## 14 Childrens Middle Grade
## 15 Childrens Middle Grade E-Book
## 16 Childrens Middle Grade Hardcover
## 17 Childrens Middle Grade Paperback
## 18 Paperback Books
## 19 Picture Books
## 20 Series Books
## 21 Young Adult
## 22 Young Adult E-Book
## 23 Young Adult Hardcover
## 24 Young Adult Paperback
## 25 Hardcover Graphic Books
## 26 Paperback Graphic Books
## 27 Manga
## 28 Combined Print Fiction
## 29 Combined Print Nonfiction
## 30 Animals
## 31 Audio Fiction
## 32 Audio Nonfiction
## 33 Business Books
## 34 Celebrities
## 35 Crime and Punishment
## 36 Culture
## 37 Education
## 38 Espionage
## 39 Expeditions Disasters and Adventures
## 40 Fashion Manners and Customs
## 41 Food and Fitness
## 42 Games and Activities
## 43 Hardcover Business Books
## 44 Health
## 45 Humor
## 46 Indigenous Americans
## 47 Relationships
## 48 Paperback Business Books
## 49 Family
## 50 Hardcover Political Books
## 51 Race and Civil Rights
## 52 Religion Spirituality and Faith
## 53 Science
## 54 Sports
## 55 Travel
## display_name
## 1 Combined Print & E-Book Fiction
## 2 Combined Print & E-Book Nonfiction
## 3 Hardcover Fiction
## 4 Hardcover Nonfiction
## 5 Paperback Trade Fiction
## 6 Paperback Mass-Market Fiction
## 7 Paperback Nonfiction
## 8 E-Book Fiction
## 9 E-Book Nonfiction
## 10 Hardcover Advice & Misc.
## 11 Paperback Advice & Misc.
## 12 Advice, How-To & Miscellaneous
## 13 Children’s Chapter Books
## 14 Children’s Middle Grade
## 15 Children’s Middle Grade E-Book
## 16 Children’s Middle Grade Hardcover
## 17 Children’s Middle Grade Paperback
## 18 Children’s Paperback Books
## 19 Children’s Picture Books
## 20 Children’s Series
## 21 Young Adult
## 22 Young Adult E-Book
## 23 Young Adult Hardcover
## 24 Young Adult Paperback
## 25 Hardcover Graphic Books
## 26 Paperback Graphic Books
## 27 Manga
## 28 Combined Hardcover & Paperback Fiction
## 29 Combined Hardcover & Paperback Nonfiction
## 30 Animals
## 31 Audio Fiction
## 32 Audio Nonfiction
## 33 Business
## 34 Celebrities
## 35 Crime and Punishment
## 36 Culture
## 37 Education
## 38 Espionage
## 39 Expeditions
## 40 Fashion, Manners and Customs
## 41 Food and Diet
## 42 Games and Activities
## 43 Hardcover Business Books
## 44 Health
## 45 Humor
## 46 Indigenous Americans
## 47 Love and Relationships
## 48 Paperback Business Books
## 49 Parenthood and Family
## 50 Politics and American History
## 51 Race and Civil Rights
## 52 Religion, Spirituality and Faith
## 53 Science
## 54 Sports and Fitness
## 55 Travel
## list_name_encoded oldest_published_date
## 1 combined-print-and-e-book-fiction 2011-02-13
## 2 combined-print-and-e-book-nonfiction 2011-02-13
## 3 hardcover-fiction 2008-06-08
## 4 hardcover-nonfiction 2008-06-08
## 5 trade-fiction-paperback 2008-06-08
## 6 mass-market-paperback 2008-06-08
## 7 paperback-nonfiction 2008-06-08
## 8 e-book-fiction 2011-02-13
## 9 e-book-nonfiction 2011-02-13
## 10 hardcover-advice 2008-06-08
## 11 paperback-advice 2008-06-08
## 12 advice-how-to-and-miscellaneous 2013-04-28
## 13 chapter-books 2008-06-08
## 14 childrens-middle-grade 2012-12-16
## 15 childrens-middle-grade-e-book 2015-08-30
## 16 childrens-middle-grade-hardcover 2015-08-30
## 17 childrens-middle-grade-paperback 2015-08-30
## 18 paperback-books 2008-06-08
## 19 picture-books 2008-06-08
## 20 series-books 2008-06-08
## 21 young-adult 2012-12-16
## 22 young-adult-e-book 2015-08-30
## 23 young-adult-hardcover 2015-08-30
## 24 young-adult-paperback 2015-08-30
## 25 hardcover-graphic-books 2009-03-15
## 26 paperback-graphic-books 2009-03-15
## 27 manga 2009-03-15
## 28 combined-print-fiction 2011-02-13
## 29 combined-print-nonfiction 2011-02-13
## 30 animals 2014-09-07
## 31 audio-fiction 2018-03-11
## 32 audio-nonfiction 2018-03-11
## 33 business-books 2013-11-03
## 34 celebrities 2014-09-07
## 35 crime-and-punishment 2014-10-12
## 36 culture 2014-10-12
## 37 education 2014-10-12
## 38 espionage 2014-12-14
## 39 expeditions-disasters-and-adventures 2014-12-14
## 40 fashion-manners-and-customs 2014-10-12
## 41 food-and-fitness 2013-09-01
## 42 games-and-activities 2014-10-12
## 43 hardcover-business-books 2011-07-03
## 44 health 2014-10-12
## 45 humor 2014-09-07
## 46 indigenous-americans 2014-12-14
## 47 relationships 2014-09-07
## 48 paperback-business-books 2011-07-03
## 49 family 2014-09-07
## 50 hardcover-political-books 2011-07-03
## 51 race-and-civil-rights 2014-12-14
## 52 religion-spirituality-and-faith 2014-09-07
## 53 science 2013-04-14
## 54 sports 2014-03-02
## 55 travel 2014-09-07
## newest_published_date updated
## 1 2019-04-07 WEEKLY
## 2 2019-04-07 WEEKLY
## 3 2019-04-07 WEEKLY
## 4 2019-04-07 WEEKLY
## 5 2019-04-07 WEEKLY
## 6 2017-01-29 WEEKLY
## 7 2019-04-07 WEEKLY
## 8 2017-01-29 WEEKLY
## 9 2017-01-29 WEEKLY
## 10 2013-04-21 WEEKLY
## 11 2013-04-21 WEEKLY
## 12 2019-04-07 WEEKLY
## 13 2012-12-09 WEEKLY
## 14 2015-08-23 WEEKLY
## 15 2017-01-29 WEEKLY
## 16 2019-04-07 WEEKLY
## 17 2017-01-29 WEEKLY
## 18 2012-12-09 WEEKLY
## 19 2019-04-07 WEEKLY
## 20 2019-04-07 WEEKLY
## 21 2015-08-23 WEEKLY
## 22 2017-01-29 WEEKLY
## 23 2019-04-07 WEEKLY
## 24 2017-01-29 WEEKLY
## 25 2017-01-29 WEEKLY
## 26 2017-01-29 WEEKLY
## 27 2017-01-29 WEEKLY
## 28 2013-05-12 WEEKLY
## 29 2013-05-12 WEEKLY
## 30 2017-01-15 MONTHLY
## 31 2019-03-17 MONTHLY
## 32 2019-03-17 MONTHLY
## 33 2019-03-17 MONTHLY
## 34 2017-01-15 MONTHLY
## 35 2017-01-15 MONTHLY
## 36 2017-01-15 MONTHLY
## 37 2017-01-15 MONTHLY
## 38 2017-01-15 MONTHLY
## 39 2017-01-15 MONTHLY
## 40 2017-01-15 MONTHLY
## 41 2017-01-15 MONTHLY
## 42 2017-01-15 MONTHLY
## 43 2013-10-13 MONTHLY
## 44 2017-01-15 MONTHLY
## 45 2017-01-15 MONTHLY
## 46 2016-01-10 MONTHLY
## 47 2017-01-15 MONTHLY
## 48 2013-10-13 MONTHLY
## 49 2017-01-15 MONTHLY
## 50 2017-01-15 MONTHLY
## 51 2017-01-15 MONTHLY
## 52 2017-01-15 MONTHLY
## 53 2019-03-17 MONTHLY
## 54 2019-03-17 MONTHLY
## 55 2017-01-15 MONTHLY