All functions

arrange_dt()

Arrange entries in data.frame

count_dt() add_count_dt()

Count observations by group

distinct_dt()

Select distinct/unique rows in data.frame

filter_dt()

Filter entries in data.frame

parse_fst() slice_fst() select_fst() filter_fst()

Parse,inspect and extract data.table from fst file

export_fst() import_fst()

Read and write fst files

group_dt()

Data manipulation within groups

left_join_dt() right_join_dt() inner_join_dt() full_join_dt() anti_join_dt() semi_join_dt()

Join table by common keys

lead_dt() lag_dt()

Fast lead/lag for vectors

longer_dt()

Pivot data from wide to long

drop_na_dt() replace_na_dt()

Dump or replace missing values in data.frame

mutate_dt() transmute_dt()

Mutate columns in data.frame

mutate_when()

Conditional update of columns in data.table

nest_dt() unnest_dt()

Nest and unnest

pull_dt()

Pull out a single variable

rename_dt()

Rename column in data.frame

sample_n_dt() sample_frac_dt()

Sample n rows from a table

select_dt()

Select column from data.frame

slice_dt()

Slice rows in data.frame

summarise_dt() summarize_dt()

Summarise columns to single values

top_n_dt() top_frac_dt()

Select top (or bottom) n rows (by value)

wider_dt()

Pivot data from long to wide