Book Image

Practical Predictive Analytics

By : Ralph Winters
Book Image

Practical Predictive Analytics

By: Ralph Winters

Overview of this book

This is the go-to book for anyone interested in the steps needed to develop predictive analytics solutions with examples from the world of marketing, healthcare, and retail. We'll get started with a brief history of predictive analytics and learn about different roles and functions people play within a predictive analytics project. Then, we will learn about various ways of installing R along with their pros and cons, combined with a step-by-step installation of RStudio, and a description of the best practices for organizing your projects. On completing the installation, we will begin to acquire the skills necessary to input, clean, and prepare your data for modeling. We will learn the six specific steps needed to implement and successfully deploy a predictive model starting from asking the right questions through model development and ending with deploying your predictive model into production. We will learn why collaboration is important and how agile iterative modeling cycles can increase your chances of developing and deploying the best successful model. We will continue your journey in the cloud by extending your skill set by learning about Databricks and SparkR, which allow you to develop predictive models on vast gigabytes of data.
Table of Contents (19 chapters)
Title Page
Credits
About the Author
About the Reviewers
www.PacktPub.com
Customer Feedback
Preface

Creating some global views


Creating global views will also allow us to pass data between different databricks notebooks. These views will be referenced in the next section. Use the %sql magic command as the first line in the databricks notebook to signify that these are SQL statements:

%sql 
CREATE GLOBAL TEMPORARY VIEW df_view AS SELECT * FROM df 

%sql 
CREATE GLOBAL TEMPORARY VIEW test_view AS SELECT * FROM test 

%sql 
CREATE GLOBAL TEMPORARY VIEW out_sd_view AS SELECT * FROM out_sd 

%sql 
CREATE GLOBAL TEMPORARY VIEW sumdf_view AS SELECT * FROM sumdf 

User exercise

After the views have been created, use SQL to read back the counts and verify the totals with the row counts produced for the original dataframes:

%sql
select count(*) from global_temp.df_view  union all
select count(*) from global_temp.test_view union all
select count(*) from global_temp.sumdf_view union all
select count(*) from global_temp.out_sd_view

Cluster analysis

In this section, we will illustrate how to implement a cluster...