Tidy Interface to 'data.table'


[Up] [Top]

Documentation for package ‘tidytable’ version 0.5.3

Help Pages

A B C D E F G I L M N P R S T U W misc

-- A --

anti_join. Join two data.tables together
any_of. Select helpers
arrange. Arrange/reorder rows by variables
as_dt Coerce an object to a data.table/tidytable
as_tidytable Coerce an object to a data.table/tidytable

-- B --

bind_cols. Bind data.tables by row and column
bind_rows. Bind data.tables by row and column

-- C --

case. Case when
complete. Complete a data.table with missing combinations of data
contains. Select helpers
count. Count observations by group
crossing. Create a data.table from all unique combinations of inputs

-- D --

desc. Deprecated
distinct. Select distinct/unique rows
drop_na. Drop rows containing missing values
dt Pipeable data.table call
dt_anti_join Join two data.tables together
dt_any_of Select helpers
dt_arrange Arrange/reorder rows by variables
dt_bind_cols Bind data.tables by row and column
dt_bind_rows Bind data.tables by row and column
dt_case Case when
dt_contains Select helpers
dt_count Count observations by group
dt_distinct Select distinct/unique rows
dt_drop_na Drop rows containing missing values
dt_ends_with Select helpers
dt_everything Select helpers
dt_fill Fill in missing values with previous or next value
dt_filter Filter rows on one or more conditions
dt_full_join Join two data.tables together
dt_get_dummies Convert character and factor columns to dummy variables
dt_group_nest Nest data.tables
dt_group_split Split data frame by groups
dt_ifelse Vectorized if
dt_inner_join Join two data.tables together
dt_left_join Join two data.tables together
dt_map Apply a function to each element of a vector
dt_map2 Apply a function to each element of a vector
dt_map2_chr Apply a function to each element of a vector
dt_map2_dbl Apply a function to each element of a vector
dt_map2_df Apply a function to each element of a vector
dt_map2_dfc Apply a function to each element of a vector
dt_map2_dfr Apply a function to each element of a vector
dt_map2_int Apply a function to each element of a vector
dt_map2_lgl Apply a function to each element of a vector
dt_map_chr Apply a function to each element of a vector
dt_map_dbl Apply a function to each element of a vector
dt_map_df Apply a function to each element of a vector
dt_map_dfc Apply a function to each element of a vector
dt_map_dfr Apply a function to each element of a vector
dt_map_int Apply a function to each element of a vector
dt_map_lgl Apply a function to each element of a vector
dt_mutate Mutate
dt_mutate_across Mutate multiple columns simultaneously
dt_mutate_all Deprecated mutate helpers
dt_mutate_at Deprecated mutate helpers
dt_mutate_if Deprecated mutate helpers
dt_n Number of observations in each group
dt_pivot_longer Pivot data from wide to long
dt_pivot_wider Pivot data from long to wide
dt_pull Pull out a single variable
dt_relocate Relocate a column to a new position
dt_rename Rename variables by name
dt_rename_across Deprecated rename helpers
dt_rename_all Deprecated rename helpers
dt_rename_at Deprecated rename helpers
dt_rename_if Deprecated rename helpers
dt_rename_with Rename multiple columns
dt_replace_na Replace missing values
dt_right_join Join two data.tables together
dt_row_number Return row number
dt_select Select or drop columns
dt_separate Separate a character column into multiple columns
dt_slice Choose rows by position
dt_slice_head Choose rows by position
dt_slice_max Choose rows by position
dt_slice_min Choose rows by position
dt_slice_tail Choose rows by position
dt_starts_with Select helpers
dt_summarise Aggregate data using summary statistics
dt_summarize Aggregate data using summary statistics
dt_top_n Select top (or bottom) n rows (by value)
dt_transmute Add new variables and drop all others
dt_unite Unite multiple columns by pasting strings together
dt_unnest_legacy Unnest a nested data.table

-- E --

ends_with. Select helpers
everything. Select helpers
expand. Expand a data.table to use all combinations of values
expand_grid. Create a data.table from all combinations of inputs

-- F --

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

-- G --

get_dummies. Convert character and factor columns to dummy variables
group_split. Split data frame by groups

-- I --

ifelse. Vectorized if
inner_join. Join two data.tables together
inv_gc Run invisible garbage collection
is_tidytable Test if the object is a tidytable

-- L --

lags. Lead and Lag
leads. Lead and Lag
left_join. Join two data.tables together

-- M --

map. Apply a function to each element of a vector
map2. Apply a function to each element of a vector
map2_chr. Apply a function to each element of a vector
map2_dbl. Apply a function to each element of a vector
map2_df. Apply a function to each element of a vector
map2_dfc. Apply a function to each element of a vector
map2_dfr. Apply a function to each element of a vector
map2_int. Apply a function to each element of a vector
map2_lgl. Apply a function to each element of a vector
map_chr. Apply a function to each element of a vector
map_dbl. Apply a function to each element of a vector
map_df. Apply a function to each element of a vector
map_dfc. Apply a function to each element of a vector
map_dfr. Apply a function to each element of a vector
map_int. Apply a function to each element of a vector
map_lgl. Apply a function to each element of a vector
mutate. Mutate
mutate_across. Mutate multiple columns simultaneously
mutate_all. Deprecated mutate helpers
mutate_at. Deprecated mutate helpers
mutate_if. Deprecated mutate helpers

-- N --

n. Number of observations in each group
nest_by. Nest data.tables

-- P --

pivot_longer. Pivot data from wide to long
pivot_wider. Pivot data from long to wide
pull. Pull out a single variable

-- R --

relocate. Relocate a column to a new position
rename. Rename variables by name
rename_across. Deprecated rename helpers
rename_all. Deprecated rename helpers
rename_at. Deprecated rename helpers
rename_if. Deprecated rename helpers
rename_with. Rename multiple columns
replace_na. Replace missing values
right_join. Join two data.tables together
row_number. Return row number

-- S --

select. Select or drop columns
separate. Separate a character column into multiple columns
separate_rows. Separate a collapsed column into multiple rows
slice. Choose rows by position
slice_head. Choose rows by position
slice_max. Choose rows by position
slice_min. Choose rows by position
slice_tail. Choose rows by position
starts_with. Select helpers
summarise. Aggregate data using summary statistics
summarise_across. Summarize multiple columns
summarize. Aggregate data using summary statistics
summarize_across. Summarize multiple columns

-- T --

tidytable Build a data.table/tidytable
top_n. Select top (or bottom) n rows (by value)
transmute. Add new variables and drop all others

-- U --

uncount. Uncount a data.table
unite. Unite multiple columns by pasting strings together
unnest. Unnest a nested data.table

-- W --

walk. Apply a function to each element of a vector
where Select variables with a function

-- misc --

%notin% notin operator