A Grammar of Data Manipulation


[Up] [Top]

Documentation for package ‘dplyr’ version 1.1.4

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 the observations in each group
add_tally Count the observations in each 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 Order rows using column values
arrange.data.frame Order rows using column values
auto_copy Copy tables to same source, if necessary

-- B --

band_instruments Band membership
band_instruments2 Band membership
band_members Band membership
between Detect where values fall in a specified range
bind Bind multiple data frames by row
bind_cols Bind multiple data frames by column
bind_rows Bind multiple data frames by row

-- C --

case_match A general vectorised 'switch()'
case_when A general vectorised if-else
closest Join specifications
coalesce Find the 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
consecutive_id Generate a unique identifier for consecutive combinations
context Information about the "current" group or variable
copy_to Copy a local data frame to a remote src
count Count the observations in each group
count.data.frame Count the observations in each group
cross_join Cross join
cumall Cumulativate versions of any, all, and mean
cumany Cumulativate versions of any, all, and mean
cume_dist Proportional ranking functions
cummean Cumulativate versions of any, all, and mean
cur_column Information about the "current" group or variable
cur_group Information about the "current" group or variable
cur_group_id Information about the "current" group or variable
cur_group_rows Information about the "current" group or variable
c_across Combine values from multiple columns

-- D --

dense_rank Integer ranking functions
desc Descending order
distinct Keep distinct/unique rows
dplyr_by Per-operation grouping with '.by'/'by'

-- E --

explain Explain details of a tbl

-- F --

filter Keep rows that match a condition
filter-joins Filtering joins
first Extract the first, last, or nth value from a vector
full_join Mutating joins
full_join.data.frame Mutating joins

-- G --

glimpse Get a glimpse of your data
group_by Group by one or more variables
group_cols Select grouping variables
group_map Apply a function to each group
group_modify Apply a function to each group
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-else
inner_join Mutating joins
inner_join.data.frame Mutating joins
intersect Set operations
is.tbl Create a table from a data source

-- J --

join Mutating joins
join.data.frame Mutating joins
join_by Join specifications

-- 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 Integer ranking functions
mutate Create, modify, and delete columns
mutate-joins Mutating joins
mutate.data.frame Create, modify, and delete columns

-- N --

n Information about the "current" group or variable
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 Bucket a numeric vector into 'n' groups
n_distinct Count unique combinations

-- O --

order_by A helper function for ordering window function output
overlaps Join specifications

-- P --

percent_rank Proportional ranking functions
pick Select a subset of columns
pull Extract a single column

-- R --

recode Recode values
recode_factor Recode values
reframe Transform each group to an arbitrary number of rows
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_append 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 Integer ranking functions

-- S --

scoped Operate on a selection of variables
select Keep or drop columns using their names and types
semi_join Filtering joins
semi_join.data.frame Filtering joins
setdiff Set operations
setequal Set operations
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 down to one row
summarize Summarise each group down to one row
symdiff Set operations

-- T --

tally Count the observations in each group
tbl Create a table from a data source

-- U --

ungroup Group by one or more variables
union Set operations
union_all Set operations

-- V --

vars Select variables

-- W --

within Join specifications