21 more pandas tricks

Опубликовано: 12 Май 2022
на канале: Data School

49,103

1.4k

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/justmarkh...

🔥 MY TOP 25 PANDAS TRICKS:
   • My top 25 pandas tricks

🐼 MORE PANDAS VIDEOS:
   • Data analysis in Python with pandas

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:   / justmarkham
Facebook:   / datascienceschool
LinkedIn:   / justmarkham