👩⚖️ Disclaimer: I’m a coder, not a legal advisor or professional. In this article, I merely present my own judgment and research on the topic. But this is not legal advice! Legal Opinion 1: Web Scraping is Legal [Apify] “Web scraping is legal if you scrape data publicly available on the internet. But you should … Read more
Problem Formulation 💬 Given a text query/keyword such as “History of Chess”. How to scrape the top Google results for that search query (=keyword) in Python? Disclaimer: Have a look at the important question: Is Web Scraping Legal? Method Summary You can get the top Google search results given a certain keyword string by installing … Read more
This tutorial is drawn from my book The Art of Clean Code (NoStarch 2022): Write Clean & Simple Code Story: I learned to focus on writing clean code the hard way. One of my research projects during my time as a doctoral researcher in distributed systems was to code a distributed graph processing system from … Read more
Before we learn about the money, let’s get this question out of the way: What is Tableau? Let’s have a look at the definition inspired by the official Tableau website: Tableau is a visual data analytics platform focused on the business analytics use case that helps you use data to solve problems. It is great … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to reverse a Dictionary in Python. To make it more fun, we have the following running scenario: We have a Python Dictionary containing three (3) users who are signed up at the Finxter Academy. The current key:value pairs consist of username:id. The owner would … Read more
Problem Formulation Say, you want to find a regex pattern in a given string. You know the pattern exists in the string. You use the re.match(pattern, string) function to find the match object where the pattern matches in the string. 💬 Problem: The Python regular expression pattern is not found in the string. The pattern … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to print the contents of a List without surrounding brackets in Python. To make it more fun, we have the following running scenario: You are a student and need to memorize the first 10 elements in the Periodic Table. This data is currently saved … Read more
This article will examine the Bitcoin price predictions of many experts in the broad finance and investment industry. Methodology: Experts were selected with a breadth of understanding and reputation in the financial industry. Disclaimer: This is 100% subjective, and we neither recommend buying or selling BTC as a result of this study. We are no … Read more
What is Data Cleaning? Data cleaning describes the process of turning messy data into clean datasets that can be used for research and data science purposes. For example, tidy data will be in a wide format: every column contains a variable, and every row contains one case. Also, data cleaning means getting rid of corrupt … Read more
Today, I stumbled upon this beautiful regex problem: Given are a multi-line string and a regex pattern. How to find all lines that do NOT contain the regex pattern? I’ll give you a short answer and a long answer. The short answer: Use the pattern ‘((?!regex).)*’ to match all lines that do not contain regex … Read more
Before we learn about the money, let’s get this question out of the way: What is a Database Administrator? A database administrator (DBA) is an IT professional responsible for maintaining the reliable, efficient, and secure execution of a database management system (DBMS). In this way, a database administrator is responsible for providing the data infrastructure … Read more
Problem Formulation and Solution Overview This article will show you how to count duplicates in a Pandas DataFrame in Python. To make it more fun, we have the following running scenario: Rivers Clothing has a CSV containing all its employees. However, their CSV file has more rows than employees. This is a definite problem! They … Read more