Data Preparation
Merging
Merging Multiple Data Sets
Concatenating
Combining
Pivoting
Removing
Data Transformation
Tidy Data
Removing Duplicates
Mapping
Discretization and Binning
Detecting and Filtering Outliers
Permutation
String Manipulation
More String Methods
Built-in Methods for Manipulation of Strings
Regular Expressions
Data Aggregation
Group By
A Practical Example
Hierarchical Grouping
Group Iteration
Chain of Transformations
Functions on Groups
Advanced Data Aggregation

Introduction
Aggregate
Transform
Filter
The pandas.core.groupby .DataFrameGroupBy Object
Working With a MultiIndex

Introduction
Python’s datetime Object
Converting to datetime
Loading Data That Include Dates
Extracting Date Components
Date Calculations and Timedeltas
Datetime Methods
Subsetting Data Based on Dates
Date Ranges
Shifting Values
Resampling

The matplotlib Library
Installation
matplotlib Architecture
Backend Layer
Artist Layer
Scripting Layer (pyplot)
pyplot
Line chart
Scatter plot
Annotations: Add Text
Annotations: Properties
A Simple Interactive Chart
Set the Properties of the Plot
Working with Multiple Figures and Axes
Adding Further Elements to the Chart
Adding Text
Adding a Legend
Legends: Properties
Saving Your Charts
Saving the Code
Saving Your Chart Directly as an Image
Line Chart
Line Charts with pandas
Histogram

Means: The Lure of Averages
The Average in Python: mean()
Medians: Caught in the Middle
The Median in Python: median()
Statistics à la Mode
The Mode in Python
Deviating from the Average
Measuring Variation
Back to the Roots: Standard Deviation
Standard Deviation in Python
Conditions, Conditions, Conditions …
Meeting Standards and Standings
Catching Some Z's

How Many?
The High and the Low
Living in the Moments
Tuning in the Frequency
Summarizing a Data Frame

Hitting the Curve
Working with Normal Distributions
A Distinguished Member of the Family
Drawing Conclusions from Data

Understanding Sampling Distributions
An EXTREMELY Important Idea: The Central Limit Theorem
Confidence: It Has Its Limits!
Fit to a t

Testing More Than Two
ANOVA in Python
Another Kind of Hypothesis, Another Kind of Test
Getting Trendy
Trend Analysis in Python

Cracking the Combinations
Two-Way ANOVA in Python
Two Kinds of Variables … at Once
After the Analysis

Uses and abuses of machine learning
Machine learning successes
How machines learn
Machine learning in practice
Machine learning with Python

Understanding regression
Simple linear regression
Ordinary least squares estimation
Multiple Linear Regression
Regression: What a Line!
Linear Regression in Python
Juggling Many Relationships at Once: Multiple Regression
exploring and preparing the data
ANOVA: Another Look
Formulae and Linear Models
Model Building
training a model on the data
evaluating model performance
improving model performance
Goodness of Fit with Data—The Perils of Overfitting
Root-Mean-Square Error
Model Simplicity and Goodness of Fit
Assumption checking
Assumption checking using packages
Case studies of Linear Regression
Estimation the quality of wines
Price prediction of real estate
Movie popularity prediction
Retail sales prediction

Understanding logistic regression
The logit model
Generalized Linear Model
Simple logistic regression
Multiple logistic regression
Customer satisfaction analysis with the multiple logistic regression
Multiple logistic regression with categorical data
The Dataset and the Data Dictionary
Data Import in Python
EDD in Python
Outlier Treatment in Python
Missing Value treatment in Python
Variable transformation and Deletion in Python
Dummy variable creation in Python
Automatic dummy variable creation
Formulae and Logistic Models
Model Building
training a model on the data
evaluating model performance
improving model performance
Goodness of Fit with Data—The Perils of Overfitting
Confusion Matrix
Creating Confusion Matrix in Python

Introduction to Time Series Data
Notation for Time Series Data
Peculiarities of Time Series Data
Setting the Frequency
Treatment of missing values
White Noise
Stationarity
Seasonality
Correlation Between Past and Present Values
The Autocorrelation Function (ACF)
The Partial Autocorrelation Function (PACF)
Picking the Correct Model
The Autoregressive (AR) Model
ARMA
ARIMA
Automatic ARIMA

Unsupervised Learning & Clustering: theory
K-Means Clustering: Theory
Example K-Means Clustering in Python
Visualize K-Means Results in Python
Model-based Unsupervised Clustering in Python
How to assess a Clustering Tendency of the dataset
Selecting the number of clusters for unsupervised Clustering methods (K-Means)
Assessing the performance of unsupervised learning (clustering) algorithms
How to compare the performance of different unsupervised clustering algoritms?

A Simple Tree Model
Deciding How to Split Trees
The stopping criteria for controlling tree growth
Tree Entropy and Information Gain
Pros and Cons of Decision Trees
Tree Overfitting
Pruning Trees
Decision Trees for Classification
Conditional Inference Trees
Conditional Inference Tree Classification
Building a decision tree in Python
Model Validation
Model Improvement
Model Interpretation
Ensemble technique
Random Forest Classification
Splitting Data into Test and Train Set in Python
Choose the number of trees
Model Validation
Model Improvement
Model Interpretation
Accuracy of the model
Decision Vs Random Forest