Tidy Interface to 'data.table'


[Up] [Top]

Documentation for package ‘tidytable’ version 0.6.1

Help Pages

%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