Pandas Cookbook 2017 pdf 2分

Table of Contents Preface What this book covers What you need for this book Running a Jupyter Notebook Who this book is for How to get the most out of this book Conventions Assumptions for every recipe Dataset Descriptions Sections Getting ready How to do it... How it works... There's more... See also Reader feedback Customer support Downloading the example code Downloading the color images of this book Errata Piracy Questions 1. Pandas Foundations Introduction Dissecting the anatomy of a DataFrame Getting ready How to do it... How it works... There's more... See also Accessing the main DataFrame components Getting ready How to do it... How it works... There's more... See also Understanding data types Getting ready How to do it... How it works... There's more... See also Selecting a single column of data as a Series Getting ready How to do it... How it works... There's more... See also Calling Series methods Getting ready How to do it... How it works... There's more... See also Working with operators on a Series Getting ready How to do it... How it works... There's more... See also Chaining Series methods together Getting ready How to do it... How it works... There's more... Making the index meaningful Getting ready How to do it... How it works... There's more... See also Renaming row and column names Getting ready How to do it... How it works... There's more... Creating and deleting columns Getting ready How to do it... How it works... There's more... See also 2. Essential DataFrame Operations Introduction Selecting multiple DataFrame columns Getting ready How to do it... How it works... There's more... Selecting columns with methods Getting ready How it works... How it works... There's more... See also Ordering column names sensibly Getting ready How to do it... How it works... There's more... See also Operating on the entire DataFrame Getting ready How to do it... How it works... There's more... Chaining DataFrame methods together Getting ready How to do it... How it works... There's more... See also Working with operators on a DataFrame Getting ready How to do it... How it works... There's more... See also Comparing missing values Getting ready How to do it... How it works... There's more... Transposing the direction of a DataFrame operation Getting ready How to do it... How it works... There's more... See also Determining college campus diversity Getting ready How to do it... How it works... There's more... See also 3. Beginning Data Analysis Introduction Developing a data analysis routine Getting ready How to do it... How it works... There's more... Data dictionaries See also Reducing memory by changing data types Getting ready How to do it... How it works... There's more... See also Selecting the smallest of the largest Getting ready How to do it... How it works... There's more... Selecting the largest of each group by sorting Getting ready How to do it... How it works... There's more... Replicating nlargest with sort_values Getting ready How to do it... How it works... There's more... Calculating a trailing stop order price Getting ready How to do it... How it works... There's more... See also 4. Selecting Subsets of Data Introduction Selecting Series data Getting ready How to do it... How it works... There's more... See also Selecting DataFrame rows Getting ready How to do it... How it works... There's more... See also Selecting DataFrame rows and columns simultaneously Getting ready How to do it... How it works... There's more... Selecting data with both integers and labels Getting ready How to do it... How it works... There's more... See also Speeding up scalar selection Getting ready How to do it... How it works... There's more... Slicing rows lazily Getting ready How to do it... How it works... There's more... Slicing lexicographically Getting ready How to do it... How it works... There's more... 5. Boolean Indexing Introduction Calculating boolean statistics Getting ready How to do it... How it works... There's more... See also Constructing multiple boolean conditions Getting ready How to do it... How it works... There's more... See also Filtering with boolean indexing Getting ready How to do it... How it works... There's more... See also Replicating boolean indexing with index selection Getting ready How to do it... How it works... There's more... Selecting with unique and sorted indexes Getting ready How to do it... How it works... There's more... See also Gaining perspective on stock prices Getting ready How to do it... How it works... There's more... See also Translating SQL WHERE clauses Getting ready How to do it... How it works... There's more... See also Determining the normality of stock market returns Getting ready How to do it... How it works... There's more... See also Improving readability of boolean indexing with the query method Getting ready How to do it... How it works... There's more... See also Preserving Series with the where method Getting ready How to do it... How it works... There's more... See also Masking DataFrame rows Getting ready How to do it... How it works... There's more... See also Selecting with booleans, integer location, and labels Getting ready How to do it... How it works... There's more... See also 6. Index Alignment Introduction Examining the Index object Getting ready How to do it... How it works... There's more... See also Producing Cartesian products Getting ready How to do it... How it works... There's more... See also Exploding indexes Getting ready How to do it... How it works... There's more... Filling values with unequal indexes Getting ready How to do it... How it works... There's more... Appending columns from different DataFrames Getting ready How to do it... How it works... There's more... See also Highlighting the maximum value from each column Getting ready How to do it... How it works... There's more... See also Replicating idxmax with method chaining Getting ready How to do it... How it works... There's more... Finding the most common maximum Getting ready How to do it... How it works... There's more... 7. Grouping for Aggregation, Filtration, and Transformation Introduction Defining an aggregation Getting ready How to do it... How it works... There's more... See also Grouping and aggregating with multiple columns and functions Getting ready How to do it... How it works... There's more... Removing the MultiIndex after grouping Getting ready How to do it... How it works... There's more... Customizing an aggregation function Getting ready How to do it... How it works... There's more... Customizing aggregating functions with *args and **kwargs Getting ready How to do it... How it works... There's more... See also Examining the groupby object Getting ready How to do it... How it works... There's more... See also Filtering for states with a minority majority Getting ready How to do it... How it works... There's more... See also Transforming through a weight loss bet Getting ready How to do it... How it works... There's more... See also Calculating weighted mean SAT scores per state with apply Getting ready How to do it... How it works... There's more... See also Grouping by continuous variables Getting ready How to do it... How it works... There's more... See also