Textbook in PDF format

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
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.
Pandas approaches problems differently than Python. The syntax is the same, but the data structures are different, and the way you structure your solutions is also different. Pandas is so vast that it’s easy to lose track of all the techniques. And unlike the core Python language, which tries to adhere to the maxim “There should be only one way to do it,” there are often many ways to accomplish the same task in pandas. Knowing which of these ways is fastest to execute and easiest to maintain isn’t always obvious, even (or especially) if you’re an experienced Python developer.
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!