21 more pandas tricks

You're about to learn 21 tricks that will help you to work faster, write better pandas code, and impress your friends. These are the BEST tricks that I couldn't fit into my FIRST tricks video!

📔 JUPYTER NOTEBOOK:

🔥 MY TOP 25 PANDAS TRICKS:

🐼 MORE PANDAS VIDEOS:

TRICKS:
0:00 Introduction
0:36 1. Check for equality
1:27 2. Check for equality (alternative)
2:38 3. Use NumPy without importing NumPy
3:42 4. Calculate memory usage
4:10 5. Count the number of words in a column
4:45 6. Convert one set of values to another
6:59 7. Convert continuous data into categorical data (alternative)
8:05 8. Create a cross-tabulation
8:55 9. Create a datetime column from multiple columns
9:34 10. Resample a datetime column
11:07 11. Read and write from compressed files
12:10 12. Fill missing values using interpolation
12:45 13. Check for duplicate merge keys
13:50 14. Transpose a wide DataFrame
14:47 15. Create an example DataFrame (alternative)
16:06 16. Identify rows that are missing from a DataFrame
17:09 17. Use query to avoid intermediate variables
19:06 18. Reshape a DataFrame from wide format to long format
21:19 19. Reverse row order (alternative)
22:25 20. Reverse column order (alternative)
23:21 21. Split a string into multiple columns (alternative)

NOTE: Tricks 3 and 15 were deprecated in pandas 1.0

LET'S CONNECT!

[dataschool]

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

[Kristina_Tsoy]

Thank you so much! Your tutorials are the best

[rezaghari]

That was really Helpful, man! Glad that I saw your tweet in my timeline!

[horoshuhin]

love it. I really enjoyed this video. thanks for the quality content

[gabrielreilly]

I love these videos. I always learn so much.

[shubhi]

Thank you for you amazing videos! Super informative and helpful, as always.

[pivotai]

I was becoming sad that you were no longer making pandas videos. What a come back like that of Real Madrid :)). Thanks Kevin!!

[hyakushiki]

Even after re-watching them, your videos are outstanding.

[carloseduardocorreacoimbra]

Thanks a lot for the excellent tricks (25 + 21) ! Really amazing and useful.

[pabloxD]

Great tips, holy! there is always something new to learn.

[frankgiardina]

Lots of time savers here thanks well done

[yd_]

Cool. pandas and numpy seem to have a ton of functions and it’s hard to remember them all. Would appreciate a video focused on multilevel data frames, as I always forget how to index, etc those.

[amitnikhate]

Hi Kevin, Thank you for creating such amazing contents. These videos are really helpful for doing real time projects. I wanted to request you to make video on particular topic. if you can make video on how to use pandas to write, read and edit google sheets, that would be very helpful. It can include putting values in range of cells as well as one cell in google sheet, reading data, etc. If there is already any video you have made on this topic, let me know.

[pietraderdetective]

Great tips and tricks as always!
do you have a tutorial video about writing efficient pandas code? for example implementing vectorization?
I've watched plenty of your videos but I think I haven't seen one about the topic

[nothingDone-eifj]

I completed 36 videos in this series. Thanks a lot Kevin for such amazing tutorial.

[yerriswamym]

Hi Kevin, Thanks for the insightful video. I love your videos and courses they are so subtle and impactful. Would it be possible for you to make a video on Python Class/objects? Its a daunting concept for someone like me (not from coding background) who has limited understanding of OOPs. Additionally I have observed that many coders use python classes for ML scripts/pipeline, scripting files on Github. So it would be helpful if you could make an video on the same.
Thanks in advance !!

[dariuszspiewak]

Hi Kevin. The most important question of all: How to remember all of those things? Do you have any means? Any way that lets you retain the tricks/knowledge in your mind for longer? Would you please share any thoughts on that? Thanks.

[TimePasser]

I miss your videos, man. Best like to best tutor. 👌

[faizanwar_]

Sir, please make a video on user defined functions in pandas dataframe

[bobiq]

Just doing your datacamp RI Police course. It's a really well laid out course and I think you're adorable. :-)