A Grammar of Data Manipulation


[Up] [Top]

Documentation for package ‘dplyr’ version 0.5.0

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