## Book description

*Beyond Spreadsheets with R* shows you how to take raw data and transform it for use in computations, tables, graphs, and more. You’ll build on simple programming techniques like loops and conditionals to create your own custom functions. You’ll come away with a toolkit of strategies for analyzing and visualizing data of all sorts using R and RStudio.

**About the Technology**

Spreadsheets are powerful tools for many tasks, but if you need to interpret, interrogate, and present data, they can feel like the wrong tools for the task. That’s when R programming is the way to go. The R programming language provides a comfortable environment to properly handle all types of data. And within the open source RStudio development suite, you have at your fingertips easy-to-use ways to simplify complex manipulations and create reproducible processes for analysis and reporting.

**About the Book**

*With Beyond Spreadsheets with R* you’ll learn how to go from raw data to meaningful insights using R and RStudio. Each carefully crafted chapter covers a unique way to wrangle data, from understanding individual values to interacting with complex collections of data, including data you scrape from the web. You’ll build on simple programming techniques like loops and conditionals to create your own custom functions. You’ll come away with a toolkit of strategies for analyzing and visualizing data of all sorts.

**What's Inside**

- How to start programming with R and RStudio
- Understanding and implementing important R structures and operators
- Installing and working with R packages
- Tidying, refining, and plotting your data

**About the Reader**

If you’re comfortable writing formulas in Excel, you’re ready for this book.

**About the Author**

**Dr Jonathan Carroll** is a data science consultant providing R programming services. He holds a PhD in theoretical physics.

We interviewed Jonathan as a part of our *Six Questions* series. Check it out here.

**Quotes**

*A useful guide to facilitate graduating from spreadsheets to more serious data wrangling with R.*

- John D. Lewis, DDN

*An excellent book to help you understand how stored data can be used.*

- Hilde Van Gysel, Trebol Engineering

*A great introduction to a data science programming language. Makes you want to learn more!*

- Jenice Tom, CVS Health

*Handy to have when your data spreads beyond a spreadsheet.*

- Danil Mironov, Luxoft Poland

## Table of contents

- Titlepage
- Copyright
- preface
- acknowledgments
- about this book
- about the author
- about the cover illustration
- Chapter 1: Introducing data and the R language
- Chapter 2: Getting to know R data types
- Chapter 3: Making new data values
- Chapter 4: Understanding the tools you’ll use: Functions
- Chapter 5: Combining data values
- Chapter 6: Selecting data values
- Chapter 7: Doing things with lots of data
- Chapter 8: Doing things conditionally: Control structures
- Chapter 9: Visualizing data: Plotting
- Chapter 10: Doing more with your data with extensions
- Appendix A: Installing R
- Appendix B: Installing RStudio
- Appendix C: Graphics in base R
- Index
- List of Figures
- List of Tables
- List of Listings

## Product information

- Title: Beyond Spreadsheets with R
- Author(s):
- Release date: January 2019
- Publisher(s): Manning Publications
- ISBN: 9781617294594

## You might also like

book

### Data Mashups in R

How do you use R to import, manage, visualize, and analyze real-world data? With this short, …

book

### Using R and RStudio for Data Management, Statistical Analysis, and Graphics, 2nd Edition

This book covers the aspects of R most often used by statistical analysts. Incorporating the use …

book

### Practical R 4: Applying R to Data Manipulation, Processing and Integration

Get started with an accelerated introduction to the R ecosystem, programming language, and tools including R …

book

### Longitudinal Data and SAS

Working with longitudinal data introduces a unique set of challenges. Once you've mastered the art of …