@jessramosdata: Let’s get DIRTY!! 😉 It’s gonna be 80% of your job! Follow for part 2 and check bio 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

Jess Ramos - Big Data Energy⚡️
Jess Ramos - Big Data Energy⚡️
Open In TikTok:
Region: PH
Monday 09 February 2026 15:33:38 GMT
95979
8574
37
371

Music

Download

Comments

xyzzxy767
xyz :
Quick tip: if your data is a flat file, clean with power query in excel or power bi and import the cleaned data into your database , it’s faster and easier
2026-02-15 01:00:00
112
farhansanji
Farhan Sanji :
What app do you use for sql
2026-02-13 10:53:14
5
rem69236
rem :
you clean in excel??
2026-02-10 02:26:53
7
proposaic
proposaic :
String cleaning being 80% of the work is something most DA courses skip entirely. Real world data is messy in ways practice datasets never prepare you for
2026-02-22 03:03:29
19
metaltao
Tao :
NO COMMENTS but the ad is AI SLOP btw
2026-03-30 02:01:18
0
aidy_uk
Aidy :
The performance of that will be excruciatingly bad on large datasets. Maybe that's why it takes up 80% of your time 🤷🏻‍♂️
2026-04-02 23:53:10
1
incognito_raemn
Raemn :
Finally someone talking about the dirty work
2026-03-28 16:35:06
1
aya.in.tech
aya in tech :
it’s satisfying tho 😅 I enjoy data cleaning & validation even though it can take some time
2026-04-02 15:51:39
0
excel.kuya.ph
Excel Kuya PH :
Great content. I want to be as enthusistic as you when making videos. Hopefully l will be as good.
2026-04-23 06:35:04
0
christenanthea
christenanthea :
this is perfect because I was just going over data cleaning today 😫
2026-02-09 21:41:16
2
jjsarte1975
JJS | DAA :
hi jess where to get the sample dataset? thanks. though i prefer to use power query and pandas.
2026-03-17 22:08:16
0
denniskayo
its kayotti :
hello madam, what prompt did you give to chat GPT
2026-04-28 15:17:23
0
j2dajones52
Jeffrey Jones :
very informative! may i ask for how you imported your synthesized data into your sql rdbms? i wanted to practice on a Kaggle data set, but got stuck trying to import csv into pgadmin4.
2026-02-10 03:32:56
2
mahmoudarafa340
mahmoud arafa :
Great effort
2026-05-06 20:48:57
0
marypop88
Marysha Soraya Abdul :
Your content is very easy to understand.. 🥰
2026-02-17 12:52:34
1
brandon_much
Brandon :
Thanks Jess!✨
2026-04-09 15:37:30
0
michael.data.scie
Michael | Data :
I love your YouTube content very much 👍 well done ma
2026-04-04 21:59:32
1
renattand
renatta :
amazing content
2026-02-09 15:57:27
0
canada462ui6
user2184942058018 :
Yaaaaaas! 💪🔥
2026-02-09 22:59:39
0
mc_honor
Connor :
I like the platform you’re working in ❄️
2026-02-15 12:40:34
0
moime471
moime :
This is what data analysis is !! Omg I wanna do this
2026-06-28 21:46:41
0
mimi.lvly
merry :
is it possible to use power bi for this?
2026-03-15 00:12:40
0
user4392449970536
user4392449970536 :
Thank you
2026-02-22 01:06:12
0
sassyefe
Sassy_Efe :
Yesssss ! More of this
2026-02-19 04:07:38
0
thestoryof_sarah
thestoryofsarah :
great video!
2026-02-09 21:26:15
0
To see more videos from user @jessramosdata, please go to the Tikwm homepage.

Other Videos


About