ETL Challenge

For my project, I first looked at a dataset from data.world regarding New York Times Bestsellers from 2011 to 2018 and the number of weeks each book was on the list (source: https://data.world/typhon/new-york-times-bestsellers-from-2011-to-2018).

I also utilized three APIs in this project: Google Books, ISBNdb, and Goodreads. From the first two APIs I extracted ISBN13 information, while the Goodreads API was used to obtain the average rating, total number of ratings, and total number of text reviews on the site for each book. Each API request returned a response in JSON format, which was then examined to extract the necessary data. More detail regarding the data extraction, transformation, and loading process can be found here: ETL Report.