Master Data Exploration with Pandas: Step-by-Step Guide & Free Cheat Sheet ๐
Learn how to perform effective data exploration using Pandas with this comprehensive step-by-step tutorial on a real-life dataset. Download your free Pandas Cheat Sheet now!

Mฤฑsra Turp
145.0K views โข May 24, 2021

About this video
๐ผ All you need to know about Pandas in one place! Download my Pandas Cheat Sheet (free) - https://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: https://data.cityofnewyork.us/Environment/2015-Street-Tree-Census-Tree-Data/uvpi-gqnh
NYC Open Data - https://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 - 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
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: https://data.cityofnewyork.us/Environment/2015-Street-Tree-Census-Tree-Data/uvpi-gqnh
NYC Open Data - https://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 - 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
Video Information
Views
145.0K
Likes
4.2K
Duration
29:19
Published
May 24, 2021
User Reviews
4.7
(28)