A Grammar of Data Manipulation

Documentation for package ‘dplyr’ version 0.4.3

Help Pages

dplyr: a grammar of data manipulation

-- A --

add_rownames	Convert row names to an explicit variable.
all.equal.tbl_df	Provide a useful implementation of all.equal for data.frames.
all.equal.tbl_dt	Provide a useful implementation of all.equal for data.frames.
anti_join	Join two tbls together.
anti_join.data.table	Join data table tbls.
anti_join.tbl_df	Join data frame tbls.
anti_join.tbl_sql	Join sql tbls.
arrange	Arrange rows by variables.
arrange_	Arrange rows by variables.
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	Coerce a list to a data frame.

-- 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 --

chain	Chain together multiple operations.
chain_q	Chain together multiple operations.
changes	Print the location in memory of a data frame
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.
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

-- D --

data_frame	Build a data frame.
data_frame_	Build a data frame.
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 --

eval_tbls	Evaluate, compare, benchmark operations of a set of srcs.
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.
frame_data	Row-wise data_frame creation
full_join	Join two tbls together.
full_join.tbl_df	Join data frame tbls.
funs	Create a list of functions calls.
funs_	Create a list of functions calls.

-- G --

glimpse	Get a glimpse of your data.
grouped_dt	A grouped data table.
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 --

inner_join	Join two tbls together.
inner_join.data.table	Join data table tbls.
inner_join.tbl_df	Join data frame tbls.
inner_join.tbl_sql	Join sql tbls.
intersect	Set operations.
is.grouped_dt	A grouped data table.
is.tbl	Create a table from a data source

-- J --

-- 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.data.table	Join data table tbls.
left_join.tbl_df	Join data frame tbls.
left_join.tbl_sql	Join sql tbls.
location	Print the location in memory of a data frame

-- M --

min_rank	Windowed rank functions.
mutate	Add new variables.
mutate_	Add new variables.
mutate_each	Summarise and mutate multiple columns.
mutate_each_	Summarise and mutate multiple columns.
mutate_each_q	Summarise and mutate multiple columns.

-- N --

n	The number of observations in the current group.
nasa	NASA spatio-temporal data
nth	Extract the first, last or nth value from a vector.
ntile	Windowed rank functions.
n_distinct	Efficiently count the number of unique values in a vector.
n_groups	Calculate group sizes.

-- O --

A helper function for ordering window function output.

-- P --

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.
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.
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.
semi_join	Join two tbls together.
semi_join.data.table	Join data table tbls.
semi_join.tbl_df	Join data frame tbls.
semi_join.tbl_sql	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.
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.
summarise	Summarise multiple values to a single value.
summarise_	Summarise multiple values to a single value.
summarise_each	Summarise and mutate multiple columns.
summarise_each_	Summarise and mutate multiple columns.
summarise_each_q	Summarise and mutate multiple columns.
summarize	Summarise multiple values to a single value.
summarize_	Summarise multiple values to a single value.
summarize_each	Summarise and mutate multiple columns.
summarize_each_	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_dt	Create a data table tbl.
tbl_vars	List variables provided by a tbl.
tibble	Row-wise data_frame creation
top_n	Select top n rows (by value).
translate_sql	Translate an expression to sql.
translate_sql_q	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.

-- misc --

%.%	Chain together multiple operations.
%>%	Chain together multiple operations.
.datatable.aware	Create a data table tbl.