%notin% |
notin operator |
across. |
Apply a function across a selection of columns |
anti_join. |
Join two data.tables together |
arrange. |
Arrange/reorder rows |
arrange_across. |
Arrange by a selection of variables |
as_tidytable |
Coerce an object to a data.table/tidytable |
between. |
Do the values from x fall between the left and right bounds? |
bind_cols. |
Bind data.tables by row and column |
bind_rows. |
Bind data.tables by row and column |
case. |
data.table::fcase() with vectorized default |
case_when. |
Case when |
coalesce. |
Coalesce missing values |
complete. |
Complete a data.table with missing combinations of data |
count. |
Count observations by group |
crossing. |
Create a data.table from all unique combinations of inputs |
c_across. |
Combine values from multiple columns |
desc. |
Descending order |
distinct. |
Select distinct/unique rows |
drop_na. |
Drop rows containing missing values |
dt |
Pipeable data.table call |
expand. |
Expand a data.table to use all combinations of values |
expand_grid. |
Create a data.table from all combinations of inputs |
extract. |
Extract a character column into multiple columns using regex |
fill. |
Fill in missing values with previous or next value |
filter. |
Filter rows on one or more conditions |
full_join. |
Join two data.tables together |
get_dummies. |
Convert character and factor columns to dummy variables |
group_split. |
Split data frame by groups |
ifelse. |
Fast ifelse |
if_all. |
Create conditions on a selection of columns |
if_any. |
Create conditions on a selection of columns |
inner_join. |
Join two data.tables together |
inv_gc |
Run invisible garbage collection |
is_tidytable |
Test if the object is a tidytable |
lags. |
Get lagging or leading values |
leads. |
Get lagging or leading values |
left_join. |
Join two data.tables together |
map. |
Apply a function to each element of a vector or list |
map2. |
Apply a function to each element of a vector or list |
map2_chr. |
Apply a function to each element of a vector or list |
map2_dbl. |
Apply a function to each element of a vector or list |
map2_df. |
Apply a function to each element of a vector or list |
map2_dfc. |
Apply a function to each element of a vector or list |
map2_dfr. |
Apply a function to each element of a vector or list |
map2_int. |
Apply a function to each element of a vector or list |
map2_lgl. |
Apply a function to each element of a vector or list |
map_chr. |
Apply a function to each element of a vector or list |
map_dbl. |
Apply a function to each element of a vector or list |
map_df. |
Apply a function to each element of a vector or list |
map_dfc. |
Apply a function to each element of a vector or list |
map_dfr. |
Apply a function to each element of a vector or list |
map_int. |
Apply a function to each element of a vector or list |
map_lgl. |
Apply a function to each element of a vector or list |
mutate. |
Add/modify/delete columns |
mutate_across. |
Mutate multiple columns simultaneously |
mutate_rowwise. |
Add/modify columns by row |
n. |
Number of observations in each group |
nest. |
Nest data.tables |
nest_by. |
Nest data.tables |
pivot_longer. |
Pivot data from wide to long |
pivot_wider. |
Pivot data from long to wide |
pull. |
Pull out a single variable |
relocate. |
Relocate a column to a new position |
rename. |
Rename variables by name |
rename_with. |
Rename multiple columns |
replace_na. |
Replace missing values |
right_join. |
Join two data.tables together |
row_number. |
Return row number |
select. |
Select or drop columns |
semi_join. |
Join two data.tables together |
separate. |
Separate a character column into multiple columns |
separate_rows. |
Separate a collapsed column into multiple rows |
slice. |
Choose rows in a data.table |
slice_head. |
Choose rows in a data.table |
slice_max. |
Choose rows in a data.table |
slice_min. |
Choose rows in a data.table |
slice_sample. |
Choose rows in a data.table |
slice_tail. |
Choose rows in a data.table |
summarise. |
Aggregate data using summary statistics |
summarise_across. |
Summarize multiple columns |
summarize. |
Aggregate data using summary statistics |
summarize_across. |
Summarize multiple columns |
tidytable |
Build a data.table/tidytable |
top_n. |
Select top (or bottom) n rows (by value) |
transmute. |
Add new variables and drop all others |
uncount. |
Uncount a data.table |
unite. |
Unite multiple columns by pasting strings together |
unnest. |
Unnest a nested data.table |
walk. |
Apply a function to each element of a vector or list |