Data manipulation in R : dplyr Cheat Sheet

A Programming › R cheat sheet in English by shanly3011

14,836 views 5,138 downloads 12 Apr 2015 History

PRs

3.8 avg · 2 ratings

Select

Used to select specific columns from a data set.

To select a column -
Use the ":" sign to select a range of columns
Type in the specific column names to select individually
Use the "-" operator to exclude a column or a range of columns

#Select individal columns
hflights_multiple <- select(hflights, ArrTime,AirTime,TaxiIn)

#Shortcut to select a range of columns
hflights_range <- select(hflights,Year:DayOfWeek,ArrTime:AirTime)

#Exclude a set of columns
hflights_subtract <- select(hflights, -(DayOfWeek:FlightNum)

Helper Functions

To search for column names, instead of typing each one manually or specifying range - we can use helper functions. These functions help us in making our work easier.

Common helper functions
ends_with("A")
starts_with("A")
contains("A")
matches("A")
num_range("A")
one_of("A")

Badges

Good Cheat Sheet Nice Cheat Sheet Downloaded from Unusual Locations × 3

Comments

No comments yet.