What do you think?
Pandas Workout: 200 exercises to make you a stronger data analyst
Practice makes perfect pandas!
Work out your pandas skills against dozens of real-world challenges, each carefully designed to build an intuitive knowledge of essential pandas tasks.
In Pandas Workout you’ll learn how
Clean your data for accurate analysis Work with rows and columns for retrieving and assigning data Handle indexes, including hierarchical indexes Read and write data with a number of common formats, such as CSV and JSON Process and manipulate textual data from within pandas Work with dates and times in pandas Perform aggregate calculations on selected subsets of data Produce attractive and useful visualizations that make your data come alive
Pandas Workout hones your pandas skills to a professional-level through two hundred exercises, each designed to strengthen your pandas skills. You’ll test your abilities against common pandas challenges such as importing and exporting, data cleaning, visualization, and performance optimization. Each exercise utilizes a real-world scenario based on real-world data, from tracking the parking tickets in New York City, to working out which country makes the best wines. You’ll soon find your pandas skills becoming second nature—no more trips to StackOverflow for what is now a natural part of your skillset.
About the technology
Python’s pandas library can massively reduce the time you spend analyzing, cleaning, exploring, and manipulating data. And the only path to pandas mastery is practice, practice, and, you guessed it, more practice. In this book, Python guru Reuven Lerner is your personal trainer and guide through over 200 exercises guaranteed to boost your pandas skills.
About the book
Pandas Workout is a thoughtful collection of practice problems, challenges, and mini-projects designed to build your data analysis skills using Python and pandas. The workouts use realistic data from many the New York taxi fleet, Olympic athletes, SAT scores, oil prices, and more. Each can be completed in ten minutes or less. You’ll explore pandas’ rich functionality for string and date/time handling, complex indexing, and visualization, along with practical tips for every stage of a data analysis project.
What's inside
Clean data with less manual labor Retrieving and assigning data Process and manipulate text Calculations on selected data subsets
About the reader
For Python programmers and data analysts.
About the author
Reuven M. Lerner teaches Python and data science around the world and publishes the “Bamboo Weekly” newsletter. He is the author of Manning’s Python Workout (2020).
Table of Contents
1 Series
2 Data frames
3 Importing and exporting data
4 Indexes
5 Cleaning data
6 Grouping, joining, and sorting
7 Advanced grouping, joining, and sorting
8 Midway project
9 Strings
10 Dates and times
11 Visualization
12 Performance
13 Final project
Work out your pandas skills against dozens of real-world challenges, each carefully designed to build an intuitive knowledge of essential pandas tasks.
In Pandas Workout you’ll learn how
Clean your data for accurate analysis Work with rows and columns for retrieving and assigning data Handle indexes, including hierarchical indexes Read and write data with a number of common formats, such as CSV and JSON Process and manipulate textual data from within pandas Work with dates and times in pandas Perform aggregate calculations on selected subsets of data Produce attractive and useful visualizations that make your data come alive
Pandas Workout hones your pandas skills to a professional-level through two hundred exercises, each designed to strengthen your pandas skills. You’ll test your abilities against common pandas challenges such as importing and exporting, data cleaning, visualization, and performance optimization. Each exercise utilizes a real-world scenario based on real-world data, from tracking the parking tickets in New York City, to working out which country makes the best wines. You’ll soon find your pandas skills becoming second nature—no more trips to StackOverflow for what is now a natural part of your skillset.
About the technology
Python’s pandas library can massively reduce the time you spend analyzing, cleaning, exploring, and manipulating data. And the only path to pandas mastery is practice, practice, and, you guessed it, more practice. In this book, Python guru Reuven Lerner is your personal trainer and guide through over 200 exercises guaranteed to boost your pandas skills.
About the book
Pandas Workout is a thoughtful collection of practice problems, challenges, and mini-projects designed to build your data analysis skills using Python and pandas. The workouts use realistic data from many the New York taxi fleet, Olympic athletes, SAT scores, oil prices, and more. Each can be completed in ten minutes or less. You’ll explore pandas’ rich functionality for string and date/time handling, complex indexing, and visualization, along with practical tips for every stage of a data analysis project.
What's inside
Clean data with less manual labor Retrieving and assigning data Process and manipulate text Calculations on selected data subsets
About the reader
For Python programmers and data analysts.
About the author
Reuven M. Lerner teaches Python and data science around the world and publishes the “Bamboo Weekly” newsletter. He is the author of Manning’s Python Workout (2020).
Table of Contents
1 Series
2 Data frames
3 Importing and exporting data
4 Indexes
5 Cleaning data
6 Grouping, joining, and sorting
7 Advanced grouping, joining, and sorting
8 Midway project
9 Strings
10 Dates and times
11 Visualization
12 Performance
13 Final project
845 pages, Kindle Edition
Published June 25, 2024
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 5 of 5 reviews
July 19, 2024
The Best Panda Is A Python Pandas
This is an excellent and comprehensive book on Python's Pandas framework.
A must-read for anyone in data analysis and data science.
These are my type of pandas!
Definitely recommend checking out this book. You will use it a lot.
4.8/5
This is an excellent and comprehensive book on Python's Pandas framework.
A must-read for anyone in data analysis and data science.
These are my type of pandas!
Definitely recommend checking out this book. You will use it a lot.
4.8/5
June 7, 2024
Pandas Workout is a very refreshing book on learning the roles of this ubiquitous data science library. I liked from the get go the concept of learning by doing which is why this resonated with me. That reminds me fully of the hedgehog concept where you spend 10,000 hours on something to achieve mastery. It’s also fairly gentle because the exercises in the book grow in incremental complexity. Give this book a try; like many Manning Publications books it will really exercise your Python pandas muscles.
This entire review has been hidden because of spoilers.
May 31, 2024
Fantastic book for the power users exercise their analytics muscles!
August 19, 2024
Fantastic. I completed the exercises using Polars and the book is just as applicable to that library as it is to Pandas.
July 6, 2024
A great collection of helpful tricks for Pandas. The examples are well-selected and will be of use for your daily tasks with Pandas.
Displaying 1 - 5 of 5 reviews