Pandas cookbook : recipes for scientific computing, time series analysis and data visualization using Python /

Includes index.

Preface Packt --
Preface --
What this book covers --
What you need for this book --
Who this book is for --
Conventions --
Assumptions for every recipe --
Dataset Descriptions --
Sections --
Reader feedback --
Customer support --
Pandas Foundations Packt --
Pandas Foundations --
Introduction --
Dissecting the anatomy of a DataFrame --
Accessing the main DataFrame components --
Understanding data types --
Selecting a single column of data as a Series --
Calling Series methods --
Working with operators on a Series --
Chaining Series methods together --
Making the index meaningful --
Renaming row and column names --
Creating and deleting columns --
Essential DataFrame Operations Packt --
Essential DataFrame Operations --
Introduction --
Selecting multiple DataFrame columns --
Selecting columns with methods --
Ordering column names sensibly --
Operating on the entire DataFrame --
Chaining DataFrame methods together --
Working with operators on a DataFrame --
Comparing missing values --
Transposing the direction of a DataFrame operation --
Determining college campus diversity --
Beginning Data Analysis Packt --
Beginning Data Analysis --
Introduction --
Developing a data analysis routine --
Reducing memory by changing data types --
Selecting the smallest of the largest --
Selecting the largest of each group by sorting --
Replicating nlargest with sort_values --
Calculating a trailing stop order price --
Selecting Subsets of Data Packt --
Selecting Subsets of Data --
Introduction --
Selecting Series data --
Selecting DataFrame rows --
Selecting DataFrame rows and columns simultaneously --
Selecting data with both integers and labels --
Speeding up scalar selection --
Slicing rows lazily --
Slicing lexicographically --
Boolean Indexing Packt --
Boolean Indexing --
Introduction --
Calculating boolean statistics --
Constructing multiple boolean conditions --
Filtering with boolean indexing --
Replicating boolean indexing with index selection --
Selecting with unique and sorted indexes --
Gaining perspective on stock prices --
Translating SQL WHERE clauses --
Determining the normality of stock market returns --
Improving readability of boolean indexing with the query method --
Preserving Series with the where method --
Masking DataFrame rows --
Selecting with booleans, integer location, and labels --
Index Alignment Packt --
Index Alignment --
Introduction --
Examining the Index object --
Producing Cartesian products --
Exploding indexes --
Filling values with unequal indexes --
Appending columns from different DataFrames --
Highlighting the maximum value from each column --
Replicating idxmax with method chaining --
Finding the most common maximum --
Grouping for Aggregation, Filtration, and Transformation Packt --
Grouping for Aggregation, Filtration, and Transformation --
Introduction --
Defining an aggregation --
Grouping and aggregating with multiple columns and functions --
Removing the MultiIndex after grouping --
Customizing an aggregation function --
Customizing aggregating functions with *args and **kwargs --
Examining the groupby object --
Filtering for states with a minority majority --
Transforming through a weight loss bet --
Calculating weighted mean SAT scores per state with apply --
Grouping by continuous variables --
Counting the total number of flights between cities --
Finding the longest streak of on-time flights --
Restructuring Data into a Tidy Form Packt --
Restructuring Data into a Tidy Form --
Introduction --
Tidying variable values as column names with stack --
Tidying variable values as column names with melt --
Stacking multiple groups of variables simultaneously --
Inverting stacked data --
Unstacking after a groupby aggregation --
Replicating pivot_table with a groupby aggregation --
Renaming axis levels for easy reshaping --
Tidying when multiple variables are stored as column names --
Tidying when multiple variables are stored as column values --
Tidying when two or more values are stored in the same cell --
Tidying when variables are stored in column names and values --
Tidying when multiple observational units are stored in the same table --
Combining Pandas Objects Packt --
Combining Pandas Objects --
Introduction --
Appending new rows to DataFrames --
Concatenating multiple DataFrames together --
Comparing President Trump's and Obama's approval ratings --
Understanding the differences between concat, join, and merge --
Connecting to SQL databases --
Time Series Analysis Packt --
Time Series Analysis --
Introduction --
Understanding the difference between Python and pandas date tools --
Slicing time series intelligently --
Using methods that only work with a DatetimeIndex --
Counting the number of weekly crimes --
Aggregating weekly crime and traffic accidents separately --
Measuring crime by weekday and year --
Grouping with anonymous functions with a DatetimeIndex --
Grouping by a Timestamp and another column --
Finding the last time crime was 20% lower with merge_asof --
Visualization with Matplotlib, Pandas, and Seaborn

Over 95 hands-on recipes to leverage the power of pandas for efficient scientific computation and data analysis About This Book Use the power of pandas to solve most complex scientific computing problems with ease Leverage fast, robust data structures in pandas to gain useful insights from your data Practical, easy to implement recipes for quick solutions to common problems in data using pandas Who This Book Is For This book is for data scientists, analysts and Python developers who wish to explore data analysis and scientific computing in a practical, hands-on manner. The recipes included in this book are suitable for both novice and advanced users, and contain helpful tips, tricks and caveats wherever necessary. Some understanding of pandas will be helpful, but not mandatory. What You Will Learn Master the fundamentals of pandas to quickly begin exploring any dataset Isolate any subset of data by properly selecting and querying the data Split data into independent groups before applying aggregations and transformations to each group Restructure data into tidy form to make data analysis and visualization easier Prepare real-world messy datasets for machine learning Combine and merge data from different sources through pandas SQL-like operations Utilize pandas unparalleled time series functionality Create beautiful and insightful visualizations through pandas direct hooks to Matplotlib and Seaborn In Detail This book will provide you with unique, idiomatic, and fun recipes for both fundamental and advanced data manipulation tasks with pandas. Some recipes focus on achieving a deeper understanding of basic principles, or comparing and contrasting two similar operations. Other recipes will dive deep into a particular dataset, uncovering new and unexpected insights along the way. The pandas library is massive, and it's common for frequent users to be unaware of many of its more impressive features. The official pandas documentation, while thorough, does not contain many useful examples of how to piece together multiple commands like one would do during an actual analysis. This book guides you, as if you were looking over the shoulder of an expert, through practical situations that you are highly likely to encounter. Many advanced recipes combine several different features across the pandas library to generate results.