R Data Frame Cheat Sheet

R Data Manipulation Cheat Sheet
R Data Frame Cheat Sheet Template
R Studio Code Cheat Sheet
R Cheat Sheets Pdf
R Data Frame Cheat Sheet

Welcome to the R cheat sheet.

Here you’ll find the most useful functions and techniques I’ve found in R all in one place.

Data Wrangling with dplyr and tidyr Cheat Sheet RStudio® is a trademark of RStudio, Inc. CC BY RStudio. info@rstudio.com. 844-448-1212. rstudio.com Syntax - Helpful conventions for wrangling dplyr::tbldf(iris) w Converts data to tbl class. Tbl’s are easier to examine than data frames. R displays only the data that fits onscreen. R Cheat Sheet by deleted via cheatography.com/3687/cs/2469/ Conversion To number as.num ber(x) To boolean (logical) as.log ical(x) To comples number as.com plex.

This post is a work in progress – new functions will be catalogued in here as and when.

This cheat sheet assumes you have RStudio downloaded and set up on your computer.

RStudio has the mtcars dataset pre-loaded. This will be the example dataset for much of the cheat sheet.

Remember that there are often multiple ways with R to arrive at the same result!

I want to:

By function:

Reading data from a spreadsheet up into R

To read data from your CSV file, use the read.csv formula

Seeing the structure of your data

The str function gives you an overview of how your data looks.

Seeing a sample of your data

See the beginning, end or a random bit of your dataset.

Filter your data frame

Filter your data frame based on the data in one column. Thanks to Sharon Machlis for the tips in searching for numbers and strings here.

Merge data from several columns into one column vertically

We can use the gather() function to take data from several horizontal columns and display it vertically, without losing the distinctions in the column names. This is great for moving data spread across several years into a single year, allowing for plotting on geom_line() in ggplot2.

Merge several identical datasets together, one underneath another

Use rbind(). Make sure your data frames have the same number of columns, named identically.

Do a find and replace

Print off a CSV file from a R data frame

It will print off a CSV file into your current directory.

Order your data frame

Make sure you remember the comma at the end or you’ll get an error
the default order is ascending. Put a minus sign in front of column_to_sort to sort descending. Remember this will not plot in order in ggplot2.

To sort your data quickly, an alternative way is to click on your data frame in the ‘data’ section of RStudio.

From there, a new tab will open to the right of your script. Click on that to get a spreadsheet-style visualisation of your data. Click on one of the tabs to sort the data in ascending order, then again to sort descending. Remember – this won’t sort your data permanently.

Remove any duplicate values from your data frame

Remove an object from your environment

#use rm() as follows

to_delete <- data.frame(NA)
rm(to_delete)
#data frame is deleted from the environment

You can also use the grid option in RStudio, in the top-right corner, to select multiple objects for deletion easily

Test to see whether a statement is TRUE or FALSE

Format data as numeric values

Change some data into date format

Use the as.Date() function to turn a character date format into a R date format.

The format argument of as.Date() should detail the format of your date, including any spaces, slashes etc. For details on all possible date formats, go here.

R Data Manipulation Cheat Sheet

Plotly's R graphing library makes interactive, publication-quality graphs. Examples of how to make line plots, scatter plots, area charts, bar charts, error bars, box plots, histograms, heatmaps, subplots, multiple-axes, and 3D (WebGL based) charts.
Plotly.R is free and open source and you can view the source, report issues or contribute on GitHub.

Write, deploy, & scale Dash apps and R data visualization on a Kubernetes Dash Enterprise cluster.
Get Pricing | Demo Dash Enterprise | Dash Enterprise Overview

More Fundamentals »