How to Interpolate Strings

Problem Formulation and Solution Overview This article will show you how to interpolate strings in Python. ℹ️ Interpolation is used when a string contains a placeholder for a variable or a calculation. The string is evaluated, and the placeholder is replaced by the passed data. To make it more interesting, we have the following running … Read more

How to Export MySQL to a CSV (Dashboard+Python)

This article shows you how to export a Database Table to a CSV file using MySQL. ℹ️ SQL, an acronym for Structured Query Language, is the language of the Database! This standardized language is used to manage databases, tables and the data they hold. A must-have in the coding world. This language allows coders to … Read more

Parsing XML Files in Python – 4 Simple Ways

Problem Formulation and Solution Overview This article will show you various ways to work with an XML file. ℹ️ XML is an acronym for Extensible Markup Language. This file type is similar to HTML. However, XML does not have pre-defined tags like HTML. Instead, a coder can define their own tags to meet specific requirements. … Read more

How to Schedule a Batch Python Script

Problem Formulation and Solution Overview During your career as a Pythonista, you will encounter situations where a Python script will need to be executed on a scheduled basis, such as daily, weekly, or monthly. This article shows you how to accomplish this task using a .bat (batch) file. 💬 Question: How would we write code … Read more

How to Get the First Character of a String

Problem Formulation and Solution Overview This article will show different ways to extract the first character of a Python string. To make it more interesting, we have the following scenario: The Government has asked Rivers Clothing to complete forms for each employee. These forms require the first character of the employee’s first name and their … Read more