This project involves web scraping data from Books to Scrape — an online mock bookstore. The data was cleaned, stored in a MySQL database, analyzed using SQL, and visualized using Python libraries to uncover insights related to book pricing, ratings, availability, and categories.
Scrapes 1000 books from 50 pages using BeautifulSoup
Extracts title, price, rating, availability
Cleans and stores data in MySQL using mysql.connector
Performs SQL queries for business insights
Visualizes:
Price distribution
Rating frequency
Book availability
Category-based trends
Majority of books are priced under £30
Most books hold a 3-star rating
Fiction and Nonfiction dominate the dataset
Availability is generally balanced
High-priced books are rare and often in limited stock