The New York Times web site provides a rich set of APIs, as described here: https://developer.nytimes.com/apis 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 into an R DataFrame.
library(jsonlite)
library(httr)
library(purrr)##
## Attaching package: 'purrr'## The following object is masked from 'package:jsonlite':
##
## flattenurl <- "https://api.nytimes.com/svc/books/v3/lists/names.json?api-key=POly7DhxmA60a8GvBxlAvolA9ZLaQvkA"
json_data <- fromJSON(url)
raw_data <- json_data$results
colnames(raw_data)## [1] "list_name" "display_name" "list_name_encoded"
## [4] "oldest_published_date" "newest_published_date" "updated"I entered the raw JSON data from the API into a dataframe that I named raw_data. Upon doing this, I extracted the column names to see how this dataframe should be structured. I then extracted the specific columns and entered this data into a dataframe to this display my API data.
list_name <- raw_data$list_name
display_name <- raw_data$display_name
list_name_encoded <- raw_data$list_name_encoded
oldest_published_date <- raw_data$oldest_published_date
newest_published_date <- raw_data$newest_published_date
updated <- raw_data$updated
APIdf <- data.frame(
list_name = list_name,
display_name = display_name,
list_name_encoded = list_name_encoded,
oldest_published_date = oldest_published_date,
newest_published_date = newest_published_date,
updated = updated)Upon completing this data tidying and transformation, my data was entered into a dataframe that I named ‘APIdf’ This displays the data that the API has provided to me
# Displaying the dataframe
print(APIdf)## 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 Hardcover Graphic Books
## 14 Paperback Graphic Books
## 15 Manga
## 16 Combined Print Fiction
## 17 Combined Print Nonfiction
## 18 Chapter Books
## 19 Childrens Middle Grade
## 20 Childrens Middle Grade E-Book
## 21 Childrens Middle Grade Hardcover
## 22 Childrens Middle Grade Paperback
## 23 Paperback Books
## 24 Picture Books
## 25 Series Books
## 26 Young Adult
## 27 Young Adult E-Book
## 28 Young Adult Hardcover
## 29 Young Adult Paperback
## 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 Graphic Books and Manga
## 44 Hardcover Business Books
## 45 Health
## 46 Humor
## 47 Indigenous Americans
## 48 Relationships
## 49 Mass Market Monthly
## 50 Middle Grade Paperback Monthly
## 51 Paperback Business Books
## 52 Family
## 53 Hardcover Political Books
## 54 Race and Civil Rights
## 55 Religion Spirituality and Faith
## 56 Science
## 57 Sports
## 58 Travel
## 59 Young Adult Paperback Monthly
## 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 Hardcover Graphic Books
## 14 Paperback Graphic Books
## 15 Manga
## 16 Combined Hardcover & Paperback Fiction
## 17 Combined Hardcover & Paperback Nonfiction
## 18 Children’s Chapter Books
## 19 Children’s Middle Grade
## 20 Children’s Middle Grade E-Book
## 21 Children’s Middle Grade Hardcover
## 22 Children’s Middle Grade Paperback
## 23 Children’s Paperback Books
## 24 Children’s Picture Books
## 25 Children’s Series
## 26 Young Adult
## 27 Young Adult E-Book
## 28 Young Adult Hardcover
## 29 Young Adult Paperback
## 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 Graphic Books and Manga
## 44 Hardcover Business Books
## 45 Health
## 46 Humor
## 47 Indigenous Americans
## 48 Love and Relationships
## 49 Mass Market
## 50 Middle Grade Paperback
## 51 Paperback Business Books
## 52 Parenthood and Family
## 53 Politics and American History
## 54 Race and Civil Rights
## 55 Religion, Spirituality and Faith
## 56 Science
## 57 Sports and Fitness
## 58 Travel
## 59 Young Adult Paperback
## 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 hardcover-graphic-books 2009-03-15
## 14 paperback-graphic-books 2009-03-15
## 15 manga 2009-03-15
## 16 combined-print-fiction 2011-02-13
## 17 combined-print-nonfiction 2011-02-13
## 18 chapter-books 2008-06-08
## 19 childrens-middle-grade 2012-12-16
## 20 childrens-middle-grade-e-book 2015-08-30
## 21 childrens-middle-grade-hardcover 2015-08-30
## 22 childrens-middle-grade-paperback 2015-08-30
## 23 paperback-books 2008-06-08
## 24 picture-books 2008-06-08
## 25 series-books 2008-06-08
## 26 young-adult 2012-12-16
## 27 young-adult-e-book 2015-08-30
## 28 young-adult-hardcover 2015-08-30
## 29 young-adult-paperback 2015-08-30
## 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 graphic-books-and-manga 2019-10-13
## 44 hardcover-business-books 2011-07-03
## 45 health 2014-10-12
## 46 humor 2014-09-07
## 47 indigenous-americans 2014-12-14
## 48 relationships 2014-09-07
## 49 mass-market-monthly 2019-10-13
## 50 middle-grade-paperback-monthly 2019-10-13
## 51 paperback-business-books 2011-07-03
## 52 family 2014-09-07
## 53 hardcover-political-books 2011-07-03
## 54 race-and-civil-rights 2014-12-14
## 55 religion-spirituality-and-faith 2014-09-07
## 56 science 2013-04-14
## 57 sports 2014-03-02
## 58 travel 2014-09-07
## 59 young-adult-paperback-monthly 2019-10-13
## newest_published_date updated
## 1 2024-03-31 WEEKLY
## 2 2024-03-31 WEEKLY
## 3 2024-03-31 WEEKLY
## 4 2024-03-31 WEEKLY
## 5 2024-03-31 WEEKLY
## 6 2017-01-29 WEEKLY
## 7 2024-03-31 WEEKLY
## 8 2017-01-29 WEEKLY
## 9 2017-01-29 WEEKLY
## 10 2013-04-21 WEEKLY
## 11 2013-04-21 WEEKLY
## 12 2024-03-31 WEEKLY
## 13 2017-01-29 WEEKLY
## 14 2017-01-29 WEEKLY
## 15 2017-01-29 WEEKLY
## 16 2013-05-12 WEEKLY
## 17 2013-05-12 WEEKLY
## 18 2012-12-09 WEEKLY
## 19 2015-08-23 WEEKLY
## 20 2017-01-29 WEEKLY
## 21 2024-03-31 WEEKLY
## 22 2017-01-29 WEEKLY
## 23 2012-12-09 WEEKLY
## 24 2024-03-31 WEEKLY
## 25 2024-03-31 WEEKLY
## 26 2015-08-23 WEEKLY
## 27 2017-01-29 WEEKLY
## 28 2024-03-31 WEEKLY
## 29 2017-01-29 WEEKLY
## 30 2017-01-15 MONTHLY
## 31 2024-03-17 MONTHLY
## 32 2024-03-17 MONTHLY
## 33 2024-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 2024-03-17 MONTHLY
## 44 2013-10-13 MONTHLY
## 45 2017-01-15 MONTHLY
## 46 2017-01-15 MONTHLY
## 47 2016-01-10 MONTHLY
## 48 2017-01-15 MONTHLY
## 49 2024-03-17 MONTHLY
## 50 2024-03-17 MONTHLY
## 51 2013-10-13 MONTHLY
## 52 2017-01-15 MONTHLY
## 53 2017-01-15 MONTHLY
## 54 2017-01-15 MONTHLY
## 55 2017-01-15 MONTHLY
## 56 2019-09-15 MONTHLY
## 57 2019-09-15 MONTHLY
## 58 2017-01-15 MONTHLY
## 59 2024-03-17 MONTHLY