Geek Logbook

Tech sea log book

Recent Posts

Categories

#50projectsIn50days Airflow Amazon Web Services Apache Iceberg AWS Azure bash Batch CAP Coders At Work Data data lakes Data Warehouse Docker Edsger W. Dijkstra Excel Git Hadoop HDFS Hellerstein Hive Javascript Networking NoSql Postman Power Bi Powershell Pyspark Python Redash S3 Social Skills Software Developer Spark Spark: The Definitive Guide SQL SSH terraform Testing The Elements of Programming Style Traversy Media Understanding Distributed Systems Virtual Box whale-alert Yaml

Archives

Extracting the Last Segment of a String in SQL Server

When working with data, you often need to manipulate strings to extract meaningful information. A common scenario is having strings with segments separated by underscores (_), and you only need the last segment. For example, you might have strings like: In this blog post, we’ll explore how to extract the last segment of these strings
Read More

Creating a Pandas DataFrame from a List of Lists

Working with data in Python often involves using pandas, one of the most powerful libraries for data manipulation. A common task is converting a list of lists into a pandas DataFrame. This post will guide you through the process and help you avoid common pitfalls, such as the dreaded “ValueError: shape passed value is” error.
Read More

Understanding the DECIMAL Data Type in SQL: What Happens When You Don’t Specify Parameters?

When working with SQL, one of the fundamental aspects of database design and manipulation is understanding the various data types available. Among them, the DECIMAL type is often used for representing numbers that require a high level of accuracy, such as financial data. But what happens when you don’t specify parameters for a DECIMAL column
Read More

Resolving PostgreSQL Authentication Errors in Docker Compose for Redash

Introduction When setting up Redash with Docker Compose, one of the common errors users might encounter is related to PostgreSQL authentication. Specifically, the psycopg2.OperationalError: fe_sendauth: no password supplied error can be frustrating, especially when you believe everything is configured correctly. This post will guide you through understanding and resolving this error. Understanding the Error The
Read More

Understanding Window Functions in SQL with Running Totals

Introduction Window functions in SQL are incredibly powerful, allowing you to perform calculations across a set of table rows related to the current row. They enable tasks like calculating running totals, generating rankings, and more, all while maintaining individual row-level detail. In this post, we’ll dive into window functions, focusing on how to calculate a
Read More

Debugging SQL Joins: Troubleshooting OR Joins with Multiple Columns in PostgreSQL

Introduction SQL joins are essential for combining data from different tables in a relational database. However, they can sometimes be tricky, especially when dealing with complex joins that involve multiple columns or need to account for variations in data structure. In this post, we’ll walk through a real-world scenario where a SQL join on multiple
Read More

Understanding the Quality of a Multiple Linear Regression Model: Analyzing SalaryUSD Predictions

In this blog post, we’ll dive into the process of analyzing the quality of a multiple linear regression model, specifically focusing on predicting SalaryUSD based on factors like EducationLevel and YearsExperience. We’ll also explore the significance of each predictor variable and how well the model fits the data. Introduction to Multiple Linear Regression Multiple linear
Read More

How to Handle shutil.SameFileError When Copying Files in Python

Introduction Have you ever encountered the shutil.SameFileError while trying to copy files in Python? This error occurs when you attempt to copy a file onto itself, resulting in a failed operation. In this post, we’ll explore what causes this error and how you can effectively handle it in your Python scripts. Understanding shutil.SameFileError The shutil.SameFileError
Read More