Tom Mitchell (@imtommitchell) 's Twitter Profile
Tom Mitchell

@imtommitchell

Data Engineer @Revolutapp | Building applydone.io in my spare time to help you apply for jobs faster using AI. Sharing insights on data & startups

ID: 1635787028603236352

linkhttp://applydone.io calendar_today14-03-2023 23:36:42

8,8K Tweet

37,37K Followers

64 Following

Tom Mitchell (@imtommitchell) 's Twitter Profile Photo
Tom Mitchell
@imtommitchell

2 months ago

5 SQL functions I use to clean data: 1. COALESCE() - Handle missing values properly 2. UPPER() - Standardise text case 3. REPLACE() - Clean common text issues 4. CASE WHEN - Standardise categories 5. CAST() - Convert data types explicitly What do you use? Let me know below 👇🏻