The Pandas Workshop: A comprehensive guide to using Python for data analysis with real-world case studies

Learn the fundamentals of data science with Python by analyzing real datasets and solving problems using pandas

Key Features

• Learn how to apply data retrieval, transformation, visualization, and modeling techniques using pandas
• Become highly efficient in unlocking deeper insights from your data, including databases, web data, and more
• Build your experience and confidence with hands-on exercises and activities

Book Description

The  Pandas Workshop will teach you how to be more productive with data and  generate real business insights to inform your decision-making. You will  be guided through real-world data science problems and shown how to  apply key techniques in the context of realistic examples and exercises.  Engaging activities will then challenge you to apply your new skills in  a way that prepares you for real data science projects.

You'll  see how experienced data scientists tackle a wide range of problems  using data analysis with pandas. Unlike other Python books, which focus  on theory and spend too long on dry, technical explanations, this  workshop is designed to quickly get you to write clean code and build  your understanding through hands-on practice. As you work through this  Python pandas book, you'll tackle various real-world scenarios, such as  using an air quality dataset to understand the pattern of nitrogen  dioxide emissions in a city, as well as analyzing transportation data to  improve bus transportation services.

By the end of  this data analytics book, you'll have the knowledge, skills, and  confidence you need to solve your own challenging data science problems  with pandas.

What you will learn

• Access and load data from different sources using pandas
• Work with a range of data types and structures to understand your data
• Perform data transformation to prepare it for analysis
• Use Matplotlib for data visualization to create a variety of plots
• Create data models to find relationships and test hypotheses
• Manipulate time-series data to perform date-time calculations
• Optimize your code to ensure more efficient business data analysis

Who this book is for

This  data analysis book is for anyone with prior experience working with the  Python programming language who wants to learn the fundamentals of data  analysis with pandas. Previous knowledge of pandas is not necessary.

1. An Introduction to pandas
2. Working with Data Structures
3. Data I/O
4. pandas Data Types
5. Data Selection – DataFrames
6. Data Selection – Series
7. Data Exploration and Transformation
8. Data Visualization
9. Data Modeling – Preprocessing
10. Data Modeling – Modeling Basics
11. Data Modeling – Regression Modeling
12. Using Time in pandas
13. Exploring Time Series
14. Applying pandas Data Processing for Case Studies