Advanced R 4 Data Programming and the Cloud: Using PostgreSQL, AWS, and Shiny

Table of Contents
About the Authors
About the Technical Reviewer
Acknowledgments
Chapter 1: Programming Basics
	1.1 Software Choices and Reproducibility
	1.2 Reproducing Results
	1.3 Types of Objects
	1.4 Base Operators and Functions
	1.5 Mathematical Operators and Functions
	1.6 Summary
Chapter 2: Programming Utilities
	2.1 Installing and Using Packages
	2.2 Help and Documentation
	2.3 System and Files
	2.4 Input
	2.5 Output
	2.6 Summary
Chapter 3: Programming Automation
	3.1 Loops
	3.2 Flow Control
	3.3 apply Family of Functions
	3.4 Summary
Chapter 4: Writing Functions
	4.1 Components of a Function
	4.2 Scoping
	4.3 Functions for Functions
	4.4 Debugging
	4.5 Summary
Chapter 5: Writing Classes and Methods
	5.1 S3 System
		S3 Classes
		S3 Methods
	5.2 S4 System
		S4 Classes
		S4 Class Inheritance
		S4 Methods
	5.3 Summary
Chapter 6: Writing Packages
	6.1 Before You Get Started
		Version Control
	6.2 R Package Basics
		Starting a Package by Using DevTools
		Adding R Code
		Tests
	6.3 Documentation Using roxygen2
		Functions
		Data
		Classes
		Methods
	6.4 Building, Installing, and Distributing an R Package
	6.5 R Package Website
	6.6 Summary
Chapter 7: Introduction to data.table
	7.1 Introduction to data.table
	7.2 Selecting and Subsetting Data
		Using the First Formal
		Using the Second Formal
		Using the Second and Third Formals
	7.3 Variable Renaming and Ordering
	7.4 Creating Variables
	7.5 Merging and Reshaping Data
		Merging Data
		Reshaping Data
	7.6 Summary
Chapter 8: Advanced data.table
	8.1 Data Munging/Cleaning
		Recoding Data
		Recoding Numeric Values
	8.2 Creating New Variables
	8.3 Fuzzy Matching
	8.4 Summary
Chapter 9: Other Data Management Packages
	9.1 Sorting
	9.2 Selecting and Subsetting
	9.3 Variable Renaming and Ordering
	9.4 Computing on Data and Creating Variables
	9.5 Merging and Reshaping Data
	9.6 Summary
Chapter 10: Reading Big Data
	10.1 Installing PostgreSQL on Windows
	10.2 Interfacing R and PostgreSQL
	10.3 Database Philosophy
	10.4 Adding Data to PostgreSQL
	10.5 Creating Users with Specific Privilege
	10.6 Password Security
	10.7 SQL from R
	10.8 Summary
Chapter 11: Getting Your Cloud
	11.1 Disclaimers
	11.2 Starting Amazon Web Services
	11.3 Launching an EC2 Instance
	11.4 Accessing Your Instance’s Command Line
	11.5 Uploading Files to Your Instance
	11.6 Summary
Chapter 12: Cloud Ubuntu for Windows Users
	12.1 Getting Started
	12.2 Common Commands
	12.3 Super User and Security
	12.4 Installing and Using R
		Using R
	12.5 Installing and Using RStudio Server
	12.6 Installing Java
	12.7 Installing Shiny on Your Cloud
	12.8 PostgreSQL
	12.9 Summary
Chapter 13: Every Cloud Has a Shiny Lining
	13.1 The Basics of Shiny
	13.2 Shiny in Motion
	13.3 Uploading a User File into Shiny
	13.4 Hosting Shiny in the Cloud
	13.5 Summary
Chapter 14: Shiny Dashboard Sampler
	14.1 A Dashboard’s Bones
		Dashboard Header
		Dashboard Sidebar
		Dashboard Body
	14.2 Dashboard in the Cloud
	14.3 Complete Sampler Code
	14.4 Summary
Chapter 15: Dynamic Reports
	15.1 Needed Software
		Local Machine
			LaTeX Product
		Cloud Instance
	15.2 Dynamic Documents
	15.3 Dynamic Documents and Shiny
		server.R
		ui.R
		report.Rmd
	15.4 Uploading to the Cloud
	15.5 Summary
Bibliography
Index