0

All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

The Pandas Workshop

You're reading from The Pandas Workshop A comprehensive guide to using Python for data analysis with real-world case studies

Product type Book

Published in Jun 2022

Publisher Packt

ISBN-13 9781800208933

Pages 744 pages

Edition 1st Edition

Languages

Concepts

Authors (4):

Blaine Bateman

William So

Saikat Basak

Thomas Joseph

View More author details

Table of Contents (21) Chapters

Preface

1. Part 1 – Introduction to pandas

2. Chapter 1: Introduction to pandas FREE CHAPTER

3. Chapter 2: Working with Data Structures

4. Chapter 3: Data I/O

5. Chapter 4: Pandas Data Types

6. Part 2 – Working with Data

7. Chapter 5: Data Selection – DataFrames

8. Chapter 6: Data Selection – Series

9. Chapter 7: Data Exploration and Transformation

10. Chapter 8: Understanding Data Visualization

11. Part 3 – Data Modeling

12. Chapter 9: Data Modeling – Preprocessing

13. Chapter 10: Data Modeling – Modeling Basics

14. Chapter 11: Data Modeling – Regression Modeling

15. Part 4 – Additional Use Cases for pandas

16. Chapter 12: Using Time in pandas

17. Chapter 13: Exploring Time Series

18. Chapter 14: Applying pandas Data Processing for Case Studies

19. Chapter 15: Appendix

20. Other Books You May Enjoy

Activity 14.01 – analyzing air quality data

Consider that you're working as a data analyst for your city's municipality. The Department for the Environment needs your help in getting answers to some questions related to emissions. The following are the questions the department wants answers to:

Which day of the week has the highest NO2(GT) emissions?
At what time of the day are NMHC(GT) emissions highest?
Which month has the lowest CO(GT) emissions?
Note
The emissions dataset has been sourced from the following link:
https://archive.ics.uci.edu/ml/machine-learning-databases/00360/
You can find the dataset in the GitHub repository for this book. Download the data, unzip the data, and then load the CSV file in a data folder of your local machine. The department needs the answers through good visualizations.

The following steps will help you complete this activity:

Open a new Jupyter notebook.
Download the data and then read the data using...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (4)

Blaine Bateman

Blaine Bateman

Blaine Bateman has more than 35 years of experience working with various industries from government R&D to startups to $1B public companies. His experience focuses on analytics including machine learning and forecasting. His hands-on abilities include Python and R coding, Keras/Tensorflow, and AWS & Azure machine learning services. As a machine learning consultant, he has developed and deployed actual ML models in industry.

See other products by Blaine Bateman

William So

William So

William So is a Data Scientist with both a strong academic background and extensive professional experience. He is currently the Head of Data Science at Douugh and also a Lecturer for Master of Data Science and Innovation at the University of Technology Sydney. During his career, he successfully covered the end-end spectrum of data analytics from ML to Business Intelligence helping stakeholders derive valuable insights and achieve amazing results that benefits the business. William is a co-author of the "The Applied Artificial Intelligence Workshop" published by Packt.

See other products by William So

Saikat Basak

Saikat Basak

Saikat Basak is a data scientist and a passionate programmer. Having worked with multiple industry leaders, he has a good understanding of problem areas that can potentially be solved using data. Apart from being a data guy, he is also a science geek and loves to explore new ideas in the frontiers of science and technology.

See other products by Saikat Basak

Thomas Joseph

Thomas Joseph

Thomas V. Joseph is a data science practitioner, researcher, trainer, mentor, and writer with more than 19 years of experience. He has extensive experience in solving business problems using machine learning toolsets across multiple industry segments.

See other products by Thomas Joseph

Personalised recommendations for you

Based on your interests and search pattern

Ever wonder why speech recognition systems don't understand the Scottish accent, or what would happen if an astronaut only ate mac 'n' cheese, or other spurious reflections you'd have at a bar? We did, then collated those deliberations into absurd research articles with fake figures and methodologies inspired by even more fictionally absurd studies.

Aug 2023 7h 40m

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive exploration of LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12h 16m

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive exploration of LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12h 16m

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive exploration of LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12h 16m

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive exploration of LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12h 16m

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive exploration of LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12h 16m

Mastering Tableau 2023

Mastering Tableau 2023

This book is a comprehensive resource to mastering your Tableau skills and becoming a BI expert. As you progress, you will learn how to build advanced dashboards and improve your storytelling to derive key business insight, as well as make you well-versed with advanced functionalities of Tableau in the business intelligence domain.

Aug 2023 22h 48m

Building AI Applications with ChatGPT APIs

Building AI Applications with ChatGPT APIs

This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.

Sep 2023 8h 36m

Building AI Applications with ChatGPT APIs

Building AI Applications with ChatGPT APIs

This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.

Sep 2023 8h 36m

Data Engineering with AWS

Data Engineering with AWS

Embark on a journey to master data engineering pipelines on AWS! Our book offers a hands-on experience of AWS services for ingesting, transforming, and consuming data. Whether you're an absolute beginner or someone with basic data engineering experience, this guide is an indispensable resource.

Oct 2023 21h 12m

Modern Data Architecture on AWS

Modern Data Architecture on AWS

Every organization wants an agile, performant, and cost-effective data platform that meets all their current and future business needs. Purpose-built AWS analytics services and their features play a big part in building such a modern data platform. This book brings to you all the design and architectural patterns that’ll help you achieve this goal.

Aug 2023 14h 0m

Practical Guide to Applied Conformal Prediction in Python

Practical Guide to Applied Conformal Prediction in Python

Discover the power of Conformal Prediction with the "Practical Guide to Applied Conformal Prediction in Python." Master the latest techniques to quantify uncertainty in machine learning and computer vision models, and seamlessly apply them to your industry applications.