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. 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! RETAIL SELLING POINTS   • 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  AUDIENCE  For Python programmers and data analysts, with basic knowledge of pandas. 

Python Workout presents 50 exercises designed to deepen the reader's skill with Python. Readers will not only tackle exercises using built-in data structures, but also more advanced techniques, such as functional programming, object-oriented programming, iterators, and generators. With each engaging challenge, readers will practice a new skill and learn how to apply it to everyday coding tasks. Key Features 50 hands-on exercises and solutions Basic Python sequence types Python dictionaries and sets Functional programming in Python Creating your own classes Working with Python objects Generator functions Intended for readers with basic Python skills. About the technology Python is a versatile, elegant, general purpose programming language. Essential for data analysis, web development, artificial intelligence, games, desktop apps, and more, Python skills are a hot commodity. Reuven M. Lerner, an independent consultant for more than two decades, teaches Python, data science, and Git to companies around the world. His Better developers newsletter and blog are read by thousands of Python developers each week. Reuven has written a monthly column, "At the Forge," for Linux Journal since 1996 and is a panellist on the weekly Freelancers Show podcast. Reuven lives with his wife and three children in Modi'in, Israel, and can be reached at https://lerner.co.il/ or on Twitter at @reuvenmlerner.