# A Grammar of Data Manipulation

## Documentation for package ‘dplyr’ version 0.5.0

- DESCRIPTION file.
- User guides, package vignettes and other documentation.

## Help Pages

A B C D E F G I J L M N O P R S T U V

dplyr-package | dplyr: a grammar of data manipulation

## -- A --

add_rownames | Convert row names to an explicit variable.
all.equal.tbl_df | Flexible equality comparison for data frames.
all_equal | Flexible equality comparison for data frames.
anti_join | Join two tbls together.
anti_join.tbl_df | Join data frame tbls.
anti_join.tbl_lazy | Join sql tbls.
arrange | Arrange rows by variables.
arrange_ | Arrange rows by variables.
as.data.frame.tbl_cube | Coerce a 'tbl_cube' to other data structures
as.table.tbl_cube | Coerce a 'tbl_cube' to other data structures
as.tbl | Create a table from a data source
as.tbl_cube | Coerce an existing data structure into a 'tbl_cube'
as.tbl_cube.array | Coerce an existing data structure into a 'tbl_cube'
as.tbl_cube.data.frame | Coerce an existing data structure into a 'tbl_cube'
as.tbl_cube.matrix | Coerce an existing data structure into a 'tbl_cube'
as.tbl_cube.table | Coerce an existing data structure into a 'tbl_cube'
as_data_frame.tbl_cube | Coerce a 'tbl_cube' to other data structures
auto_copy | Copy tables to same source, if necessary.

## -- B --

bench_compare | Evaluate, compare, benchmark operations of a set of srcs.
bench_tbls | Evaluate, compare, benchmark operations of a set of srcs.
between | Do values in a numeric vector fall in specified range?
bind | Efficiently bind multiple data frames by row and column.
bind_cols | Efficiently bind multiple data frames by row and column.
bind_rows | Efficiently bind multiple data frames by row and column.
build_sql | Build a SQL string.

## -- C --

case_when | A general vectorised if.
changes | Print the location in memory of a data frame
coalesce | Find first non-missing element
collapse | Compute a lazy tbl.
collect | Compute a lazy tbl.
combine | Efficiently bind multiple data frames by row and column.
compare_tbls | Evaluate, compare, benchmark operations of a set of srcs.
compute | Compute a lazy tbl.
compute.tbl_sql | Compute a lazy tbl.
contains | Select helpers
copy_to | Copy a local data frame to a remote src.
copy_to.src_sql | Copy a local data frame to a sqlite src.
count | Counts/tally observations by group.
count_ | Counts/tally observations by group.
cumall | Cumulativate versions of any, all, and mean
cumany | Cumulativate versions of any, all, and mean
cume_dist | Windowed rank functions.
cummean | Cumulativate versions of any, all, and mean
current_vars | Select helpers

## -- D --

db_query_fields.DBITestConnection | A set of DBI methods to ease unit testing dplyr with DBI
dense_rank | Windowed rank functions.
desc | Descending order.
distinct | Select distinct/unique rows.
distinct_ | Select distinct/unique rows.
do | Do arbitrary operations on a tbl.
do_ | Do arbitrary operations on a tbl.
do_.tbl_sql | Do arbitrary operations on a tbl.
dplyr | dplyr: a grammar of data manipulation

## -- E --

ends_with | Select helpers
eval_tbls | Evaluate, compare, benchmark operations of a set of srcs.
everything | Select helpers
explain | Explain details of a tbl.

## -- F --

failwith | Fail with specified value.
filter | Return rows with matching conditions.
filter_ | Return rows with matching conditions.
first | Extract the first, last or nth value from a vector.
full_join | Join two tbls together.
full_join.tbl_df | Join data frame tbls.
full_join.tbl_lazy | Join sql tbls.
funs | Create a list of functions calls.
funs_ | Create a list of functions calls.

## -- G --

groups | Get/set the grouping variables for tbl.
group_by | Group a tbl by one or more variables.
group_by_ | Group a tbl by one or more variables.
group_indices | Group id.
group_indices_ | Group id.
group_size | Calculate group sizes.

## -- I --

if_else | Vectorised if.
inner_join | Join two tbls together.
inner_join.tbl_df | Join data frame tbls.
inner_join.tbl_lazy | Join sql tbls.
intersect | Set operations.
is.tbl | Create a table from a data source

## -- J --

join | Join two tbls together.
join.tbl_df | Join data frame tbls.
join.tbl_sql | Join sql tbls.

## -- L --

lag | Lead and lag.
last | Extract the first, last or nth value from a vector.
lead | Lead and lag.
lead-lag | Lead and lag.
left_join | Join two tbls together.
left_join.tbl_df | Join data frame tbls.
left_join.tbl_lazy | Join sql tbls.
location | Print the location in memory of a data frame

## -- M --

matches | Select helpers
memdb_frame | Per-session in-memory SQLite databases.
min_rank | Windowed rank functions.
mutate | Add new variables.
mutate_ | Add new variables.
mutate_all | Summarise and mutate multiple columns.
mutate_at | Summarise and mutate multiple columns.
mutate_each | Summarise and mutate multiple columns.
mutate_each_ | Summarise and mutate multiple columns.
mutate_each_q | Summarise and mutate multiple columns.
mutate_if | Summarise and mutate multiple columns.

## -- N --

n | The number of observations in the current group.
nasa | NASA spatio-temporal data
na_if | Convert values to NA.
near | Compare two numeric vectors.
nth | Extract the first, last or nth value from a vector.
ntile | Windowed rank functions.
num_range | Select helpers
n_distinct | Efficiently count the number of unique values in a set of vector
n_groups | Calculate group sizes.

## -- O --

one_of | Select helpers
order_by | A helper function for ordering window function output.

## -- P --

percent_rank | Windowed rank functions.

## -- R --

ranking | Windowed rank functions.
rbind_all | Efficiently bind multiple data frames by row and column.
rbind_list | Efficiently bind multiple data frames by row and column.
recode | Recode values
recode_factor | Recode values
regroup | Group a tbl by one or more variables.
rename | Select/rename variables by name.
rename_ | Select/rename variables by name.
right_join | Join two tbls together.
right_join.tbl_df | Join data frame tbls.
right_join.tbl_lazy | Join sql tbls.
rowwise | Group input by rows
row_number | Windowed rank functions.

## -- S --

sample | Sample n rows from a table.
sample_frac | Sample n rows from a table.
sample_n | Sample n rows from a table.
select | Select/rename variables by name.
select_ | Select/rename variables by name.
select_helpers | Select helpers
select_if | Select columns using a predicate
semi_join | Join two tbls together.
semi_join.tbl_df | Join data frame tbls.
semi_join.tbl_lazy | Join sql tbls.
setdiff | Set operations.
setequal | Set operations.
setops | Set operations.
show_query | Explain details of a tbl.
slice | Select rows by position.
slice_ | Select rows by position.
sql_escape_ident.DBITestConnection | A set of DBI methods to ease unit testing dplyr with DBI
sql_translate_env.DBITestConnection | A set of DBI methods to ease unit testing dplyr with DBI
src-test | A set of DBI methods to ease unit testing dplyr with DBI
src_memdb | Per-session in-memory SQLite databases.
src_mysql | Connect to mysql/mariadb.
src_postgres | Connect to postgresql.
src_sqlite | Connect to a sqlite database.
src_tbls | List all tbls provided by a source.
starts_with | Select helpers
summarise | Summarise multiple values to a single value.
summarise_ | Summarise multiple values to a single value.
summarise_all | Summarise and mutate multiple columns.
summarise_at | Summarise and mutate multiple columns.
summarise_each | Summarise and mutate multiple columns.
summarise_each_ | Summarise and mutate multiple columns.
summarise_each_q | Summarise and mutate multiple columns.
summarise_if | Summarise and mutate multiple columns.
summarize | Summarise multiple values to a single value.
summarize_ | Summarise multiple values to a single value.
summarize_all | Summarise and mutate multiple columns.
summarize_at | Summarise and mutate multiple columns.
summarize_each | Summarise and mutate multiple columns.
summarize_each_ | Summarise and mutate multiple columns.
summarize_if | Summarise and mutate multiple columns.

## -- T --

tally | Counts/tally observations by group.
tbl | Create a table from a data source
tbl.src_mysql | Connect to mysql/mariadb.
tbl.src_postgres | Connect to postgresql.
tbl.src_sqlite | Connect to a sqlite database.
tbl_cube | A data cube tbl.
tbl_df | Create a data frame tbl.
tbl_vars | List variables provided by a tbl.
top_n | Select top (or bottom) n rows (by value).
translate_sql | Translate an expression to sql.
translate_sql_ | Translate an expression to sql.
transmute | Add new variables.
transmute_ | Add new variables.

## -- U --

ungroup | Get/set the grouping variables for tbl.
union | Set operations.
union_all | Set operations.

## -- V --

vars | Select columns