Data analysis in Python with pandas - 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: https://nbviewer.org/github/justmarkham/pandas-videos/blob/master/21_more_pandas_tricks.ipynb 🔥 MY TOP 25 PANDAS TRICKS: https://www.youtube.com/watch?v=RlIiVeig3hc&list=PL5-da3qGB5ICCsgW1MxlZ0Hq8LL5U3u9y&index=35 🐼 MORE PANDAS VIDEOS: https://www.youtube.com/playlist?list=PL5-da3qGB5ICCsgW1MxlZ0Hq8LL5U3u9y 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! - Newsletter: https://www.dataschool.io/subscribe/ - Twitter: https://twitter.com/justmarkham - Facebook: https://www.facebook.com/DataScienceSchool/ - LinkedIn: https://www.linkedin.com/in/justmarkham/