How to Do Data Cleaning (step-by-step tutorial on real-life dataset)

🐼 All you need to know about Pandas in one place! Download my Pandas Cheat Sheet (free) - https://misraturp.gumroad.com/l/pandascs Data exploration video: https://youtu.be/OY4eQrekQvs If you’d like to follow along, find the data here: https://data.cityofnewyork.us/Environment/2015-Street-Tree-Census-Tree-Data/uvpi-gqnh 00:00 Welcome and some words on data cleaning 01:21 Cleaning irrelevant columns 01:43 Cleaning categorical column values 02:27 Cleaning missing values 13:08 Dealing with outliers 17:17 Data has a surprise for us 17:57 Dealing with unexpected data issues 21:10 Going forward 👋 Keep in touch? ========================== 🐥 Twitter - https://twitter.com/misraturp 🔗 LinkedIn - https://linkedin.com/in/misraturp/ 📹 YouTube - https://youtube.com/@misraturp 🌎 Website - https://misraturp.com/ Courses & resources ============================ 📙 Fundamentals of Deep Learning in 25 pages https://misraturp.gumroad.com/l/fdl 🤖 Deep Learning 101 with Python and Keras (FREE) https://youtube.com/playlist?list=PLM8lYG2MzHmQn55ii0duXdO9QSoDF5myF 🏃‍♀️ Data Science Kick-starter mini-course (FREE) https://misraturp.gumroad.com/l/kick-starter 🐼 Pandas cheat sheet (FREE) https://misraturp.gumroad.com/l/pandascs 📝 NNs hyperparameters cheat sheet (FREE) https://misraturp.gumroad.com/l/hcs