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
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
Problem Formulation and Solution Overview In this article, you’ll learn how to check a List for Duplicates in Python. To make it more fun, we have the following running scenario: The Finxter Academy has given you an extensive list of usernames. Somewhere along the line, duplicate entries were added. They need you to check if … 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
To update a key in a dictionary if it doesn’t exist, you can check if it is present in the dictionary using the in keyword along with the if statement, and then update the key-value pair using subscript notation or update() method or the asterisk * operator. This approach will be examined in Section 1 … 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
What is Fuzzing? Fuzz testing (or fuzzing) is an automated software testing method with the goal to find vulnerabilities, security issues, and defects of the application. The idea is to inject invalid, malformed, or unexpected inputs into the application using a fuzzing tool and observing how the system reacts to those inputs (e.g., exceptions, leakage … 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
What is Try/Except in Python? Python’s try and except keywords are used to ‘catch’ an exception and handle it, preventing it from terminating your program as it normally would. This could be useful in situations where you know there’s potential for an exception to occur, and you want your program to be able to continue … Read more
Summary: To print colored text in Python, you can use: The simple_color package, The ‘\033[1m’ ANSI escape-sequence, The termcolor module, The coloroma package, The colored library, The prompt_toolkit package. A simple, no-library way to print bolded text in Python is to enclose a given string s in the special escape sequence like so: print(“\033[38;5;4m”). We’ll … Read more
💬 Question: How to redirect the standard output in Python and store it as a string in a variable? This article will guide you through seven easy steps to solve this problem. As an overview, here’s the code in eight lines that stores the standard output in a variable my_result: from io import StringIO import … Read more