Why did the same coding agent see the whole problem one day and miss the obvious the next? Note: I drafted and edited both this
Category: Data Engineering
Advanced SQL Templates In Python with JinjaSql
In A Simple Approach To Templated SQL Queries In Python, I introduced the basics of SQL templates in Python using JinjaSql. This post further demonstrates
Left Join with Pandas Data Frames in Python
Merging Pandas data frames is covered extensively in a StackOverflow article Pandas Merging 101. However, my experience of grading data science take-home tests leads me
Faster Data Science: From Big To Small Data
Business leaders often ask how to accelerate data science projects. It is well established that data scientists spend as much as 80% of their time
A Simple Approach To Templated SQL Queries In Python
There are numerous situations in which one would want to insert parameters in a SQL query, and there are many ways to implement templated SQL