A Grammar of Data Manipulation


[Up] [Top]

Documentation for package ‘dplyr’ version 1.0.7

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

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