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

Write a comment