# @jessramosdata on Instagram

- **Type:** Video
- **Original URL:** https://www.instagram.com/p/DV_TsIYEvDc
- **Gondola URL:** https://gondola.cc/posts/63368276-jessramosdata-instagram
- **Thumbnail:** https://img.gondola.cc/tr:w-,h-,fo-auto/postThumbnails/7d63c94c83.jpg
- **Posted:** 2026-03-17T14:39:52.000+00:00
- **Account Owner:** Jess Ramos | Tech, AI, & Data⚡️ (@jessramosdata) — https://gondola.cc/jessramosdata

## Caption

Let’s get DIRTY!! 😉 It’s gonna be 80% of your job!

Follow for part 2 and comment “clean” for my full demo data cleaning in SQL youtube video!

↳ Clean strings: remove extra spaces, weird quotes, and fix casing
↳ Fix dates: standardize formats and remove stray characters
↳ Recode variables: turn “CA”, “California”, and “calif” into one consistent value 
↳ Handle NULLs: don’t let missing data mess with your analysis

Save these 4 tips to handle messy datasets w/ ease 😮‍💨

#data #datacleaning #sql 
🏷️ data, data cleaning, sql, data analytics, data science

## Stats

- **Views:** 31,306
- **Likes:** 3,900
- **Shares:** 0
- **Comments:** 460

## Tags

datacleaning, data, sql

---
Copyright (c) Gondola