ChrisEnglish/US keyboards are QWERTY keyboards, again named after the first six letters on the keyboard. Here’s a screenshot of an English/US “QWERTY” keyboard layout: German/European keyboards are QWERTZ keyboards, named after the first six letters on the keyboard. Here’s a screenshot of a German “QWERTZ” keyboard layout: 💬 Question: How to switch between German and … Read more
👩⚖️ 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 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
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
Are you frustrated coding dummy projects in order to learn Python? This article gives you 20 highly practical code projects that you can solve by yourself. Learn while you earn to improve your skills! If you want to learn about how much money you can expect to earn as a Python freelancer, grab your free … Read more
Before we learn about the money, let’s get this question out of the way: What is a Database Engineer? A database engineer is responsible for providing the data infrastructure of a company or organization. This involves designing, creating, installing, configuring, debugging, optimizing, securing, and managing databases. Database engineers can either work as employees or as … Read more
💬 Question: Say you have an expression you want to execute using the exec() function. How to store the result of the expression in a Python variable my_result? Before I show you the solution, let’s quickly recap the exec() function: Recap Python exec() Python’s exec() function executes the Python code you pass as a string … Read more
💬 Question: Say you have an expression you want to execute using the eval() function. How to store the result of the expression in a Python variable my_result? Before I show you the solution, let’s quickly recap the eval() function: Recap Python eval() Python eval(s) parses the string argument s into a Python expression, runs … Read more