dplyr (version 0.1.1)

manip: Data manipulation functions.

Description

These five functions form the backbone of dplyr. They are all S3 generic functions with methods for each individual data type. All functions work exactly the same way: the first argument is the tbl, and the subsequence arguments are interpreted in the context of that tbl.

Usage

filter(.data, ...)
summarise(.data, ...)
mutate(.data, ...)
arrange(.data, ...)
select(.data, ...)

Arguments

.data

a tbl

...

variables interpreted in the context of that data frame.

Manipulation functions

The five key data manipulation functions are:

• filter: return only a subset of the rows. If multiple conditions are supplied they are combined with &.
• select: return only a subset of the columns. If multiple columns are supplied they are all used.
• arrange: reorder the rows. Multiple inputs are ordered from left-to- right.
• mutate: add new columns. Multiple inputs create multiple columns.
• summarise: reduce each group to a single row. Multiple inputs create multiple output summaries.

These are all made significantly more useful when applied by group, as with group_by

Tbls

dplyr comes with three built-in tbls. Read the help for the manip methods of that class to get more details:

• data.frame: manip_df
• data.table: manip_dt
• SQLite: src_sqlite
• PostgreSQL: src_postgres
• MySQL: src_mysql

Output

Generally, manipulation functions will return an output object of the same type as their input. The exceptions are:

• summarise will return an ungrouped source
• remote sources (like databases) will typically return a local source from at least summarise and mutate

Examples

filter(mtcars, cyl == 8)
select(mtcars, mpg, cyl, hp:vs)
arrange(mtcars, cyl, disp)
mutate(mtcars, displ_l = disp / 61.0237)
summarise(mtcars, mean(disp))
summarise(group_by(mtcars, cyl), mean(disp))