David KEvent-Driven Data Preprocessing On AWS With Lambda, S3 Triggers, And CloudWatch.Statement Of Purpose:Dec 1, 2023Dec 1, 2023
David KTwo SQL Window Functions That Will Set You Apart.Hey! SQL has several window functions, which suit a lot of use-case scenarios. However, today we’d just focus on two that will set you…Aug 12, 2023Aug 12, 2023
David KAutomating An ETL Pipeline With Apache-AirflowPrerequisites: Docker and PostgreSQLJun 6, 2023Jun 6, 2023
David KThe Bias-Variance Tradeoff; Striking The Perfect Balance.The Bias-Variance tradeoff is a fundamental concept in statistics and machine learning which relates to the problem of overfitting and…May 15, 2023May 15, 2023
David KPreprocessing Multiple Data Columns Simultaneously With Sklearn’s Column Transformation Pipeline.Today we’d take a look at how to simultaneously preprocess multiple columns in a dataset, to achieve their desired form with sklearn’s…Apr 30, 2023Apr 30, 2023
David KBuilding An ETL Pipeline With Python and PostgreSQL.In this article, we’d build an ETL pipeline that pulls data from an API, transforms it, and saves it to a PostgreSQL database.Apr 27, 20231Apr 27, 20231