# A Grammar of Data Manipulation

## Documentation for package ‘dplyr’ version 1.0.1

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

## -- A --

across | Apply a function (or a set of functions) to a set of 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 | Apply a function (or a set of functions) to a set of 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 | 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_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 --

order_by | A helper function for ordering window function output

## -- P --

percent_rank | Windowed rank functions.
pull | Extract a single column

## -- R --

ranking | Windowed rank functions.
recode | Recode values
recode_factor | Recode values
relocate | Change column order
rename | Rename columns
rename_with | Rename columns
right_join | Mutating joins
right_join.data.frame | Mutating joins
rows | Manipulate individual rows
rows_delete | Manipulate individual rows
rows_insert | Manipulate individual rows
rows_patch | Manipulate individual rows
rows_update | Manipulate individual rows
rows_upsert | Manipulate individual rows
rowwise | Group input by rows
row_number | Windowed rank functions.

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

with_groups | Perform an operation with temporary groups