Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

Mastering pandas: A complete guide to pandas, from installation to advanced data analysis techniques , Second Edition

Kumar

€29.99

eBook Oct 2019 674 pages 2nd Edition

Kumar

€29.99

eBook Oct 2019 674 pages 2nd Edition

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

View table of contents

Preview Book

Download Code

Key benefits

Manipulate and analyze your data expertly using the power of pandas
Work with missing data and time series data and become a true pandas expert
Includes expert tips and techniques on making your data analysis tasks easier

Description

pandas is a popular Python library used by data scientists and analysts worldwide to manipulate and analyze their data. This book presents useful data manipulation techniques in pandas to perform complex data analysis in various domains. An update to our highly successful previous edition with new features, examples, updated code, and more, this book is an in-depth guide to get the most out of pandas for data analysis. Designed for both intermediate users as well as seasoned practitioners, you will learn advanced data manipulation techniques, such as multi-indexing, modifying data structures, and sampling your data, which allow for powerful analysis and help you gain accurate insights from it. With the help of this book, you will apply pandas to different domains, such as Bayesian statistics, predictive analytics, and time series analysis using an example-based approach. And not just that; you will also learn how to prepare powerful, interactive business reports in pandas using the Jupyter notebook. By the end of this book, you will learn how to perform efficient data analysis using pandas on complex data, and become an expert data analyst or data scientist in the process.

Who is this book for?

This book is for data scientists, analysts and Python developers who wish to explore advanced data analysis and scientific computing techniques using pandas. Some fundamental understanding of Python programming and familiarity with the basic data analysis concepts is all you need to get started with this book.

What you will learn

Speed up your data analysis by importing data into pandas
Keep relevant data points by selecting subsets of your data
Create a high-quality dataset by cleaning data and fixing missing values
Compute actionable analytics with grouping and aggregation in pandas
Master time series data analysis in pandas
Make powerful reports in pandas using Jupyter notebooks

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Product Details

Publication date : Oct 25, 2019

Length: 674 pages

Edition : 2nd

Language : English

ISBN-13 : 9781789343359

Category :

Data

Languages :

Python

Concepts :

Scientific Computing

Tools :

Pandas

Frequently bought together

Mastering pandas

Oct 2019 674 pages

eBook

€29.99

Python Machine Learning

Dec 2019 772 pages

4.5 (41)

eBook

€32.99

Hands-On Data Analysis with Pandas

Jul 2019 740 pages

4.7 (11)

eBook

€29.99

Total € 115.97

€36.99

€41.99

€36.99

Total € 115.97

20 Chapters

Section 1: Overview of Data Analysis and pandas

Introduction to pandas and Data Analysis

Motivation for data analysis

Data analytics pipeline

How Python and pandas fit into the data analytics pipeline

What is pandas?

Where does pandas fit in the pipeline?

Benefits of using pandas

History of pandas

Usage pattern and adoption of pandas

pandas on the technology adoption curve

Popular applications of pandas

Summary

References

Installation of pandas and Supporting Software

Selecting a version of Python to use

Standalone Python installation

Installation of Python and pandas using Anaconda

Dependency packages for pandas

Review of items installed with Anaconda

Cross tooling – combining pandas awesomeness with R, Julia, H20.ai, and Azure ML Studio

Command line tricks for pandas

Options and settings for pandas

Summary

Further reading

Section 2: Data Structures and I/O in pandas

Using NumPy and Data Structures with pandas

NumPy ndarrays

Implementing neural networks with NumPy

Practical applications of multidimensional arrays

Data structures in pandas

Summary

References

I/Os of Different Data Formats with pandas

Data sources and pandas methods

Reading feather files

Reading parquet files

Reading a SQL file

Reading a SAS/Stata file

Reading from Google BigQuery

Reading from a clipboard

Managing sparse data

Writing JSON objects to a file

Serialization/deserialization

Writing to exotic file types

GeoPandas

Open source APIs – Quandl

Pandas plotting

pandas-datareader

Summary

Section 3: Mastering Different Data Operations in pandas

Indexing and Selecting in pandas

Basic indexing

Labels, integer, and mixed indexing

Multi-indexing

Boolean indexing

Operations on indexes

Summary

Grouping, Merging, and Reshaping Data in pandas

Grouping data

Merging and joining

Pivots and reshaping data

Other methods for reshaping DataFrames

Summary

Special Data Operations in pandas

Writing and applying one-liner custom functions

Handling missing values

A survey of methods on series

pandas string methods

Binary operations on DataFrames and series

Binning values

Using mathematical methods on DataFrames

Summary

Time Series and Plotting Using Matplotlib

Handling time series data

A summary of time series-related objects

Plotting using matplotlib

Summary

Section 4: Going a Step Beyond with pandas

Making Powerful Reports In Jupyter Using pandas

pandas styling

Navigating Jupyter Notebook

Summary

A Tour of Statistics with pandas and NumPy

Descriptive statistics versus inferential statistics

Measures of central tendency and variability

Hypothesis testing – the null and alternative hypotheses

Summary

A Brief Tour of Bayesian Statistics and Maximum Likelihood Estimates

Introduction to Bayesian statistics

The mathematical framework for Bayesian statistics

Probability distributions

Bayesian statistics versus frequentist statistics

Conducting Bayesian statistical analysis

Monte Carlo estimation of the likelihood function and PyMC

References

Summary

Data Case Studies Using pandas

End-to-end exploratory data analysis

Web scraping with Python

Data validation

Summary

The pandas Library Architecture

Understanding the pandas file hierarchy

Improving performance using Python extensions

Summary

pandas Compared with Other Tools

Comparison with R

Slicing and selection

Comparison with SQL

Comparison with SAS

Summary

A Brief Tour of Machine Learning

The role of pandas in machine learning

Installation of scikit-learn

Introduction to machine learning

Application of machine learning – Kaggle Titanic competition

Data analysis and preprocessing using pandas

A naive approach to the Titanic problem

The scikit-learn ML/classifier interface

Supervised learning algorithms

Unsupervised learning algorithms

Summary

Other Books You May Enjoy

Leave a review - let other readers know what you think

Recommendations for you

Python Machine Learning By Example

Jul 2024 518 pages

4.9 (8)

eBook

€27.99

Building AI Applications with OpenAI APIs

Oct 2024 252 pages

eBook

€23.99

Unlocking Data with Generative AI and RAG

Sep 2024 346 pages

eBook

€23.99

Building LLM Powered Applications

May 2024 342 pages

4.2 (22)

eBook

€29.99

RAG-Driven Generative AI

Sep 2024 334 pages

4.5 (13)

eBook

€32.99

Machine Learning with PyTorch and Scikit-Learn

Feb 2022 774 pages

4.4 (95)

eBook

€32.99

Python for Algorithmic Trading Cookbook

Aug 2024 404 pages

4.6 (15)

eBook

€35.99

Microsoft Power BI - The Complete Masterclass [2023 EDITION]

Jan 2023 14hrs 31mins

Video

€82.99

Principles of Data Science

Jan 2024 326 pages

4.8 (4)

eBook

€23.99

Mastering NLP from Foundations to LLMs

Apr 2024 340 pages

4.9 (24)

eBook

€31.99

People who bought this also bought

Machine Learning Engineering with Python

Aug 2023 462 pages

4.6 (36)

eBook

€29.99

Deep Learning with TensorFlow and Keras – 3rd edition

Oct 2022 698 pages

4.6 (45)

eBook

€29.99

Modern Generative AI with ChatGPT and OpenAI Models

May 2023 286 pages

4.2 (34)

eBook

€29.99

Generative AI with LangChain

Dec 2023 368 pages

4 (34)

eBook

€29.99

Causal Inference and Discovery in Python

May 2023 456 pages

4.5 (49)

eBook

€23.99

About the author

Kumar

Ashish Kumar is a seasoned data science professional, a publisher author and a thought leader in the field of data science and machine learning. An IIT Madras graduate and a Young India Fellow, he has around 7 years of experience in implementing and deploying data science and machine learning solutions for challenging industry problems in both hands-on and leadership roles. Natural Language Procession, IoT Analytics, R Shiny product development, Ensemble ML methods etc. are his core areas of expertise. He is fluent in Python and R and teaches a popular ML course at Simplilearn. When not crunching data, Ashish sneaks off to the next hip beach around and enjoys the company of his Kindle. He also trains and mentors data science aspirants and fledgling start-ups.

See other products by Kumar

FAQs

How do I buy and download an eBook?

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

You may make copies of your eBook for your own use onto any machine
You may not pass copies of the eBook on to anyone else

How can I make a purchase on your website?

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

Register on our website using your email address and the password.
Search for the title by name or ISBN using the search option.
Select the title you want to purchase.
Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title.
Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)

Where can I access support around an eBook?

If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
To view your account details or to download a new copy of the book go to www.packtpub.com/account
To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us

What eBook formats do Packt support?

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks?

You can get the information you need immediately
You can easily take them with you on a laptop
You can download them an unlimited number of times
You can print them out
They are copy-paste enabled
They are searchable
There is no password protection
They are lower price than print
They save resources and space

What is an eBook?

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.

Mastering pandas: A complete guide to pandas, from installation to advanced data analysis techniques , Second Edition

What do you get with eBook?