Create an account to use AI

Create a free account to unlock all features:

Ask questions about videos with AI
Use smart search (AI)
Save your favorite videos
Bookmark your favorite categories
Organize your favorite subcategories
Access your personalized favorites page
Access your conversation history
Personalize your homepage with your favorites

Already have an account? Log in

Data Cleaning in Pandas | Python Pandas Tutorials

Name: Data Cleaning in Pandas | Python Pandas Tutorials
Uploaded: 2023-05-23T12:30:17+00:00
Duration: 38 min 37 s

Alex The Analyst

Take my Full Python Course Here: https://www.analystbuilder.com/courses/pandas-for-data-analysis

In this series we will be walking through everything you need to know to get started in Pandas! In this video, we learn about Data Cleaning in Pandas.

Datasets in GitHub:

https://github.com/AlexTheAnalyst/PandasYouTubeSeries/blob/main/Customer%20Call%20List.xlsx

Code in GitHub: https://github.com/AlexTheAnalyst/PandasYouTubeSeries/blob/main/Pandas%20101%20-%20Data%20Cleaning%20in%20Pandas.ipynb

Favorite Pandas Course:

Data Analysis with Pandas and Python - https://bit.ly/3KHMLlu

____________________________________________

SUBSCRIBE!

Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!

____________________________________________

RESOURCES:

Coursera Courses:

📖Google Data Analyst Certification: https://coursera.pxf.io/5bBd62

📖Data Analysis with Python - https://coursera.pxf.io/BXY3Wy

📖IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR

📖Tableau Data Visualization - https://coursera.pxf.io/MXYqaN

Udemy Courses:

📖Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX

📖Statistics for Data Science - https://bit.ly/37jqDbq

📖SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij

📖Tableau A-Z - http://bit.ly/385lYvN

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*

____________________________________________

BECOME A MEMBER -

Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!

https://www.youtube.com/channel/UC7cs8q-gJRlGwj4A8OmCmXg/join

____________________________________________

Websites:

💻Website: AlexTheAnalyst.com

💾GitHub: https://github.com/AlexTheAnalyst

📱Instagram: @Alex_The_Analyst

____________________________________________

0:00 Intro

0:41 First Look at Data

2:34 Removing Duplicates

3:41 Dropping Columns

5:10 Strip

12:15 Cleaning/Standardizing Phone Numbers

21:29 Splitting Columns

24:58 Standardizing Column Values using Replace

28:40 Fill Null Values

29:42 Filtering Down Rows of Data

36:42 Outro

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*