All functions

percent() add_prop()

Add percentage to counts in data.frame

arrange_dt()

Arrange entries in data.frame

as_fst()

Save a data.frame as a fst table

bind_rows_dt()

Bind multiple data frames by row

col_max() col_min()

Get the column name of the max/min number each row

complete_dt()

Complete a data frame with missing combinations of data

count_dt() add_count_dt()

Count observations by group

cummean()

Cumulative mean

distinct_dt()

Select distinct/unique rows in data.frame

in_dt() as_dt()

Short cut to data.table

dummy_dt()

Fast creation of dummy variables

filter_dt()

Filter entries in data.frame

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

Parse,inspect and extract data.table from fst file

export_fst() import_fst()

Read and write fst files

group_by_dt() group_exe_dt()

Group by variable(s) and implement operations

group_dt() rowwise_dt()

Data manipulation within groups

import_fst_chunked() get_fst_chunk_size()

Read a fst file by chunks

impute_dt()

Impute missing values with mean, median or mode

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

Join tables

lead_dt() lag_dt()

Fast lead/lag for vectors

longer_dt()

Pivot data from wide to long

drop_na_dt() replace_na_dt() delete_na_cols() delete_na_rows() fill_na_dt() shift_fill()

Dump, replace and fill missing values in data.frame

mutate_dt() transmute_dt()

Mutate columns in data.frame

mutate_when() mutate_vars()

Conditional update of columns in data.table

nest_dt() unnest_dt() squeeze_dt() chop_dt() unchop_dt()

Nest and unnest

nth() maxth() minth()

Extract the nth value from a vector

object_size()

Nice printing of report the Space Allocated for an Object

pairwise_count_dt()

Count pairs of items within a group

pkg_load() pkg_unload()

Load or unload R package(s)

print_options()

Set global printing method for data.table

pull_dt()

Pull out a single variable

rec_num() rec_char()

Recode number or strings

relocate_dt()

Change column order

rename_dt() rename_with_dt()

Rename column in data.frame

replace_dt()

Fast value replacement in data frame

round0()

Round a number and make it show zeros

rn_col() col_rn()

Tools for working with row names

sample_dt() sample_n_dt() sample_frac_dt()

Sample rows randomly from a table

select_dt() select_mix()

Select column from data.frame

separate_dt()

Separate a character column into two columns using a regular expression separator

intersect_dt() union_dt() setdiff_dt() setequal_dt()

Set operations for data frames

slice_dt() slice_head_dt() slice_tail_dt() slice_max_dt() slice_min_dt() slice_sample_dt()

Subset rows using their positions

sql_join_dt()

Case insensitive table joining like SQL

summarise_dt() summarize_dt() summarise_when() summarize_when() summarise_vars() summarize_vars()

Summarise columns to single values

sys_time_print() pst()

Convenient print of time taken

mat_df() df_mat()

Conversion between tidy table and named matrix

t_dt()

Efficient transpose of data.frame

uncount_dt()

"Uncount" a data frame

unite_dt()

Unite multiple columns into one by pasting strings together

utf8_encoding()

Use UTF-8 for character encoding in a data frame

wider_dt()

Pivot data from long to wide