All functions

arrange_dt()

Arrange entries in data.frame

coalesce()

Return first non-missing element

count_dt() add_count_dt()

Count observations by group

distinct_dt()

Select distinct/unique rows in data.frame

dt_count() dt_add_count() dt_top_n()

Additional useful functions

dt_left_join() dt_right_join() dt_inner_join() dt_full_join() dt_semi_join() dt_anti_join()

Join two data.frames by common columns.

dt_mutate() dt_summarize() dt_summarize_all() dt_summarise() dt_summarise_all() dt_select() dt_filter() dt_arrange()

'dplyr'-like interface for data.table.

filter_dt()

Filter entries in data.frame

parse_fst() select_fst() filter_fst()

Parse,inspect and extract `data.table` from `.fst` file

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

Count observations by group

let_if() take_if() take() let() sort_by()

Modify, aggregate, select or filter data.frame/data.table

wider_dt() longer_dt()

Convert data between wide and long forms

maditr

maditr: Pipe-Style Interface for 'data.table'

drop_na_dt() replace_na_dt()

Dump or replace missing values in data.frame

mutate_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

query_if() query()

One-to-one interface for data.table '[' method

rename_dt()

Rename column in data.frame

select_dt()

Select column from data.frame

slice_dt()

Slice rows in data.frame

summarise_dt() summarize_dt() summarise_all_dt() summarize_all_dt()

Summarise columns to single values

top_n_dt() top_frac_dt()

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