Skip to content

naivomah3/top-25-pandas-tricks

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Top 25 useful Pandas tricks:

These techniques will serve in the future as a reference

1. Show Pandas Version and Dependencies
2. Generate a sample DataFrame
3. Rename Cols
4. Reverse Row Order
5. Reverse Col Order
6. Select Col by dtype
7. Convert Strings to Numbers and populate towards the entire DataFrame
8. Reduce DataFrame Size
9. Merge DataFrame from multiple CSV files Row-wise
10. Merge DataFrame from multiple CSV files Column-wise
11. Create a DataFrame from a recent clipboard
12. Split DataFrame into 2 random subsets
13. Filter out the DataFrame by Multiple Categories
14. Flter out the DataFrame by the top-N Largest Categories
15. Use a threshold value to drop columns having Missing Values
16. Split a String value to Multiple Cols (for instance, First and Last Name, ...)
17. Expand a series of list values into a DataFrame 18. Aggregate by multiple functions
19. Select slice of Rows and Cols by refering the index with .loc() function
20. Reshape a Multi-Indexed Series using .groupby()
21. Aggregate DataFrame with .pivot_table()
22. Categorization - Convert Continuous data into Categorical data
23. Change display option to 2 decimal place
24. Style a DataFrame
25. Profile a DataFrame using pandas_profiling module

Inspired from Data School youtube channel

About

Top 25 useful Pandas tricks

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published