Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Web Scraping Feasibility
#1
I recently started a new role in data analytics.

One of my daily tasks is as follows:
1. Log in to www.SalesRabbit.com
2. Navigate to a new page within the site using a sidebar
3. Manually copy-paste sales data from a table to Excel file.

I have no background in Python but saw information regarding Web Scraping and getting past a log-in page.

My question is: Is it possible to automate a process using Python that will go to the website, navigate to the new page, and pull the required data to an output file?
Reply
#2
Yeah, you can do all that. The process is a bit longer than you think though. I'll try to break it down.

1. Use Selenium to Log in.
2. Use the Beautiful Soup library to parse the data.
3. openpyxl library to write the data to excel.
Reply
#3
there is an API, so it's definitely worth checking if the information is available via API
https://developers.salesrabbit.com/v1/ge...troduction
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020