Importing data from a .csv file into a MySQL database using Workbench’s data import wizard is notoriously slow. My recent import of a (500000, 6) shaped table into MySQL using the wizard took over...

Streamlit is a Python library used to convert pure python scripts into web apps. This is an exploration of Streamlit’s capabilities to build a dashboard. Plan Build a dashboard with at least on...

Pickle is the native data serialization module for Python.1 It is the simplest and most effective way for storing and sharing Python data in the short-term. Data Serialization It is the process of...

A common approach to storytelling is to “Drill Down” and to “Zoom Out”. This is the idea of starting with the larger picture before getting into the finer details and vice versa. We’re going ...

Overlapping text labels on the x-axis is a common challenge during visualizations. To mitigate, we can rotate the labels by an angle to create more space, implement text wrapping for multi-line v...

When working with categorical data, simplifying the analysis is often beneficial by either combining or eliminating less significant categories. This might arise due to the rare frequency of said...

A decorator is a function or a class that wraps (or decorates) a function or a method, modifying their coded behaviour. A simple definition: Decorator is a design pattern that attaches addition...

Python 3.8 brought about a new assignment expression that trims your length of code and improves readability. Let me explain how: The Operator := ➡ The walrus operator assigns values to variables...

The Problem We have data organised for analysis in a DataFrame. The first step is to figure out the quantitative and categorical columns. Among the categorical columns, we’re always intereste...

What’s a Ragged Nested Sequence? A ragged nested sequence is defined in Python as a list-or-tuple of lists-or-tuples-or ndarrays with different lengths or shapes. Essentially it’s an array of arr...