Effective Pandas

Best practices for manipulating data with Pandas. This book will arm you with years of knowledge and experience that are condensed into an easy to follow format. Rather than taking months reading blogs and websites and searching mailing lists and groups, this book will teach you how to write good Pandas code.

It covers:

• Series manipulation
• Creating columns
• Summary statistics
• Grouping, pivoting, and cross-tabulation
• Time series data
• Visualization
• Chaining
• Debugging code
• and more…

Contents

1. Installation
2. Data Structures
3. Series Introduction
4. Series Deep Dive
5. Operators (& Dunder Methods)
6. Aggregate Methods
7. Conversion Methods
8. Manipulation Methods
9. Indexing Operations
10. String Manipulation
11. Date and Time Manipulation
12. Dates in the Index
13. Plotting with a Series
14. Categorical Manipulation
15. Dataframes
16. Similarities with Series and Dataframe
17. Math Methods in Dataf rames
18. Looping and Aggregation
19. Columns Types, .assign, and Memory Usage
20. Creating and Updating Columns
21. Dealing with Missing and Duplicated Data
22. Sorting Columns and Indexes
23. Filtering and Indexing Operations
24. Plotting with Dataframes
25. Reshaping Dataframes with Dummies
26. Reshaping By Pivoting and Grouping
27. More Aggregations
28. Cross-tabulation Deep Dive
29. Melting, Transposing, and Stacking Data
30. Working with Time Series
31. Joining Dataframes
32. Exporting Data
33. Styling Dataframes
34. Debugging Pandas