Home Page Icon
Home Page
Table of Contents for
cover
Close
cover
by Matt Harrison, Theodore Petrou
Pandas 1.x Cookbook
Preface
Who this book is for
What this book covers
To get the most out of this book
Download the example code files
Running a Jupyter Notebook
Download the color images
Conventions
Get in touch
Reviews
Pandas Foundations
Importing pandas
Introduction
The pandas DataFrame
How it works…
DataFrame attributes
How to do it…
How it works…
There's more...
Understanding data types
How to do it…
How it works…
There's more…
Selecting a column
How to do it…
How it works…
There's more…
Calling Series methods
How to do it…
How it works…
There's more…
Series operations
How to do it…
How it works…
There's more…
Chaining Series methods
How to do it…
How it works…
There's more…
Renaming column names
How to do it…
How it works…
There's more…
Creating and deleting columns
How to do it…
How it works…
There's more…
Essential DataFrame Operations
Introduction
Selecting multiple DataFrame columns
How to do it...
How it works...
There's more...
Selecting columns with methods
How to do it...
How it works...
There's more...
Ordering column names
How to do it...
How it works...
There's more...
Summarizing a DataFrame
How to do it...
How it works...
There's more...
Chaining DataFrame methods
How to do it...
How it works...
There's more...
DataFrame operations
How to do it...
How it works...
There's more...
Comparing missing values
Getting ready
How to do it...
How it works...
There's more...
Transposing the direction of a DataFrame operation
How to do it...
How it works...
There's more...
Determining college campus diversity
How to do it...
How it works...
There's more...
Creating and Persisting DataFrames
Introduction
Creating DataFrames from scratch
How to do it...
How it works...
There's more...
Writing CSV
How to do it...
There's more...
Reading large CSV files
How to do it...
How it works...
There's more...
Using Excel files
How to do it...
How it works...
There's more...
Working with ZIP files
How to do it...
How it works...
There's more...
Working with databases
How to do it...
How it works...
Reading JSON
How to do it...
How it works...
There's more...
Reading HTML tables
How to do it...
How it works...
There's more...
Beginning Data Analysis
Introduction
Developing a data analysis routine
How to do it…
How it works…
There's more…
Data dictionaries
Reducing memory by changing data types
How to do it…
How it works…
There's more…
Selecting the smallest of the largest
How to do it…
How it works…
There's more…
Selecting the largest of each group by sorting
How to do it…
How it works…
There's more…
Replicating nlargest with sort_values
How to do it…
How it works…
Calculating a trailing stop order price
How to do it…
How it works…
There's more…
Exploratory Data Analysis
Introduction
Summary statistics
How to do it…
How it works…
There's more…
Column types
How to do it…
How it works…
There's more…
Categorical data
How to do it…
How it works…
There's more…
Continuous data
How to do it…
How it works…
There's more…
Comparing continuous values across categories
How to do it…
How it works…
There's more…
Comparing two continuous columns
How to do it…
How it works…
There's more…
Comparing categorical values with categorical values
How to do it…
How it works…
Using the pandas profiling library
How to do it…
How it works…
Selecting Subsets of Data
Introduction
Selecting Series data
How to do it…
How it works…
There's more…
Selecting DataFrame rows
How it works…
There's more…
Selecting DataFrame rows and columns simultaneously
How to do it…
How it works…
There's more…
Selecting data with both integers and labels
How to do it…
How it works…
There's more…
Slicing lexicographically
How to do it…
How it works…
There's more…
Filtering Rows
Introduction
Calculating Boolean statistics
How to do it…
How it works…
There's more…
Constructing multiple Boolean conditions
How to do it…
How it works…
There's more…
Filtering with Boolean arrays
How to do it…
How it works…
There's more…
Comparing row filtering and index filtering
How to do it…
How it works…
There's more…
Selecting with unique and sorted indexes
How to do it…
How it works…
There's more…
Translating SQL WHERE clauses
How to do it…
How it works…
There's more…
Improving the readability of Boolean indexing with the query method
How to do it…
How it works…
There's more…
Preserving Series size with the .where method
How to do it…
How it works…
There's more…
Masking DataFrame rows
How to do it…
How it works…
There's more…
Selecting with Booleans, integer location, and labels
How to do it…
How it works…
Index Alignment
Introduction
Examining the Index object
How to do it…
How it works…
There's more…
Producing Cartesian products
How to do it…
How it works…
There's more…
Exploding indexes
How to do it…
How it works…
There's more…
Filling values with unequal indexes
How to do it…
How it works…
There's more…
Adding columns from different DataFrames
How to do it…
How it works…
There's more…
Highlighting the maximum value from each column
How to do it…
How it works…
There's more…
Replicating idxmax with method chaining
How to do it…
How it works…
There's more…
Finding the most common maximum of columns
How to do it…
How it works…
There's more…
Grouping for Aggregation, Filtration, and Transformation
Introduction
Defining an aggregation
How to do it…
How it works…
There's more…
Grouping and aggregating with multiple columns and functions
How to do it…
How it works…
There's more…
Removing the MultiIndex after grouping
How to do it…
How it works…
There's more…
Grouping with a custom aggregation function
How to do it…
How it works…
There's more…
Customizing aggregating functions with *args and **kwargs
How to do it…
How it works…
There's more…
Examining the groupby object
How to do it…
How it works…
There's more…
Filtering for states with a minority majority
How to do it…
How it works…
There's more…
Transforming through a weight loss bet
How to do it…
How it works…
There's more…
Calculating weighted mean SAT scores per state with apply
How to do it…
How it works…
There's more…
Grouping by continuous variables
How to do it…
How it works…
There's more…
Counting the total number of flights between cities
How to do it…
How it works…
There's more…
Finding the longest streak of on-time flights
How to do it…
How it works…
There's more…
Restructuring Data into a Tidy Form
Introduction
Tidying variable values as column names with stack
How to do it…
How it works…
There's more…
Tidying variable values as column names with melt
How to do it…
How it works…
There's more…
Stacking multiple groups of variables simultaneously
How to do it…
How it works…
There's more…
Inverting stacked data
How to do it…
How it works…
There's more…
Unstacking after a groupby aggregation
How to do it…
How it works…
There's more…
Replicating pivot_table with a groupby aggregation
How to do it…
How it works…
There's more…
Renaming axis levels for easy reshaping
How to do it…
How it works…
There's more…
Tidying when multiple variables are stored as column names
How to do it…
How it works…
There's more…
Tidying when multiple variables are stored as a single column
How to do it…
How it works…
There's more…
Tidying when two or more values are stored in the same cell
How to do it...
How it works…
There's more…
Tidying when variables are stored in column names and values
How to do it…
How it works…
There's more…
Combining Pandas Objects
Introduction
Appending new rows to DataFrames
How to do it…
How it works…
There's more…
Concatenating multiple DataFrames together
How to do it…
How it works…
There's more…
Understanding the differences between concat, join, and merge
How to do it…
How it works…
There's more…
Connecting to SQL databases
How to do it…
How it works…
There's more…
Time Series Analysis
Introduction
Understanding the difference between Python and pandas date tools
How to do it…
How it works…
Slicing time series intelligently
How to do it…
How it works…
There's more…
Filtering columns with time data
How to do it…
How it works…
There's more…
Using methods that only work with a DatetimeIndex
How to do it…
How it works…
There's more…
Counting the number of weekly crimes
How to do it…
How it works…
There's more…
Aggregating weekly crime and traffic accidents separately
How to do it…
How it works…
There's more…
Measuring crime by weekday and year
How to do it…
How it works…
There's more…
Grouping with anonymous functions with a DatetimeIndex
How to do it…
How it works…
Grouping by a Timestamp and another column
How to do it…
How it works…
There's more…
Visualization with Matplotlib, Pandas, and Seaborn
Introduction
Getting started with matplotlib
Object-oriented guide to matplotlib
How to do it…
How it works…
There's more…
Visualizing data with matplotlib
How to do it…
How it works…
There's more…
Plotting basics with pandas
How to do it…
How it works…
There's more…
Visualizing the flights dataset
How to do it…
How it works…
Stacking area charts to discover emerging trends
How to do it…
How it works…
Understanding the differences between seaborn and pandas
How to do it…
How it works…
Multivariate analysis with seaborn Grids
How to do it…
How it works…
There's more…
Uncovering Simpson's Paradox in the diamonds dataset with seaborn
How to do it…
How it works…
There's more…
Debugging and Testing Pandas
Code to transform data
How to do it…
How it works…
Apply performance
How to do it…
How it works…
There's more…
Improving apply performance with Dask, Pandarell, Swifter, and more
How to do it…
How it works…
Inspecting code
How to do it…
How it works…
There's more…
Debugging in Jupyter
How to do it…
How it works…
There's more…
Managing data integrity with Great Expectations
How to do it…
How it works…
Using pytest with pandas
How to do it…
How it works…
There's more…
Generating tests with Hypothesis
How to do it…
How it works…
Other Books You May Enjoy
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title_Page
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset