A Grammar of Data Manipulation

Documentation for package ‘dplyr’ version 1.0.5

Help Pages

-- A --

across	Apply a function (or functions) across multiple columns
add_count	Count observations by group
add_tally	Count observations by group
all_vars	Apply predicate to all variables
anti_join	Filtering joins
anti_join.data.frame	Filtering joins
any_vars	Apply predicate to all variables
arrange	Arrange rows by column values
arrange.data.frame	Arrange rows by column values
arrange_all	Arrange rows by a selection of variables
arrange_at	Arrange rows by a selection of variables
arrange_if	Arrange rows by a selection of variables
auto_copy	Copy tables to same source, if necessary

-- B --

band_instruments	Band membership
band_instruments2	Band membership
band_members	Band membership
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

-- C --

case_when	A general vectorised if
coalesce	Find first non-missing element
collapse	Force computation of a database query
collect	Force computation of a database query
compute	Force computation of a database query
context	Context dependent expressions
copy_to	Copy a local data frame to a remote src
count	Count 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
cur_column	Context dependent expressions
cur_data	Context dependent expressions
cur_data_all	Context dependent expressions
cur_group	Context dependent expressions
cur_group_id	Context dependent expressions
cur_group_rows	Context dependent expressions
c_across	Combine values from multiple columns

-- D --

dense_rank	Windowed rank functions.
desc	Descending order
distinct	Subset distinct/unique rows
distinct_all	Select distinct rows by a selection of variables
distinct_at	Select distinct rows by a selection of variables
distinct_if	Select distinct rows by a selection of variables

-- E --

Explain details of a tbl

-- F --

filter	Subset rows using column values
filter-joins	Filtering joins
filter_all	Filter within a selection of variables
filter_at	Filter within a selection of variables
filter_if	Filter within a selection of variables
first	Extract the first, last or nth value from a vector
full_join	Mutating joins
full_join.data.frame	Mutating joins

-- G --

group_by	Group by one or more variables
group_by_all	Group by a selection of variables
group_by_at	Group by a selection of variables
group_by_if	Group by a selection of variables
group_cols	Select grouping variables
group_map	Apply a function to each group
group_modify	Apply a function to each group
group_split	Split data frame by groups
group_trim	Trim grouping structure
group_walk	Apply a function to each group

-- I --

ident	Flag a character vector as SQL identifiers
if_all	Apply a function (or functions) across multiple columns
if_any	Apply a function (or functions) across multiple columns
if_else	Vectorised if
inner_join	Mutating joins
inner_join.data.frame	Mutating joins
is.tbl	Create a table from a data source

-- J --

join	Mutating joins
join.data.frame	Mutating joins

-- L --

lag	Compute lagged or leading values
last	Extract the first, last or nth value from a vector
lead	Compute lagged or leading values
lead-lag	Compute lagged or leading values
left_join	Mutating joins
left_join.data.frame	Mutating joins

-- M --

min_rank	Windowed rank functions.
mutate	Create, modify, and delete columns
mutate-joins	Mutating joins
mutate.data.frame	Create, modify, and delete columns
mutate_all	Mutate multiple columns
mutate_at	Mutate multiple columns
mutate_if	Mutate multiple columns

-- N --

n	Context dependent expressions
na_if	Convert values to NA
near	Compare two numeric vectors
nest_join	Nest join
nest_join.data.frame	Nest join
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 set of vector

-- O --

A helper function for ordering window function output

-- P --

percent_rank	Windowed rank functions.
pull	Extract a single column

-- R --

-- S --

scoped	Operate on a selection of variables
select	Subset columns using their names and types
semi_join	Filtering joins
semi_join.data.frame	Filtering joins
setops	Set operations
show_query	Explain details of a tbl
slice	Subset rows using their positions
slice_head	Subset rows using their positions
slice_max	Subset rows using their positions
slice_min	Subset rows using their positions
slice_sample	Subset rows using their positions
slice_tail	Subset rows using their positions
sql	SQL escaping.
starwars	Starwars characters
storms	Storm tracks data
summarise	Summarise each group to fewer rows
summarise_all	Summarise multiple columns
summarise_at	Summarise multiple columns
summarise_if	Summarise multiple columns
summarize	Summarise each group to fewer rows
summarize_all	Summarise multiple columns
summarize_at	Summarise multiple columns
summarize_if	Summarise multiple columns

-- T --

tally	Count observations by group
tbl	Create a table from a data source
transmute	Create, modify, and delete columns
transmute_all	Mutate multiple columns
transmute_at	Mutate multiple columns
transmute_if	Mutate multiple columns

-- U --

ungroup	Group by one or more variables
union_all	Set operations

-- V --

vars	Select variables

-- W --

Perform an operation with temporary groups