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/