Geek Logbook

By - Joaquín Chemile
Posted on 2024-07-16
Posted in Programming

Running SQL Queries from a Batch File: Retrieving the Server Name

When working with SQL servers, it’s often useful to automate routine tasks using batch files. One common task is retrieving the server name where your database is running. In this post, we’ll walk through how to execute a SQL query from a batch file to get the server name using Microsoft SQL Server’s sqlcmd utility.

By - Joaquín Chemile
Posted on 2024-07-052024-07-16
Posted in Programming

How to Print Lines Containing Non-Zero, Non-Dot, and Non-Space Characters in Python

In this blog post, we’ll explore a simple yet useful task: printing lines that contain at least one character that is not a zero (0), a dot (.), or a space. This can be particularly handy when processing log files, filtering data, or working on text processing tasks. Problem Statement Given a line of text,

By - Joaquín Chemile
Posted on 2024-07-05
Posted in Programming

Removing Rows from a Pandas DataFrame that Begin with Specific Characters

In this post, I’ll walk you through how to remove rows from a pandas DataFrame that begin with specific characters, such as “—“. This is a common task when cleaning and preprocessing data in Python. We’ll be using the pandas library, which is a powerful tool for data manipulation and analysis. Step-by-Step Guide Example Code

By - Joaquín Chemile
Posted on 2024-07-05
Posted in Programming

Transforming a Matrix by Adding Numbers Around a Specific Value in Python

When working with matrices, we often need to perform transformations that update the values based on certain conditions. In this post, we’ll walk through a function that takes a matrix and updates it by adding numbers around a specific value, in this case, the number 9. Problem Statement Given a matrix (tablero), we want to

By - Joaquín Chemile
Posted on 2024-07-05
Posted in Programming

How to Drop Rows Based on a Column Value in a pandas DataFrame

Problem Statement Let’s say you have a DataFrame containing weather data, and you want to drop all rows where the quantity (qty) is less than 5. However, you notice that some rows are being dropped incorrectly or the DataFrame remains unchanged after applying the filtering conditions. We’ll show you how to correctly drop the rows

By - Joaquín Chemile
Posted on 2024-07-032024-07-03
Posted in Programming

Inserting a Student into a Sorted List in Python

When working with sorted lists in Python, it’s essential to ensure that any new elements are added in the correct order. Problem Statement You have a list of student names sorted in alphabetical order, like this: You need to define a function add_student(sorted_list, new_student) that receives a list of names in the format above and

By - Joaquín Chemile
Posted on 2024-07-03
Posted in Programming

Ensuring Type Safety in Python Functions

When writing Python functions, ensuring that the parameters are of the correct type is crucial for robust and error-free code. In this post, we’ll explore how to enforce type checks in a function to ensure it raises an error if the parameter is not of the expected type. The Problem Consider a simple function that

By - Joaquín Chemile
Posted on 2024-07-02
Posted in Programming

Filtering and Counting Keys in Python Dictionaries

In this post, we’ll explore how to count the keys in a dictionary and filter a dictionary by its values in Python. These are common tasks that can be useful in a variety of situations when working with dictionaries. Counting the Keys of a Dictionary To count the number of keys in a dictionary, you

By - Joaquín Chemile
Posted on 2024-07-022024-07-02
Posted in Notes

Root Cause Analysis (RCA) for Data

Introduction In the realm of data management and analysis, problems can range from data quality issues to processing errors and performance bottlenecks. Identifying the root cause of these issues is crucial for ensuring data integrity and reliability. Root Cause Analysis (RCA) is a systematic approach to uncovering the underlying causes of data problems and implementing

By - Joaquín Chemile
Posted on 2024-07-01
Posted in Programming

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 date and calculate the total sum for each date. Solution Approach We’ll use Python’s dictionary data structure to achieve this. Dictionaries allow

Recent Posts

Categories

Archives

Running SQL Queries from a Batch File: Retrieving the Server Name

How to Print Lines Containing Non-Zero, Non-Dot, and Non-Space Characters in Python

Removing Rows from a Pandas DataFrame that Begin with Specific Characters

Transforming a Matrix by Adding Numbers Around a Specific Value in Python

How to Drop Rows Based on a Column Value in a pandas DataFrame

Inserting a Student into a Sorted List in Python

Ensuring Type Safety in Python Functions

Filtering and Counting Keys in Python Dictionaries

Root Cause Analysis (RCA) for Data

How to Aggregate Values by Date and Sum Them in Python