In this comprehensive video (1 hour 5 minutes), we create a professional web scraping project with Python and Playwright, step by step. From website analysis to data export to Excel, you'll learn how to scrape discounted products on CDiscount, manage captchas, navigate Playwright like a human, and clean data like a pro. In short: a real-world project 💼
📌 What you'll learn:
✔️ Analyze a website before scraping
✔️ Manage filters and cookies
✔️ Solve CAPTCHAs with Bright Data
✔️ Navigate with Playwright (without headless browsing!)
✔️ Extract the right elements (prices, titles, URLs, promotions)
✔️ Loop through pages (dynamic pagination)
✔️ Clean and format prices
✔️ Export to two Excel files (with and without promotions)
✔️ Log errors, monitor execution, and debug
📌 Video chapters:
00:00 - Introduction
00:52 - Website analysis (CDiscount)
04:50 - Project creation (PyCharm + Env) (Virtual)
06:48 - Plan of functions to code
08:25 - Draft & Playwright setup
11:11 - Solving Captchas with Bright Data
15:04 - Managing filters (12 inches)
34:03 - Loop Items & Data Extraction
47:15 - Exporting to Excel (products & promotions)
56:47 - Smart Pagination
01:03:52 - Launching the final script
🔗 Links & Resources:
📥 Download Octoparse → https://bit.ly/3F3r3rl
🎯 First 100 B2B leads free → https://scrap.id/s/1xY
🧠 Playwright Documentation (Python) → https://playwright.dev/python/docs/intro
💡 Date format → https://strftime.org/
📘 Python Logging → https://docs.python.org/3/library/log...
🧩 Bright Data Credits ($10 offered) → https://brdta.com/francoisdufaurboidin
📩 Need a Web Scraping Service? → [email protected]
🌐 URL used in the video:
→ https://www.cdiscount.com/informatiqu...
💡 Tech Stack:
Python 3.12
PlayWright (Synchronous API)
Pandas & OpenPyXL
Logging & Error Handling
Proxies & Anti-CAPTCHA with Bright Data
🔔 If this training helped you, like, comment, and subscribe to support the channel! Next step: a project with a form and authentication 🔐? 👀
#WebScraping #Python #Playwright #PythonTraining #Scraping #DataExtraction #Ecommerce #Automation #BrightData #Excel