Posts
All the articles I've posted.
-
How to Aggregate Values by Date and Sum Them in Python
Problem Statement Suppose you have a list of transactions or events, each associated with a date and a numeric value (e.g., sales amount, transaction amount). Your goal is to aggregate these values by
-
Understanding Data Layout, Files, and Tree Indexes: An Overview
In this post, we'll explore several fundamental concepts related to data storage and indexing: Data Layout, Files, Tree Indexes, and B+ Trees. Understanding these concepts is crucial for anyone
-
Effective Knowledge Transfer of Data: Key Elements
Transferring knowledge, especially when it involves data, is a critical proces. Especially between consultants. Whether you're transitioning to a new team, it's crucial to get this process right. Here
-
Understanding MAC Addresses: Hexadecimal, Binary, and Decimal Representations
In this post, we'll explore what a MAC address is, how it's represented in hexadecimal notation, and how to convert it to binary and decimal formats. We'll use the MAC address 88-B2-2F-54-1A-0F as an
-
Creating Directories in Python
The os Module Python’s os module provides a way to interact with the operating system. It includes functions for creating, removing, and checking the existence of directories and files. In this
-
Route Summarization and Subnetting
We will walk through the process of subnetting a network and performing route summarization using an example. Subnetting Example Let's consider the following four subnets: 192.168.0.0/22
-
Pandas Dataframe: apply method
Calculating Discounts, Taxes, and Total Amount in a DataFrame Suppose you have the following data in a DataFrame: Product Price Category 0 A 100 Electronic 1 B 200 Cloth 2 C 150 Electronic 3 D 300
-
Escape sequences in Pyhon
Escape sequences as in C While reading Automate the Boring Stuff with Python: Practical Programming for Total Beginners, I noticed the existence of raw strings. A raw string is created in such a way