Lesson 9 – Data Scraping
Intro:A big bookstore wants you to make a robot, that automatically can data scrape (web scrape) book prices at their competitor Amazon. What you will learn: Primarily Data Scraping Secondarily: Excel/Data Table work Browser Work General RPA Best Practice Client name:Barnes Noble Bookstore Process Name:Datascraping Description:Our client Barnes Noble Bookstore wants to have a robot, […]
Intro:
A big bookstore wants you to make a robot, that automatically can data scrape (web scrape) book prices at their competitor Amazon.
What you will learn:
- Primarily
- Data Scraping
- Secondarily:
- Excel/Data Table work
- Browser Work
- General RPA Best Practice
Client name:
Barnes Noble Bookstore
Process Name:
Datascraping
Description:
Our client Barnes Noble Bookstore wants to have a robot, that can scrape all book data from their competitor Amazon:
- Read this Excel File
- Open Amazon
- Do a search for each of the topics in the Excel file
- Data Scrape the search results (remember ALL pages) to seperate Excel sheets with names of the topic
- Data to be stored about the book:
- Title
- URL
- Author
- Price