Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
The Data Analysis Workshop

You're reading from  The Data Analysis Workshop

Product type Book
Published in Jul 2020
Publisher Packt
ISBN-13 9781839211386
Pages 626 pages
Edition 1st Edition
Languages
Authors (3):
Gururajan Govindan Gururajan Govindan
Profile icon Gururajan Govindan
Shubhangi Hora Shubhangi Hora
Profile icon Shubhangi Hora
Konstantin Palagachev Konstantin Palagachev
Profile icon Konstantin Palagachev
View More author details

Table of Contents (12) Chapters

Preface
1. Bike Sharing Analysis 2. Absenteeism at Work 3. Analyzing Bank Marketing Campaign Data 4. Tackling Company Bankruptcy 5. Analyzing the Online Shopper's Purchasing Intention 6. Analysis of Credit Card Defaulters 7. Analyzing the Heart Disease Dataset 8. Analyzing Online Retail II Dataset 9. Analysis of the Energy Consumed by Appliances 10. Analyzing Air Quality Appendix

Missing Value Analysis

One of the major steps in data analysis is missing value analysis. The primary reason we need to perform missing value analysis is to know how much data is missing in a column and how we are going to handle it.

In general, missing values can be handled in two ways. The first way is to drop the rows with missing values, unless the percentage of missing values is high (for example, 40% missing values in a column) as this will lead to loss of information.

The second method is imputing missing values, which is where we fill in the missing values based on the imputation method employed. For example, in mean imputation, we use the mean value of the particular column to fill in the missing values.

The next step is missing value analysis.

In order to find out how many missing values are present in the DataFrame, we are going to introduce you to a package called missingno, which will help you visualize the count of missing values in the DataFrames.

Exercise...

lock icon 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
Renews at $15.99/month. Cancel anytime}