Uploaded May 2021 | Updated September 2026, 2 hours ago

---

🐼 All you need to know about Pandas in one place! Download my Pandas Cheat Sheet (free) - misraturp.gumroad.com/l/pandascs

In this video we learn how to explore a real-life dataset from NYC using Python and Pandas. We will dive deep into the data and find out potential problems, issues to fix and extract insights from it.

If you’d like to follow along, find the data here: data.cityofnewyork.us/Environment/2015-Street-Tree-Census-Tree-Data/uvpi-gqnh

NYC Open Data - opendata.cityofnewyork.us

00:00 Welcome
00:34 Some notes on data exploration
01:15 Dataset explanations
05:26 First look into our dataset
06:58 Understanding columns
09:22 Filtering out the unnecessary columns
11:45 Missing value check
12:49 Numerical values check
15:08 Outliers check
19:57 Categorical values check
24:57 Explore distribution of binary columns
26:40 Summary

👋 Keep in touch?
==========================
🐥 Twitter - twitter.com/misraturp
🔗 LinkedIn - linkedin.com/in/misraturp
📹 YouTube - youtube.com/@misraturp
🌎 Website - misraturp.com

Courses & resources
============================
📙 Fundamentals of Deep Learning in 25 pages
misraturp.gumroad.com/l/fdl

🤖 Deep Learning 101 with Python and Keras (FREE)
youtube.com/playlist?list=PLM8lYG2MzHmQn55ii0duXdO9QSoDF5myF

🏃‍♀️ Data Science Kick-starter mini-course (FREE)
misraturp.gumroad.com/l/kick-starter

🐼 Pandas cheat sheet (FREE)
misraturp.gumroad.com/l/pandascs

📝 NNs hyperparameters cheat sheet (FREE)
misraturp.gumroad.com/l/hcs