Pandas Drop Duplicates // Drop duplicate rows in Python pandas with examples for subset and keep

preview_player
Показать описание
Learn how to drop duplicate rows in Python pandas dataframes with this quick tutorial. This video from my "Pandas Tips" series walks you through finding duplicate rows (with pandas duplicated method) and dropping duplicate rows with pandas drop_duplicates method. You'll also be able to level up your Python pandas skills by dropping duplicates based on one or multiple columns using the drop duplicates subset option. Then tell pandas which duplicate you'd like to keep using the keep argument within the Python pandas drop duplicates method. You can even drop all duplicates from your pandas dataframe by setting keep equal to False. Finally, make your changes permanent by switching on the pandas drop duplicates inplace argument. Check this video out to level up your Python pandas skills and make the most out of the pandas drop duplicates function -- happy data cleaning!

0:00 Set up and data
1:08 Find duplicate rows
2:21 Drop duplicate rows
3:39 Drop duplicates by a column (SUBSET)
5:31 Drop duplicates by multiple columns
7:16 Select which duplicate to KEEP
8:33 Drop ALL duplicates (keep=False)
9:29 Save changes: inplace
10:24 Conclusion & BLOOPS

💻 Github CODE and DATA 💻

🎥 Related VIDEOS 🎥

📖 BOOKS about pandas from my Amazon Storefront 📖

☕ Buy me a COFFEE ☕
If you have enjoyed the content presented in this video and are able, consider buying a virtual cup of coffee to keep my channel going!

#python #pandas #pythonprogramming
Рекомендации по теме
Комментарии
Автор

Hi Kimberly. Thank you so much for your accessible videos. I am developer of 30 years and have just started learning about AI, ML, python etc. It's great to be able to see things from different peoples perspective. Having discovered you through your new pandas videos, I've also been enjoying some of your older content. 😍

tonystiles
Автор

Thank you very much for explaning so softly and very helpful video. Looking forward to Join your tutorial to learn more on Pandas.. Please do let me know how to register.

syedaneesdurez
Автор

I have been watching your videos for years.
Always very easy to digest.
Many thanks.

Depaxa
Автор

great stuff. I like the way you break these concepts down into manageable chunks using relatable data.

cerealport
Автор

Hi mam! I find all your videos useful.

easyprogramminglessons
Автор

I'm also a programmer . I have subscribed your channel

easyprogramminglessons