Kat McKelvie Problem Formulation and Solution Overview This article will show you how to create a Virtual Environment inside the Visual Studio Code, the VSC Editor. Virtual Environments are best used when a coder or several coders work together to develop medium to large-scale applications. The best approach is to keep this code and associated libraries and … Read more
Problem Formulation and Solution Overview This article shows how to generate a formatted PDF file from a CSV file using the ReportLab and Pandas libraries in conjunction with slicing. ℹ️ Python offers numerous ways to generate a PDF file. One option is to use the ReportLab library. The article selected the path that used the … Read more
Problem Formulation and Solution Overview This article will show you how to import external Python code and use this code in another Python script. To make it more interesting, we have the following running scenario: 👩🏫 Fun Example: Pam, a High School Teacher, wants an easier way to calculate exam totals and produce student averages. … Read more
Problem Formulation and Solution Overview This article will show you how to create, update and query a SQLite database using Python. ℹ️The SQLite database is a great choice! It is self-contained, easy to use, easy to learn, and works on other devices, such as game consoles, mobile phones, and so on! To make it more … Read more
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
Problem Formulation and Solution Overview This article will show you how to copy a Dictionary in Python 7 different ways. To make it more interesting, we have the following running scenario: Mr. Smith, a High School Math Teacher, has developed an exciting way to grade multiple-choice exams. He has designed a Dictionary with the exam … Read more
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
This article shows you how to execute Python commands in the Shell. ℹ️ The Shell is known as a command-line interface because it interacts with the Operating System. In Windows, it is referred to as the Command Prompt. In Linux, the Terminal. Let’s start learning how to use the Shell! Access the Shell This section … Read more
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
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
Problem Formulation and Solution Overview This article will show you how to create and execute a batch file in Python. ℹ️ Info: A batch or .bat file is a file that contains commands to be executed in the order specified. This file type can organize and automate tasks that need to be run regularly without … Read more
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