Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Pandas Cookbook - Third Edition

By : William Ayd, Matthew Harrison

4.9 (10)

Pandas Cookbook

4.9 (10)

By: William Ayd, Matthew Harrison

Overview of this book

Unlock the full power of pandas 2.x with this hands-on cookbook, designed for Python developers, data analysts, and data scientists who need fast, efficient solutions for real-world data challenges. This book provides practical, ready-to-use recipes to streamline your workflow. With step-by-step guidance, you'll master data wrangling, visualization, performance optimization, and scalable data analysis using pandas’ most powerful features. From importing and merging large datasets to advanced time series analysis and SQL-like operations, this cookbook equips you with the tools to analyze, manipulate, and visualize data like a pro. Learn how to boost efficiency, optimize memory usage, and seamlessly integrate pandas with NumPy, PyArrow, and databases. This book will help you transform raw data into actionable insights with ease. *Email sign-up and proof of purchase required

Preface

Preface

Who this book is for

What this book covers

To get the most out of this book

Sections

Get in touch

Reviews

Leave a Review!

Making the Most Out of This Book – Get to Know Your Free Benefits

Free Chapter

pandas Foundations

pandas Foundations

Importing pandas

Series

DataFrame

Index

Series attributes

DataFrame attributes

Selection and Assignment

Selection and Assignment

Basic selection from a Series

Basic selection from a DataFrame

Position-based selection of a Series

Position-based selection of a DataFrame

Label-based selection from a Series

Label-based selection from a DataFrame

Mixing position-based and label-based selection

DataFrame.filter

Selection by data type

Selection/filtering via Boolean arrays

Selection with a MultiIndex – A single level

Selection with a MultiIndex – Multiple levels

Selection with a MultiIndex – a DataFrame

Item assignment with .loc and .iloc

DataFrame column assignment

Data Types

Data Types

Integral types

Floating point types

Boolean types

String types

Missing value handling

Categorical types

Temporal types – datetime

Temporal types – timedelta

Temporal PyArrow types

PyArrow List types

PyArrow decimal types

NumPy type system, the object type, and pitfalls

The pandas I/O System

The pandas I/O System

CSV – basic reading/writing

CSV – strategies for reading large files

Microsoft Excel – basic reading/writing

Microsoft Excel – finding tables in non-default locations

Microsoft Excel – hierarchical data

SQL using SQLAlchemy

SQL using ADBC

Apache Parquet

JSON

HTML

Pickle

Third-party I/O libraries

Algorithms and How to Apply Them

Algorithms and How to Apply Them

Basic pd.Series arithmetic

Basic pd.DataFrame arithmetic

Aggregations

Transformations

Map

Apply

Summary statistics

Binning algorithms

One-hot encoding with pd.get_dummies

Chaining with .pipe

Selecting the lowest-budget movies from the top 100

Calculating a trailing stop order price

Finding the baseball players best at…

Understanding which position scores the most per tea

Visualization

Visualization

Creating charts from aggregated data

Plotting distributions of non-aggregated data

Further plot customization with Matplotlib

Exploring scatter plots

Exploring categorical data

Exploring continuous data

Using seaborn for advanced plots

Reshaping DataFrames

Reshaping DataFrames

Concatenating pd.DataFrame objects

Merging DataFrames with pd.merge

Joining DataFrames with pd.DataFrame.join

Reshaping with pd.DataFrame.stack and pd.DataFrame.unstack

Reshaping with pd.DataFrame.melt

Reshaping with pd.wide_to_long

Reshaping with pd.DataFrame.pivot and pd.pivot_table

Reshaping with pd.DataFrame.explode

Transposing with pd.DataFrame.T

Group By

Group By

Group by basics

Grouping and calculating multiple columns

Group by apply

Window operations

Selecting the highest rated movies by year

Comparing the best hitter in baseball across years

Temporal Data Types and Algorithms

Temporal Data Types and Algorithms

Timezone handling

DateOffsets

Datetime selection

Resampling

Aggregating weekly crime and traffic accidents

Calculating year-over-year changes in crime by category

Accurately measuring sensor-collected events with missing values

General Usage and Performance Tips

General Usage and Performance Tips

Avoid dtype=object

Be cognizant of data sizes

Use vectorized functions instead of loops

Avoid mutating data

Dictionary-encode low cardinality data

Test-driven development features

The pandas Ecosystem

The pandas Ecosystem

Foundational libraries

Exploratory data analysis

Data validation

Visualization

Data science

Databases

Other DataFrame libraries

Other Books You May Enjoy

Other Books You May Enjoy

Index

Index

Reshaping with pd.DataFrame.pivot and pd.pivot_table

So far in this chapter, we have seen that pd.DataFrame.stack, pd.DataFrame.melt, and pd.wide_to_long can all be used to help you convert your pd.DataFrame from a wide to a long format. On the flip side, we have only seen pd.Series.unstack helps us go from long to wide, but that method has the downside of requiring us to assign a proper row index before we can use it. With pd.DataFrame.pivot, you can skip any intermediate steps and go directly from a long to a wide format.

Beyond pd.DataFrame.pivot, pandas offers a pd.pivot_table function, which can not only reshape from long to wide but allows you to perform aggregations as part of the reshape.

Figure 7.6: Using pd.pivot_table to reshape with sum aggregation

Effective use of pd.pivot_table allows you to perform very complex calculations with a compact and concise syntax.

How to do it

In many of the preceding recipes, we have started with data in wide form...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Pandas Cookbook

Search

Your notes and bookmarks