Top 10 Pandas Tips and Tricks

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

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
8:41 Avoid bugs
9:30 Avoid looping over a DataFrame

[gustavojuantorena]

Good video Martín. I didn't know about the "as_index" argument in groupby 👌

[iReaperYo]

Interesting, you use the methid chaining syntax at the end for the mat variable. Where did you learn this practice? it is rare and I can discern a proficient coder by the use of this. are you US based?

[iReaperYo]

I was advised to learn the melt function also, is there any rules we should follow to know when to use it?

[iReaperYo]

how does grouping by multiple groups work?