Book Image

The Data Analysis Workshop

By : Gururajan Govindan, Shubhangi Hora, Konstantin Palagachev
Book Image

The Data Analysis Workshop

By: Gururajan Govindan, Shubhangi Hora, Konstantin Palagachev

Overview of this book

Businesses today operate online and generate data almost continuously. While not all data in its raw form may seem useful, if processed and analyzed correctly, it can provide you with valuable hidden insights. The Data Analysis Workshop will help you learn how to discover these hidden patterns in your data, to analyze them, and leverage the results to help transform your business. The book begins by taking you through the use case of a bike rental shop. You'll be shown how to correlate data, plot histograms, and analyze temporal features. As you progress, you’ll learn how to plot data for a hydraulic system using the Seaborn and Matplotlib libraries, and explore a variety of use cases that show you how to join and merge databases, prepare data for analysis, and handle imbalanced data. By the end of the book, you'll have learned different data analysis techniques, including hypothesis testing, correlation, and null-value imputation, and will have become a confident data analyst.

Related Content you might be interested in

Current Title:

Small book image
The Data Analysis Workshop
Gururajan Govindan | Shubhangi Hora | Konstantin Palagachev
Jul, 2020 | 626 pages
Small book image
The Supervised Learning Workshop
Blaine Bateman | Benjamin Johnston | Ishita Mathur | Ashish Ranjan Jha
Feb, 2020 | 532 pages
Small book image
Exploratory Data Analysis with Python Cookbook
Ayodele Oluleye
Jun, 2023 | 382 pages
Small book image
Data Science for Marketing Analytics
Pranshu Bhatnagar | Tommy Blanchard | Debasish Behera
Mar, 2019 | 420 pages
Table of Contents (12 chapters)
Preface
About the Book
1
1. Bike Sharing Analysis
1. Bike Sharing Analysis
Introduction
Understanding the Data
Data Preprocessing
Hypothesis Tests
Analysis of Weather-Related Features
Time Series Analysis
ARIMA Models
Summary
Free Chapter
2
2. Absenteeism at Work
2. Absenteeism at Work
Introduction
Initial Data Analysis
Initial Analysis of the Reason for Absence
Analysis of Social Drinkers and Smokers
Body Mass Index
Age and Education Factors
Transportation Costs and Distance to Work Factors
Temporal Factors
Summary
3
3. Analyzing Bank Marketing Campaign Data
3. Analyzing Bank Marketing Campaign Data
Introduction
Initial Data Analysis
Impact of Numerical Features on the Outcome
Modeling the Relationship via Logistic Regression
Linear Regression
Logistic Regression
Summary
4
4. Tackling Company Bankruptcy
4. Tackling Company Bankruptcy
Introduction
Missing Value Analysis
Imputation of Missing Values
Splitting the Features
Feature Selection with Lasso
Summary
5
5. Analyzing the Online Shopper's Purchasing Intention
5. Analyzing the Online Shopper's Purchasing Intention
Introduction
Importing the Data
Exploratory Data Analysis
Clustering
Summary
6
6. Analysis of Credit Card Defaulters
6. Analysis of Credit Card Defaulters
Introduction
Importing the Data
Data Preprocessing
Exploratory Data Analysis
Correlation
Building a Profile of a High-Risk Customer
Summary
7
7. Analyzing the Heart Disease Dataset
7. Analyzing the Heart Disease Dataset
Introduction
Summary
8
8. Analyzing Online Retail II Dataset
8. Analyzing Online Retail II Dataset
Introduction
Data Cleaning
Data Preparation and Feature Engineering
Data Analysis
Summary
9
9. Analysis of the Energy Consumed by Appliances
9. Analysis of the Energy Consumed by Appliances
Introduction
Summary
10
10. Analyzing Air Quality
10. Analyzing Air Quality
Introduction
About the Dataset
Outliers
Missing Values
Heatmaps
Summary
Appendix
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

Data Preprocessing

Before proceeding onto univariate analysis, let's look at the unique values in the columns. The motive behind looking at the unique values in a column is to identify the subcategory in each column. By knowing the subcategory in each column, we would be in a position to understand which subcategory has a higher count or vice versa. For example, let's take the EDUCATION column. We are interested in finding what the different subcategories in the EDUCATION column are and which subcategory has the higher count; that is, do our customers have their highest education as College or University?

This step acts as a precursor before we build a profile of our customers.

Let's now find unique values in the SEX column.

We'll print the unique values in the SEX column and sort them in ascending order:

print('SEX ' + str(sorted(df['SEX'].unique())))

The output will be as follows:

SEX [1, 2]

The following code prints...

Previous Section
End of Section 4
Next Section