Search


The Solve to a Data Engineer's Pain: My Tools for Flawless Data Validation
As a data engineer, I've spent countless hours making sure data flows smoothly from one system to another. This often involves the...
mayasandler
Sep 154 min read


Merge by proximity, not by equality
I am doing a lot of JOINs in SQL and Python and usually I need to match the exact numbers/timestamps/booleans etc. In a project I worked...
mayasandler
Jun 15, 20224 min read


Big Data - Time is of the Essence
I am not the best Python program engineer and usually I learn as I go according to what I need to do. Therefore, sometimes I have a...
mayasandler
May 10, 20213 min read


date_trunc() in MySQL
MySQL lacks data_trunc() function, which is important to look at quarters/months/etc. Create this function & use it for conversions data.
mayasandler
Feb 19, 20211 min read