Data Extraction

Recently, I had to process >100 excel sheets saved as a single excel file/workbook. It was worrisome to think about cleaning each of the sheets and plotting them individually. …

In recent years, data has played a significant part in making decisions that contribute to the success of a firm or sector. Web scraping is one of the most common tools used by businesses to collect massive amounts of data for analysis. Building a small scraper that extracts a few…

You face high competition as an Amazon seller. Maintaining a brand identity is important for sustaining customer attraction. The Minimum Advertised Price (MAP) is one such area that requires your attention. Sellers that break Amazon’s MAP compliance rules might damage your brand’s reputation, lowering your ROI in the long term. MAP Meaning …

Web Scraping is incomplete without data extraction from the raw HTML or XML you get from the target website. When it comes to web scraping then Python is the most popular choice among programmers because it has great community support and along with that, it is very easy to code…

Hi, hope everyone is fine, it's been a long time. Today I have an interesting topic i.e. REGEX. A string of characters that creates a search pattern is known as a regex or regular expression. Regular expressions are a programming language used to parse and manipulate text. …

We all know that the very first step in data analysis or data science is obtaining the data itself. The source of the data can vary widely. The data in most cases are unstructured, hidden safely under 5,6 layers of HTML wrappers, making our life difficult. In this section, we…

You’ve probably come across scanned/ screenshot files like images and PDFs with tables that you needed to extract but didn’t have the willingness and time to do it manually. Wouldn’t it be great if you could extract the data from those tables without typing it all out by hand? If…

We at Blocktorch continue to explore the present solutions for building an ETL pipeline to work with on-chain data. In our previous blog posts, we covered the simple methods on how to fetch Ethereum blocks and even mentioned The Graph when talking about logs and the importance of their management. …

Web Scraping | Web data extraction | Screen Scraping | Web Harvesting | Power Automate Desktop — Data is everywhere, the challenge is how to get them, and is not that hard either. If you are familiar with python and beautiful soup, you must have known how to get data over a webpage or so-called web scraping. But if you are not familiar with coding, this article…