Pandas Workout: 200 exercises to make you a stronger data analyst - Softcover

Lerner, Reuven

Softcover

ISBN 10: 1617299723 ISBN 13: 9781617299728

Publisher: Manning, 2024

Synopsis

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 to:

• 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.

Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.

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 sources: 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

About this title

About the Author

Reuven M. Lerner teaches Python and data science to companies around the world. He is also the author of Manning’s Python Workout (2020).

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

Discover 50 exercises that will strengthen your pandas skills to a level of automatic fluency. You'll test yourself against common pandas challenges such as data cleaning, and explore real-world datasets such as New York Taxis, Kickstarter projects, and global tourist spending. Detailed explanations help guide your success and make your new skills stick. You'll even get a big boost to productivity, with tasks that used to mean a trip to StackOverflow now a natural part of your skillset. about the technology Mastering pandas means working out your new skills until they become like reflexes. This book gives you lots of pandas practice by working through the kind of scenarios you'll face in the real world. Whether you're a data scientist or a programmer handling large quantities of data, you'll soon overcome pandas's learning curve and start solving complex problems in less time. about the book Pandas Workout hones your pandas skills to a professional-level through 50 hands-on exercises, along with 150 bonus challenges to really test your skills. Expert Python trainer Reuven Lerner coaches you through essentials like data frames and reveals pandas's rich functionality for string and date/time handling, complex indexing, and visualization. Clear explanations and detailed Jupyter Notebooks accompany every exercise, along with comparisons of different possible solutions. Work through this book, and you'll be ready to flex your muscles against even the trickiest pandas problems!

Edition details

• Publisher: Manning
• Publication date: 2024
• Language: English
• ISBN 10: 1617299723
• ISBN 13: 9781617299728
• Binding: Paperback
• Number of pages: 440