xlsx_copycull VS Scrapy

And I also posted about another module I wrote for generating copies of spreadsheets and culling each down to whatever subset of rows I need. This also weirdly finds a lot of uses in a world of clients and coworkers who use spreadsheets for way too many things.

Introducing xlsx_copycull, a tool to copy a 'master' spreadsheet and delete any unnecessary rows, and optionally add in Excel formulas. It's a hideous cousin of SELECT * FROM table WHERE condition.

BeautifulSoup4 Scrapy

While there is no specific library for SERP, there are some web scraping libraries that can do the Google Search Page Ranking. One of them which is quite famous is Scrapy - It is a fast high-level web crawling and web scraping framework, used to crawl websites and extract structured data from their pages. It offers rich developer community support and has been used by more than 50+ projects.

If you're looking for a turn-key solution, I'd have to dig a little. I generally write a scraper in python that dumps into a database or flat file (depending on number of records I'm hunting).

Scraping is a separate subject, but once you write one you can generally reuse relevant portions for many others. If you can get adept at a scraping framework like Scrapy you can do it fairly quickly, but there aren't many tools that work out of the box for every site you'll encounter.

Once you've written the spider, it's generally able to be rerun for updates unless the site code is dramatically altered. It really comes down to how brittle the spider is coded (i.e. hunting for specific heading sizes or fonts or something) instead of grabbing the underlying JSON/XHR that doesn't usually change frequently.

1. https://scrapy.org

Scrapy capitalizes headers for request

Scrapy is a web scraping toolkit

I know this might not be a good answer, as it's not .NET, but we use https://scrapy.org/ (Python).