Top 10 Pandas Tips and Tricks

💥 Download the FREE Data Science Roadmap for 2023 ➡️ bit.ly/3ysZjG5
💥 Blog: mbel-education.com/

---------------------------------------------------------------------------------------------------

Code: github.com/martinbel/data-analysis-python

This video is part of the "Data Analysis with Python" video series.

In this video I explain the top 10 tips & tricks I use on my day to day work with pandas.

I cover these tips with realistic examples in order to demonstrate the idea more clearly.

I hope you enjoy this series! Please subscribe and like the video to support the channel

Timeline:
0:00 Intro
0:22 Clean all column names
3:42 Select columns by dtype
4:28 Group by multiple columns
5:08 nlargest and nsmallest
5:48 pd.melt: reshape wide data to long format
8:41 Avoid bugs
9:30 Avoid looping over a DataFrame
12:24 Use np.where to flag outliers
14:04 Use pd.cut to discretize variables
15:54 Use pd.qcut to discretize variables using quantil