Uploaded October 2026 | Updated November 2026, 3 hours ago
Data scientists spend ~80% of their time cleaning data, and the worst problems never announce themselves. In this video, youβll learn how to use AI for data cleaning the right way: find hidden issues, understand them, and get Python code you can review before anything touches your data.
π Youβll learn how to catch the 3 most common hidden data quality problems:
β Near-duplicate categories (NY vs New York vs N.Y.)
β Type mismatches (placeholder text like βTBDβ hiding in date columns)
β Unit errors and outlier clusters (a sensor logged in the wrong units)
Then we turn the whole workflow into a reusable AI skill and test it on a completely different dataset, with a one-line prompt.
GitHub link (documents used in the video): github.com/stratascratch/YT-videos/tree/main/AI%20Data%20Cleaning%2C%20Done%20Right%3A%20Diagnose%20First%2C%20Fix%20Second
StrataScratch Data Projects: platform.stratascratch.com/data-labs?utm_source=youtube&utm_medium=click&utm_campaign=YT+ai+data+cleaning
π Subscribe for more practical data science, SQL, Python, and AI workflows.
______________________________________________________________________
π Resources to Level Up Your Data Science Career
π Playlist for more real interview questions and tips: youtube.com/playlist?list=PLa5n6qxiATxE
π Playlist for data science projects: youtube.com/playlist?list=PLVC47XM2VQkc
π Playlist for myths, hot takes, and hard truths about working in data science: youtube.com/playlist?list=PLWrxsBNm4U-E
π Practice real data science interview questions: platform.stratascratch.com/coding?code_type=2&page_size=100&utm_source=youtube&utm_medium=click&utm_campaign=YT+ai+data+cleaning
π Hands-on data projects: platform.stratascratch.com/data-projects?page_size=100&utm_source=youtube&utm_medium=click&utm_campaign=YT+ai+data+cleaning
π Mock Interview: platform.stratascratch.com/mock-interview?utm_source=youtube&utm_medium=click&utm_campaign=YT+ai+data+cleaning
π Free Learning Paths: stratascratch.com/learn/comprehensive-sql?utm_source=youtube&utm_medium=click&utm_campaign=YT+ai+data+cleaning
______________________________________________________________________
π Video Timeline:
0:00 Why data cleaning eats 80% of your time
0:31 What dirty data really looks like (itβs never dramatic)
1:32 Why AutoClean, YData Profiling and SweetViz fall short
2:30 The middle ground: diagnose first, fix second
2:52 The prompt and the AIβs plan
3:22 The diagnostic code, explained
4:04 3 real findings: duplicates, type mismatch, unit error
5:52 Reviewing the fix code (nothing hidden)
7:43 Why the decision stays yours
8:04 Turning the workflow into a reusable skill
9:37 Uploading and enabling the skill
10:02 Testing it on a new dataset (expense records)
11:02 Final takeaway: diagnostic first, fix second, review always
11:33 Where to practice
______________________________________________________________________
About StrataScratch:
StrataScratch (platform.stratascratch.com/coding?code_type=2&page_size=100&utm_source=youtube&utm_medium=click&utm_campaign=YT+ai+data+cleaning) is a platform that allows you to practice real data science interview questions. There are over 1000+ interview questions that cover coding (SQL and Python), statistics, probability, product sense, and business cases.
So, if you want more interview practice with real data science interview questions, visit platform.stratascratch.com/coding?code_type=2&page_size=100&utm_source=youtube&utm_medium=click&utm_campaign=YT+ai+data+cleaning
All questions are free and you can even execute SQL and Python code in the IDE. Still, if you want to check out the solutions from other users or from the StrataScratch team, you can use ss15 for a 15% discount on the premium plans.
______________________________________________________________________
π§ Contact Us: Got questions or feedback? Drop them in the comments or email us at team@stratascratch.com.
_____________________________________________________________________
#DataCleaning #DataScience #AIforData #DataCleanUp #DataCleaning #DataScience #Python #DataAnalysis #MachineLearning #PythonLibraries #DataAnalytics
Data scientists spend ~80% of their time cleaning data, and the worst problems never announce themselves. In this video, youβll learn how to use AI for data cleaning the right way: find hidden issues, understand them, and get Python code you can review before anything touches your data.
π Youβll learn how to catch the 3 most common hidden data quality problems:
β Near-duplicate categories (NY vs New York vs N.Y.)
β Type mismatches (placeholder text like βTBDβ hiding in date columns)
β Unit errors and outlier clusters (a sensor logged in the wrong units)
Then we turn the whole workflow into a reusable AI skill and test it on a completely different dataset, with a one-line prompt.
GitHub link (documents used in the video): github.com/stratascratch/YT-videos/tree/main/AI%20Data%20Cleaning%2C%20Done%20Right%3A%20Diagnose%20First%2C%20Fix%20Second
StrataScratch Data Projects: platform.stratascratch.com/data-labs?utm_source=youtube&utm_medium=click&utm_campaign=YT+ai+data+cleaning
π Subscribe for more practical data science, SQL, Python, and AI workflows.
______________________________________________________________________
π Resources to Level Up Your Data Science Career
π Playlist for more real interview questions and tips: youtube.com/playlist?list=PLa5n6qxiATxE
π Playlist for data science projects: youtube.com/playlist?list=PLVC47XM2VQkc
π Playlist for myths, hot takes, and hard truths about working in data science: youtube.com/playlist?list=PLWrxsBNm4U-E
π Practice real data science interview questions: platform.stratascratch.com/coding?code_type=2&page_size=100&utm_source=youtube&utm_medium=click&utm_campaign=YT+ai+data+cleaning
π Hands-on data projects: platform.stratascratch.com/data-projects?page_size=100&utm_source=youtube&utm_medium=click&utm_campaign=YT+ai+data+cleaning
π Mock Interview: platform.stratascratch.com/mock-interview?utm_source=youtube&utm_medium=click&utm_campaign=YT+ai+data+cleaning
π Free Learning Paths: stratascratch.com/learn/comprehensive-sql?utm_source=youtube&utm_medium=click&utm_campaign=YT+ai+data+cleaning
______________________________________________________________________
π Video Timeline:
0:00 Why data cleaning eats 80% of your time
0:31 What dirty data really looks like (itβs never dramatic)
1:32 Why AutoClean, YData Profiling and SweetViz fall short
2:30 The middle ground: diagnose first, fix second
2:52 The prompt and the AIβs plan
3:22 The diagnostic code, explained
4:04 3 real findings: duplicates, type mismatch, unit error
5:52 Reviewing the fix code (nothing hidden)
7:43 Why the decision stays yours
8:04 Turning the workflow into a reusable skill
9:37 Uploading and enabling the skill
10:02 Testing it on a new dataset (expense records)
11:02 Final takeaway: diagnostic first, fix second, review always
11:33 Where to practice
______________________________________________________________________
About StrataScratch:
StrataScratch (platform.stratascratch.com/coding?code_type=2&page_size=100&utm_source=youtube&utm_medium=click&utm_campaign=YT+ai+data+cleaning) is a platform that allows you to practice real data science interview questions. There are over 1000+ interview questions that cover coding (SQL and Python), statistics, probability, product sense, and business cases.
So, if you want more interview practice with real data science interview questions, visit platform.stratascratch.com/coding?code_type=2&page_size=100&utm_source=youtube&utm_medium=click&utm_campaign=YT+ai+data+cleaning
All questions are free and you can even execute SQL and Python code in the IDE. Still, if you want to check out the solutions from other users or from the StrataScratch team, you can use ss15 for a 15% discount on the premium plans.
______________________________________________________________________
π§ Contact Us: Got questions or feedback? Drop them in the comments or email us at team@stratascratch.com.
_____________________________________________________________________
#DataCleaning #DataScience #AIforData #DataCleanUp #DataCleaning #DataScience #Python #DataAnalysis #MachineLearning #PythonLibraries #DataAnalytics



![How To Handle Multicollinearity and Feature Selection [DoorDash Data Science Project]
In this video, well give you a brief introduction to multicollinearity and feature selection, and show you how to solve the problem using a variety of methods. Well be using the DoorDash data science project to demonstrate how to apply these concepts in practice. In addition, well use the Random Forest regression method to determine which features are most important for predicting delivery times.
Watch our previous videos:
π Part 1: Data Preparation for Modeling: https://youtu.be/Sf6jn8QZHhc
π Part 2: Collinearity and Removing Redundancies: https://youtu.be/m3zEV10qvE8
π§βπ» Go to the project through the link below and follow along with me: https://platform.stratascratch.com/data-projects/delivery-duration-prediction?utm_source=youtube&utm_medium=click&utm_campaign=multicollinearity+%26+feature+selection
π Subscribe to my channel: https://bit.ly/2GsFxmA
π Playlist for more data science interview questions and answers: https://bit.ly/3jifw81
π Playlist for data science interview tips: https://bit.ly/2G5hNoJ
π Practice more real data science interview questions: https://platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link
Timeline:
Intro: (0:00βββ)
Quick recap: (0:25)
Removing multicollinearity: (0:48)
Feature selection (2:56)
Conclusion: (β8:17)
About The Platform:
Im using StrataScratch (https://platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link), a platform that allows you to practice real data science interview questions. There are over 1000+ interview questions that cover coding (SQL and python), statistics, probability, product sense, and business cases.
So, if you want more interview practice with real data science interview questions, visit https://platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link. All questions are free and you can even execute SQL and python code in the IDE, but if you want to check out the solutions from me or from other users, you can use ss15 for a 15% discount on the premium plans.
Contact:
If you have any questions, comments, or feedback, please leave them here!
Feel free to also email me at nathan@stratascratch.com
#StrataScratch #DoordashDataProject #DataModeling #Python How To Handle Multicollinearity and Feature Selection [DoorDash Data Science Project]](https://i.ytimg.com/vi/gh5JzALBQvU/mqdefault.jpg)





![Data Science SQL Interview Question Walkthrough [Microsoft] - Window Function: Ranking
This Data Science SQL interview question is from Microsoft, and tests your ability to write window functions to rank data. Iβll walk you through solving the question like weβre in an interview and give you some tips on how to approach the solution.
Go to the question through the link below and follow along with me.
Link to the question: https://platform.stratascratch.com/coding/2026-bottom-2-companies-by-mobile-usage?python=&utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link
π Subscribe to my channel: https://bit.ly/2GsFxmA
π Playlist for more data science interview questions and answers: https://bit.ly/3jifw81
π Playlist for data science interview tips: https://bit.ly/2G5hNoJ
π Practice more real data science interview questions: https://platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link
Timeline:
Intro: (0:00βββ)
Interview Question: (0:31ββ)
Framework to solve the problem: (1:25βββ)
Understand your data: (2:33βββ)
Formulate your approach: (5:05βββ)
Code Execution: (7:09βββ)
Code Optimization: (15:54βββ)
Conclusion: (18:10βββ)
About The Platform:
Im using StrataScratch (https://platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link), a platform that allows you to practice real data science interview questions. There are over 1000+ interview questions that cover coding (SQL and python), statistics, probability, product sense, and business cases.
So, if you want more interview practice with real data science interview questions, visit https://platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link. All questions are free and you can even execute SQL and python code in the IDE, but if you want to check out the solutions from me or from other users, you can use ss15 for a 15% discount on the premium plans.
Contact:
If you have any questions, comments, or feedback, please leave them here!
Feel free to also email me at nathan@stratascratch.com
#MicrosoftDataScienceInterview Data Science SQL Interview Question Walkthrough [Microsoft] - Window Function: Ranking](https://i.ytimg.com/vi/i-E4pdU2qXM/mqdefault.jpg)
