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

$19.99 per month

Paperback Oct 2019 674 pages 2nd Edition

Kumar

$19.99 per month

Paperback Oct 2019 674 pages 2nd Edition

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!

Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!

50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

Thousands of reference materials covering every tech concept you need to stay up to date.

Subscribe now

View plans & pricing

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 a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!

Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!

50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

Thousands of reference materials covering every tech concept you need to stay up to date.

Subscribe now

View plans & pricing

Product Details

Publication date : Oct 25, 2019

Length: 674 pages

Edition : 2nd

Language : English

ISBN-13 : 9781789343236

Category :

Data

Languages :

Python

Concepts :

Data Analysis

Tools :

Pandas

Frequently bought together

Mastering pandas

Oct 2019 674 pages

eBook

$24.99 ~~$35.99~~

Python Machine Learning

Dec 2019 772 pages

4.5 (41)

eBook

$29.99 ~~$43.99~~

Hands-On Data Analysis with Pandas

Jul 2019 740 pages

4.7 (11)

eBook

$24.99 ~~$35.99~~

Total $ 152.97

$48.99

$54.99

$48.99

Total $ 152.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

$24.99 ~~$36.99~~

Unlocking Data with Generative AI and RAG

Sep 2024 346 pages

eBook

$21.99 ~~$31.99~~

Building LLM Powered Applications

May 2024 342 pages

4.2 (22)

eBook

$27.98 ~~$39.99~~

Python for Algorithmic Trading Cookbook

Aug 2024 404 pages

4.6 (15)

eBook

$32.99 ~~$47.99~~

Machine Learning with PyTorch and Scikit-Learn

Feb 2022 774 pages

4.4 (95)

eBook

$29.99 ~~$43.99~~

Artificial Intelligence Engines

Nov 2024 217 pages

eBook

$6.98 ~~$9.99~~

AI Product Manager's Handbook

Nov 2024 484 pages

eBook

$27.98 ~~$39.99~~

RAG-Driven Generative AI

Sep 2024 334 pages

4.5 (13)

eBook

$24.99 ~~$35.99~~

Hands-On Reinforcement Learning with Python

Jun 2018 318 pages

2.6 (18)

eBook

$20.98 ~~$29.99~~

LLM Engineer's Handbook

Oct 2024 522 pages

4.9 (15)

eBook

$47.99

People who bought this also bought

Machine Learning Engineering with Python

Aug 2023 462 pages

4.6 (36)

eBook

$27.98 ~~$39.99~~

Deep Learning with TensorFlow and Keras – 3rd edition

Oct 2022 698 pages

4.6 (45)

eBook

$27.98 ~~$39.99~~

Modern Generative AI with ChatGPT and OpenAI Models

May 2023 286 pages

4.2 (34)

eBook

$27.98 ~~$39.99~~

Generative AI with LangChain

Dec 2023 368 pages

4 (34)

eBook

$27.98 ~~$39.99~~

Causal Inference and Discovery in Python

May 2023 456 pages

4.5 (49)

eBook

$21.99 ~~$31.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

What is included in a Packt subscription?

A subscription provides you with full access to view all Packt and licnesed content online, this includes exclusive access to Early Access titles. Depending on the tier chosen you can also earn credits and discounts to use for owning content

How can I cancel my subscription?

To cancel your subscription with us simply go to the account page - found in the top right of the page or at https://subscription.packtpub.com/my-account/subscription - From here you will see the ‘cancel subscription’ button in the grey box with your subscription information in.

What are credits?

Credits can be earned from reading 40 section of any title within the payment cycle - a month starting from the day of subscription payment. You also earn a Credit every month if you subscribe to our annual or 18 month plans. Credits can be used to buy books DRM free, the same way that you would pay for a book. Your credits can be found in the subscription homepage - subscription.packtpub.com - clicking on ‘the my’ library dropdown and selecting ‘credits’.

What happens if an Early Access Course is cancelled?

Projects are rarely cancelled, but sometimes it's unavoidable. If an Early Access course is cancelled or excessively delayed, you can exchange your purchase for another course. For further details, please contact us here.

Where can I send feedback about an Early Access title?

If you have any feedback about the product you're reading, or Early Access in general, then please fill out a contact form here and we'll make sure the feedback gets to the right team.

Can I download the code files for Early Access titles?

We try to ensure that all books in Early Access have code available to use, download, and fork on GitHub. This helps us be more agile in the development of the book, and helps keep the often changing code base of new versions and new technologies as up to date as possible. Unfortunately, however, there will be rare cases when it is not possible for us to have downloadable code samples available until publication.

When we publish the book, the code files will also be available to download from the Packt website.

How accurate is the publication date?

The publication date is as accurate as we can be at any point in the project. Unfortunately, delays can happen. Often those delays are out of our control, such as changes to the technology code base or delays in the tech release. We do our best to give you an accurate estimate of the publication date at any given time, and as more chapters are delivered, the more accurate the delivery date will become.

How will I know when new chapters are ready?

We'll let you know every time there has been an update to a course that you've bought in Early Access. You'll get an email to let you know there has been a new chapter, or a change to a previous chapter. The new chapters are automatically added to your account, so you can also check back there any time you're ready and download or read them online.

I am a Packt subscriber, do I get Early Access?

Yes, all Early Access content is fully available through your subscription. You will need to have a paid for or active trial subscription in order to access all titles.

How is Early Access delivered?

Early Access is currently only available as a PDF or through our online reader. As we make changes or add new chapters, the files in your Packt account will be updated so you can download them again or view them online immediately.

How do I buy Early Access content?

Early Access is a way of us getting our content to you quicker, but the method of buying the Early Access course is still the same. Just find the course you want to buy, go through the check-out steps, and you’ll get a confirmation email from us with information and a link to the relevant Early Access courses.

What is Early Access?

Keeping up to date with the latest technology is difficult; new versions, new frameworks, new techniques. This feature gives you a head-start to our content, as it's being created. With Early Access you'll receive each chapter as it's written, and get regular updates throughout the product's development, as well as the final course as soon as it's ready.We created Early Access as a means of giving you the information you need, as soon as it's available. As we go through the process of developing a course, 99% of it can be ready but we can't publish until that last 1% falls in to place. Early Access helps to unlock the potential of our content early, to help you start your learning when you need it most. You not only get access to every chapter as it's delivered, edited, and updated, but you'll also get the finalized, DRM-free product to download in any format you want when it's published. As a member of Packt, you'll also be eligible for our exclusive offers, including a free course every day, and discounts on new and popular titles.

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

What do you get with a Packt Subscription?