Title: Web Scraping Books and Creating DataFrame

Introduction

This Python script is designed to scrape data from a website containing books in the "Mystery" category and create a DataFrame for further manipulation and preprocessing. It utilizes the requests, BeautifulSoup, and pandas libraries for web scraping and data manipulation.

Requirements

Python 3.x
requests library
BeautifulSoup library
pandas library

Installation

Ensure you have Python 3.x installed on your system. If not, download it from the official Python website (https://www.python.org/downloads/) and install it.
Install the required libraries by running the following commands in your terminal or command prompt:

pip install requests
pip install beautifulsoup4
pip install pandas

How to Use

Clone or download the script from the GitHub repository (provide GitHub repository link here).
Open the script using your favorite Python IDE or text editor.
Modify the url variable in the script to point to the starting page of the "Mystery" books category you want to scrape.
Run the script. It will scrape data from multiple pages of the category and store it in a DataFrame.
The resulting DataFrame will contain information about book titles, prices, and star ratings.

Usage Example

import requests
from bs4 import BeautifulSoup
import pandas as pd

# a function for scraping content from the URL
def scrape_url(url):
  response = requests.get(url)
  response = response.content
  soup = BeautifulSoup(response, 'html.parser')
  return soup

# Starting URL for the "Mystery" category
url = 'https://books.toscrape.com/catalogue/category/books/mystery_3/index.html'
print(scrape_url(url))

# extracting data from the content
data1 = []
for i in range(1, 51):
  url = f'https://books.toscrape.com/catalogue/page-{i}.html'
  response = requests.get(url)
  response = response.content
  soup = BeautifulSoup(response, 'html.parser')
  ol = soup.find('ol')
  articles = ol.find_all('article', class_='product_pod')

  for article in articles:
    title_element = article.find('h3')
    title = title_element.get_text(strip=True)
    price_element = soup.find('p', class_='price_color')
    price = price_element.get_text(strip=True)
    star_element = article.find('p')
    star = star_element['class'][1] if star_element else None
    data1.append({"title": title, "Price": price, "Star": star})

# data stored in DataFrame to easily manipulate and preprocess
df = pd.DataFrame(data1)

Output

The script will produce a DataFrame containing information about the books in the "Mystery" category, including book titles, prices, and star ratings.

Author

[@Hk669].

Feel free to use and modify this script as per your requirements. If you encounter any issues or have suggestions for improvements, please don't hesitate to create an issue or pull request on the GitHub repository. Happy scraping and data analysis!