E-commerce Laptop Market Analysis – Jumia Egypt
? Project Summary
This project delivers a comprehensive analysis of laptop listings on Jumia Egypt, focusing on pricing trends, product availability, and rating patterns. The goal was to uncover insights into the Egyptian e-commerce landscape for laptops and present them through a clean, interactive Power BI dashboard.
? Data Collection & Processing
- Source: Jumia Egypt – Laptops category
- Pages Scraped: 10
- Tools Used: Python (BeautifulSoup, Requests), Pandas, Power BI
- Fields Extracted: Product Name, Price, Rating, Product Link, Image URL, Availability
Key Steps:
- Web Scraping
- Automated extraction of product data using BeautifulSoup
- Captured structured data across multiple pages
- Data Cleaning
- Removed duplicates and null entries
- Converted price strings to numeric format
- Standardized availability and rating fields
- Exploratory Data Analysis (EDA)
- Visualized price distribution and rating gaps
- Identified top-pri