Streaming platforms such as Netflix and Amazon Prime Video increasingly rely on book-to-screen adaptations to attract audiences. However, adaptation success is influenced by multiple factors, including source material quality, genre, adaptation format, and audience reception.
This project presents a comparative analysis of book adaptations available on Netflix and Amazon Prime Video by integrating data from multiple sources, including Wikipedia, IMDb, and Goodreads. The study investigates adaptation quality, genre preferences, popularity, and the relationship between book ratings and screen adaptation ratings.
The final dataset consists of 249 confirmed book adaptations released between 2015 and 2026.
- Compare adaptation quality across Netflix and Amazon Prime Video.
- Analyze the relationship between Goodreads ratings and IMDb ratings.
- Examine genre preferences and their influence on audience reception.
- Compare the performance of movie and series adaptations.
- Investigate temporal trends in adaptation ratings.
- Explore the relationship between popularity and audience ratings.
The final integrated dataset contains the following attributes:
| Column | Description |
|---|---|
| Title | Name of the adaptation |
| Premiere | Release date |
| Rated | Content certification |
| imdb_rating | IMDb audience rating |
| imdb_votes | Number of IMDb votes |
| imdb_genre | Genres associated with the adaptation |
| imdb_year | Release year |
| imdb_type | Movie or Series |
| platform | Streaming platform |
| book_title | Source book title |
| book_author | Author of the source book |
| goodreads_rating | Goodreads rating of the source book |
- Netflix and Amazon original titles were collected through web scraping from Wikipedia.
- IMDb metadata was retrieved using the OMDb API.
- Each title was manually verified to determine whether it was based on a book.
- Only confirmed book adaptations were retained for further analysis.
- A Goodreads dataset obtained from Kaggle was used as the primary source.
- Extensive preprocessing was performed to standardize titles and author names.
- Exact and fuzzy matching techniques were applied to maximize successful matches.
- Unmatched books were manually verified and collected from Goodreads to ensure complete coverage.
- Invalid and excluded records were removed.
- Book titles were manually corrected where necessary.
- Unnecessary intermediate columns were dropped.
- Missing values and duplicate records were verified.
- The final cleaned dataset was prepared for exploratory data analysis.
book_adaptations/
│
├── data/
│ ├── books/
│ │ ├── raw/
│ │ ├── processed/
│ │ └── final/
│ │
│ ├── movies/
│ │ ├── raw/
│ │ ├── processed/
│ │ └── final/
│ │
│ ├── series/
│ │ ├── raw/
│ │ ├── processed/
│ │ └── final/
│ │
│ └── final/
│ └── book_adaptations.csv
│
├── notebooks/
│ ├── 01_series_data_collection.ipynb
│ ├── 02_movies_data_collection.ipynb
│ ├── 03_book_data_collection.ipynb
│ ├── 04_data_cleaning.ipynb
│ └── 05_data_analysis.ipynb
│
├── visuals/
│ ├── correlation_heatmap.png
│ ├── genre_ratings.png
│ ├── goodreads_vs_imdb.png
│ ├── imdb_rating_distribution.png
│ ├── movies_vs_series.png
│ ├── platform_comparison.png
│ ├── platform_genre_comparison.png
│ ├── top_popular_adaptations.png
│ └── top_rated_adaptations.png
│
└── README.md
The project was completed using the following workflow:
- Web scraped Netflix and Amazon original titles from Wikipedia.
- Retrieved IMDb metadata using the OMDb API.
- Manually verified whether each title was adapted from a book.
- Integrated Goodreads ratings using a combination of automated matching and manual verification.
- Performed extensive data cleaning and preprocessing.
- Conducted exploratory data analysis to identify patterns, trends, and relationships.
- Generated visualizations to communicate findings effectively.
- Most adaptations receive moderate IMDb ratings, with the majority clustered between ratings of 6 and 7.
- Streaming platforms tend to adapt books that have already received positive reader reception, with Goodreads ratings concentrated around 4.0.
- Goodreads ratings exhibit only a moderate relationship with adaptation ratings, suggesting that highly rated books do not always result in successful adaptations.
- Drama is the dominant genre across both platforms, while historical and biographical adaptations tend to achieve the highest audience ratings.
- Series adaptations consistently outperform movie adaptations, indicating that episodic storytelling may be better suited for adapting literary works.
- Amazon and Netflix exhibit remarkably similar adaptation quality despite differences in catalog size.
- Popular adaptations tend to receive higher audience ratings, although popularity alone does not guarantee critical success.
IMDb Rating Distribution
|
Goodreads Rating vs IMDb Rating
|
Movies vs Series Comparison
|
Platform Comparison
|
Genre Distribution Across Platforms
|
Correlation Heatmap
|
- The dataset contains substantially more Netflix adaptations than Amazon adaptations because Netflix data was collected from multiple Wikipedia pages, whereas Amazon data was obtained from a single Wikipedia source.
- Data collection relied primarily on publicly available Wikipedia pages; therefore, some adaptations may be missing.
- Goodreads and IMDb ratings are user-generated and may reflect subjective preferences and demographic biases.
- Certain years, genres, and genre combinations contain relatively few observations.
- Correlation analyses identify associations but do not establish causal relationships.
Potential extensions of this project include:
- Building machine learning models to predict adaptation success.
- Incorporating additional streaming platforms such as Disney+, Hulu, and Apple TV+.
- Expanding the dataset to include more adaptation metadata, such as budgets, runtime, and production studios.
- Investigating sentiment analysis using audience reviews.
- Performing network analysis between authors, genres, and adaptation performance.
- Python
- Pandas
- NumPy
- Matplotlib
- Seaborn
- Requests
- BeautifulSoup
- RapidFuzz
- Jupyter Notebook
- OMDb API
Devashree Kinjale
If you found this project interesting, feel free to explore the notebooks and visualizations included in this repository.
This project is licensed under the MIT License. See the LICENSE file for more details.
If you use or reference this work, please provide appropriate attribution.





