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
- Installation
- Data Structures
- Series Introduction
- Series Deep Dive
- Operators (& Dunder Methods)
- Aggregate Methods
- Conversion Methods
- Manipulation Methods
- Indexing Operations
- String Manipulation
- Date and Time Manipulation
- Dates in the Index
- Plotting with a Series
- Categorical Manipulation
- Dataframes
- Similarities with Series and Dataframe
- Math Methods in Dataf rames
- Looping and Aggregation
- Columns Types, .assign, and Memory Usage
- Creating and Updating Columns
- Dealing with Missing and Duplicated Data
- Sorting Columns and Indexes
- Filtering and Indexing Operations
- Plotting with Dataframes
- Reshaping Dataframes with Dummies
- Reshaping By Pivoting and Grouping
- More Aggregations
- Cross-tabulation Deep Dive
- Melting, Transposing, and Stacking Data
- Working with Time Series
- Joining Dataframes
- Exporting Data
- Styling Dataframes
- Debugging Pandas