Practical Data Analysis Cookbook

Practical Data Analysis Cookbook

By : Tomasz Drabas

Buy this Book

Practical Data Analysis Cookbook

By: Tomasz Drabas

Buy this Book

Overview of this book

Data analysis is the process of systematically applying statistical and logical techniques to describe and illustrate, condense and recap, and evaluate data. Its importance has been most visible in the sector of information and communication technologies. It is an employee asset in almost all economy sectors. This book provides a rich set of independent recipes that dive into the world of data analytics and modeling using a variety of approaches, tools, and algorithms. You will learn the basics of data handling and modeling, and will build your skills gradually toward more advanced topics such as simulations, raw text processing, social interactions analysis, and more. First, you will learn some easy-to-follow practical techniques on how to read, write, clean, reformat, explore, and understand your data—arguably the most time-consuming (and the most important) tasks for any data scientist. In the second section, different independent recipes delve into intermediate topics such as classification, clustering, predicting, and more. With the help of these easy-to-follow recipes, you will also learn techniques that can easily be expanded to solve other real-life problems such as building recommendation engines or predictive models. In the third section, you will explore more advanced topics: from the field of graph theory through natural language processing, discrete choice modeling to simulations. You will also get to expand your knowledge on identifying fraud origin with the help of a graph, scrape Internet websites, and classify movies based on their reviews. By the end of this book, you will be able to efficiently use the vast array of tools that the Python environment has to offer.

Practical Data Analysis Cookbook

Credits

About the Author

Acknowledgments

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

Preparing the Data

Introduction

Reading and writing CSV/TSV files with Python

Reading and writing JSON files with Python

Reading and writing Excel files with Python

Reading and writing XML files with Python

Retrieving HTML pages with pandas

Storing and retrieving from a relational database

Storing and retrieving from MongoDB

Opening and transforming data with OpenRefine

Exploring the data with Open Refine

Removing duplicates

Using regular expressions and GREL to clean up data

Imputing missing observations

Normalizing and standardizing the features

Binning the observations

Encoding categorical variables

Exploring the Data

Introduction

Producing descriptive statistics

Exploring correlations between features

Visualizing the interactions between features

Producing histograms

Creating multivariate charts

Sampling the data

Splitting the dataset into training, cross-validation, and testing

Classification Techniques

Introduction

Testing and comparing the models

Classifying with Naïve Bayes

Using logistic regression as a universal classifier

Utilizing Support Vector Machines as a classification engine

Classifying calls with decision trees

Predicting subscribers with random tree forests

Employing neural networks to classify calls

Clustering Techniques

Introduction

Assessing the performance of a clustering method

Clustering data with k-means algorithm

Finding an optimal number of clusters for k-means

Discovering clusters with mean shift clustering model

Building fuzzy clustering model with c-means

Using hierarchical model to cluster your data

Finding groups of potential subscribers with DBSCAN and BIRCH algorithms

Reducing Dimensions

Introduction

Creating three-dimensional scatter plots to present principal components

Reducing the dimensions using the kernel version of PCA

Using Principal Component Analysis to find things that matter

Finding the principal components in your data using randomized PCA

Extracting the useful dimensions using Linear Discriminant Analysis

Using various dimension reduction techniques to classify calls using the k-Nearest Neighbors classification model

Regression Methods

Introduction

Identifying and tackling multicollinearity

Building Linear Regression model

Using OLS to forecast how much electricity can be produced

Estimating the output of an electric plant using CART

Employing the kNN model in a regression problem

Applying the Random Forest model to a regression analysis

Gauging the amount of electricity a plant can produce using SVMs

Training a Neural Network to predict the output of a power plant

Time Series Techniques

Introduction

Handling date objects in Python

Understanding time series data

Smoothing and transforming the observations

Filtering the time series data

Removing trend and seasonality

Forecasting the future with ARMA and ARIMA models

Graphs

Introduction

Handling graph objects in Python with NetworkX

Using Gephi to visualize graphs

Identifying people whose credit card details were stolen

Identifying those responsible for stealing the credit cards

Natural Language Processing

Introduction

Reading raw text from the Web

Tokenizing and normalizing text

Identifying parts of speech, handling n-grams, and recognizing named entities

Identifying the topic of an article

Identifying the sentence structure

Classifying movies based on their reviews

Discrete Choice Models

Introduction

Preparing a dataset to estimate discrete choice models

Estimating the well-known Multinomial Logit model

Testing for violations of the Independence from Irrelevant Alternatives

Handling IIA violations with the Nested Logit model

Managing sophisticated substitution patterns with the Mixed Logit model

Simulations

Introduction

Using SimPy to simulate the refueling process of a gas station

Simulating out-of-energy occurrences for an electric car

Determining if a population of sheep is in danger of extinction due to a wolf pack

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Introduction

One of the most common problems in the real world is to predict certain quantities or, in more general terms, find a relationship between a set of independent variables and the dependent one. In this chapter, we will focus on predicting the output of a power plant.

The dataset that we will use in this chapter comes from the U.S. Energy Information Administration. We procured the 2014 data from their website, http://www.eia.gov/electricity/data/eia923/xls/f923_2014.zip.

We will use the data from the EIA923_Schedules_2_3_4_5_M_12_2014_Final_Revision.xlsx file only, sheet Generation and Fuel Data. We will be predicting Net Generation (Megawatt hours). As most of the data is categorical (state or fuel type), we decided to dummy code them.

Ultimately, our dataset holds only a subset of 4,494 records of the whole dataset. We selected only the power plants with an output greater than 100 MWh in 2014 that were located in a handful of selected states. We also only selected plants that use...

Practical Data Analysis Cookbook

By : Tomasz Drabas

Practical Data Analysis Cookbook

By: Tomasz Drabas

Overview of this book

Related Content you might be interested in

Current Title:

Practical Data Analysis Cookbook

Introduction