Data Cleaning 101 in SQL - #1 Tidying Messy Data

I am glad to have you for the first part of my complete guide on data cleaning. #1: Tidying Messy Data <– You are here #2: Dealing with Missing Data #3.1: A discussion on the Nature of Outliers #3.2: The Origin of Outliers & Detection Techniques #4.1: Where does Data Duplication come from? #4.2: A Practical Tutorial for Data Deduplication Photo by Vadim Sherbakov on Unsplash Data cleaning has always been a nightmare that every single analyst has to walk through (like through fire and flames)....

July 16, 2023 · 15 min · Brian Tran