Data Cleaning in Pandas | Python Pandas Tutorials

Alex The Analyst May 23, 2023
Video Thumbnail

About

No channel description available.

Video Description

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*

Data Cleaning Tools You Can't Miss

AI-recommended products based on this video

Loading...
Spiral Notebook, A5 Size 5 Subject Notebooks College Ruled with Tabs and Removable Dividers, 300 Pages 100GSM Thick Spiral Ruled Lined Writing Journal Notebook for Work, School(6.2"x 8.5")

Spiral Notebook, A5 Size 5 Subject Notebooks College Ruled with Tabs and Removable Dividers, 300 Pages 100GSM Thick Spiral Ruled Lined Writing Journal Notebook for Work, School(6.2"x 8.5")

(14)
$17.99
Prime
50+ bought in past month
Loading...
The Bible In A Year: A 52-Week Study Through God's Word, Spiral Bound Bible Study Guide Journal Notebook, A Beautiful Year Planner in the Bible for Women (A5)

The Bible In A Year: A 52-Week Study Through God's Word, Spiral Bound Bible Study Guide Journal Notebook, A Beautiful Year Planner in the Bible for Women (A5)

(1)
$23.99
FREE delivery Fri, Oct 10 on your first order
Loading...
10.1 Inch Touch Portable Monitor IPS Screen 1366x768P 60Hz 400 Brightness 99% sRGB HDMI USB-C Monitors Switch for Xbox PS3/4/5 Laptop Compatible with Raspberry Pi, Mini Touch Screen

10.1 Inch Touch Portable Monitor IPS Screen 1366x768P 60Hz 400 Brightness 99% sRGB HDMI USB-C Monitors Switch for Xbox PS3/4/5 Laptop Compatible with Raspberry Pi, Mini Touch Screen

(1)
$99.99
FREE delivery Mon, Aug 11
Loading...
ELECROW 8 Inch Portable Monitor, 1280x800 Mini HD Display with Built-in Speakers, USB Powered, Non-Touch LCD Screen for Raspberry Pi, PC, Laptop, Jetson Nano, Game Consoles

ELECROW 8 Inch Portable Monitor, 1280x800 Mini HD Display with Built-in Speakers, USB Powered, Non-Touch LCD Screen for Raspberry Pi, PC, Laptop, Jetson Nano, Game Consoles

(49)
$117.29$102.21
$6.86 delivery Thu, Aug 14
Loading...
7 Inch Portable Monitor Touchscreen HD 1024x600 LED Display Dual HDMI Port Small Monitor for PC Raspberry Pi Laptop Computer Xbox PS4/5 Switch Built-in Speakers

7 Inch Portable Monitor Touchscreen HD 1024x600 LED Display Dual HDMI Port Small Monitor for PC Raspberry Pi Laptop Computer Xbox PS4/5 Switch Built-in Speakers

(61)
$68.99
FREE delivery Tue, Aug 12
Loading...
BrosTrend 1800Mbps WiFi 6 Linux WiFi Adapter for PC and Raspberry Pi 2+, Long Range USB WiFi Dongle Linux for Ubuntu, Mint, Debian, Kubuntu, Lubuntu, Zorin, Windows 11/10, Dual Band Wireless Antenna

BrosTrend 1800Mbps WiFi 6 Linux WiFi Adapter for PC and Raspberry Pi 2+, Long Range USB WiFi Dongle Linux for Ubuntu, Mint, Debian, Kubuntu, Lubuntu, Zorin, Windows 11/10, Dual Band Wireless Antenna

(288)
$54.14
FREE delivery Sun, Jun 22
Loading...
Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black
Best Seller

Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black

(17,871)
$27.98$22.38
FREE delivery Tue, Oct 14 on your first order
500+ bought in past month
Loading...
Logitech G305 Lightspeed Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black

Logitech G305 Lightspeed Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black

(35,879)
$49.99$44.99
FREE delivery Mon, Jan 26
1K+ bought in past month
Loading...
Dell S2722DC Monitor - 27-inch WQHD (2560x1440) 75Hz 4Ms Display, AMD FreeSync, Built in Speaker, USB Type-C/USB 3.2 Gen 1/HDMI Connectivity, Height/Pivot/Swivel/Tilt Adjustability - Platinum Silver
Amazon's Choice

Dell S2722DC Monitor - 27-inch WQHD (2560x1440) 75Hz 4Ms Display, AMD FreeSync, Built in Speaker, USB Type-C/USB 3.2 Gen 1/HDMI Connectivity, Height/Pivot/Swivel/Tilt Adjustability - Platinum Silver

(4,001)
$299.99
FREE delivery Sun, Aug 24
200+ bought in past month
Loading...
GOOFCXO 4 Step Folding Ladder Chair, 3-in-1 Wood Ladder Stool, Multi-Functional Portable Step Stool Display Stand for Home Kitchen Office Library, 265lbs Load Capacity, 34.3" H x 13.4" L x 15.2" W

GOOFCXO 4 Step Folding Ladder Chair, 3-in-1 Wood Ladder Stool, Multi-Functional Portable Step Stool Display Stand for Home Kitchen Office Library, 265lbs Load Capacity, 34.3" H x 13.4" L x 15.2" W

(0)
$118.26
FREE delivery Sat, Jun 28
Loading...
ybaymy 4 Tier Folding Ladder Chair, 3-in-1 Wood Step Ladder 265 lbs Capacity Display Ladder, Multi-Functional Step Stool, Folding Step Ladder for Home Office Kitchen13.78''(L) x18.11''(W) x35.43''(H)

ybaymy 4 Tier Folding Ladder Chair, 3-in-1 Wood Step Ladder 265 lbs Capacity Display Ladder, Multi-Functional Step Stool, Folding Step Ladder for Home Office Kitchen13.78''(L) x18.11''(W) x35.43''(H)

(7)
$103.99
FREE delivery Sat, Jun 28
Loading...
OCKYOOZ 4 Tier Folding Ladder Chair, 3-in-1 Solid Wood Step Ladder, Foldable Ladder Stool Shelf, Protable 4-Step Library Ladder, Multi-Functional Display Stand for Home Office (Size:14"L*18"D*35.4"H)

OCKYOOZ 4 Tier Folding Ladder Chair, 3-in-1 Solid Wood Step Ladder, Foldable Ladder Stool Shelf, Protable 4-Step Library Ladder, Multi-Functional Display Stand for Home Office (Size:14"L*18"D*35.4"H)

(3)
$119.99
FREE delivery Sat, Jun 28
Loading...
Freenove Ultimate Starter Kit for BBC micro bit (V2 Included), 316-Page Detailed Tutorial, 225 Items, 44 Projects, Blocks and Python Code

Freenove Ultimate Starter Kit for BBC micro bit (V2 Included), 316-Page Detailed Tutorial, 225 Items, 44 Projects, Blocks and Python Code

(382)
$94.95
PrimeFREE delivery Sat, Jun 14