My top 25 pandas tricks

You're about to learn 25 tricks that will help you to work faster, write better pandas code, and impress your friends. These are the BEST tricks I've learned from 5 years of teaching Python's pandas library.

Don't miss the BONUS at the end of this video!

TRICKS:
0:00 Introduction
0:43 1. Show installed versions
1:20 2. Create an example DataFrame
2:22 3. Rename columns
3:47 4. Reverse row order
4:36 5. Reverse column order
5:01 6. Select columns by data type
5:40 7. Convert strings to numbers
6:55 8. Reduce DataFrame size
8:15 9. Build a DataFrame from multiple files (row-wise)
10:00 10. Build a DataFrame from multiple files (column-wise)
10:45 11. Create a DataFrame from the clipboard
11:50 12. Split a DataFrame into two random subsets
12:57 13. Filter a DataFrame by multiple categories
13:52 14. Filter a DataFrame by largest categories
14:42 15. Handle missing values
15:57 16. Split a string into multiple columns
16:59 17. Expand a Series of lists into a DataFrame
17:39 18. Aggregate by multiple functions
18:41 19. Combine the output of an aggregation with a DataFrame
19:56 20. Select a slice of rows and columns
20:52 21. Reshape a MultiIndexed Series
22:04 22. Create a pivot table
23:01 23. Convert continuous data into categorical data
23:56 24. Change display options
24:47 25. Style a DataFrame
26:14 Bonus. Profile a DataFrame

DOWNLOAD the Jupyter notebook:

WATCH my introductory series, Data Analysis with pandas:

JOIN the "Data School Insiders" community:

LET'S CONNECT!

[dataschool]

THANKS for watching! 🙌 Which trick are you most excited to start using? CLICK REPLY and let me know!

[zackhicks]

Video should be called 'Magic with Pandas'. Thanks for this really useful resource!

[sattysattu]

The long awited video is out now. Thank you so much mate. Great learning with you.

[BasselHaidar]

Kevin,
love your content and it is amplified by your speech cadence, enunciation, and tone.
My favorite tricks are 10 and 11 (Building a dataframe from multiple files rows/columns).
Thank you for sharing your knowledge, mad respect!

[danielperico]

One of my favorite videos on YouTube, thank you so much!

[christopherteoh]

The bonus content totally blew my mind off! Thank you very much Kevin! You're simply the best! Looking forward to purchase your ML series!

[mustafabohra]

Man, you are just so awesome! Giving all these valuable tricks for free on your channel.

God bless you!!!

[pldeepesh]

Fantastic! Been using pandas since a year now, You have opened new possibilities for me to keep looking and learning.!! Please keep doing the great work!

[hectoralvarorojas]

Well done Kevin!


Thanks for sharing this great material.


My best regards!

[robertodilisio]

Brilliant as usual! From beginning to end! The bonus was also mind blowing :)

[thomasmendy]

Kevin Markham, you by far one of the best Data Science Instructor, I came across. Thank you for providing us with such high standard content at no cost.

[MadLadsAnonymous]

Wow, that last tip! What a phenomenal overview and diagnostic tool. I've learned so much from your videos. So grateful for your content.

[Alok_Mandal]

you just saved my life, i was collecting these things over google wasted my good time but now i know where to look for.
keep sharing, God bless you.
Thanks

[irfankhuddus]

Superb ! Excellent ! introduction for Beginner (myself) to get introduced and master these Pandas at the same time thereby saving me a lot of time. Thank you so much Kevin !!! You Rock !!!

[DiegoTerzano]

Fantastic tips, thank you!! Super valuable and with clear, practical examples. Once again, thank you!

[naqeeb]

It is one of the best videos on Pandas. I really love some of the tricks e.g., the Clipboard', and 'The Excel copy & paste ones.

[brendafosmire]

Best Pandas trips ever. I’m going to make myself some flash cards for each of these. Thank you.

[siddhartha]

Thank you, for giving me shout out, and thank you for including my trick in your video (pd.profiling) :)

[valeriemolignano]

Kevin, you are a fantastic instructor. I'll sign up for anything you offer. My 2 favorites: clipboards, and, what made my mouth drop - the dataframe profiling.

[OmarAbdelaziz__]

Thank you Kevin, You are really a good instructor. Also, I really loved how you shout out people your learnt tricks from, that's very awesome!