Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

tidytable

Tidy Interface to 'data.table'

A tidy interface to 'data.table' that is 'rlang' compatible, giving users the speed of 'data.table' with the clean syntax of the tidyverse.

Functions (61)

across..html

Apply a function across a selection of columns

arrange..html

Arrange/reorder rows

arrange_across..html

Arrange by a selection of variables

as_tidytable

Coerce an object to a data.table/tidytable

between..html

Do the values from x fall between the left and right bounds?

bind_cols..html

Bind data.tables by row and column

c_across..html

Combine values from multiple columns

case..html

data.table::fcase() with vectorized default

case_when..html

Case when

coalesce..html

Coalesce missing values

complete..html

Complete a data.table with missing combinations of data

count..html

Count observations by group

crossing..html

Create a data.table from all unique combinations of inputs

desc..html

Descending order

distinct..html

Select distinct/unique rows

drop_na..html

Drop rows containing missing values

Pipeable data.table call

expand..html

Expand a data.table to use all combinations of values

expand_grid..html

Create a data.table from all combinations of inputs

extract..html

Extract a character column into multiple columns using regex

fill..html

Fill in missing values with previous or next value

filter..html

Filter rows on one or more conditions

get_dummies..html

Convert character and factor columns to dummy variables

grapes-notin-grapes

notin operator

group_split..html

Split data frame by groups

if_all..html

Create conditions on a selection of columns

ifelse..html

Fast ifelse

inv_gc

Run invisible garbage collection

is_tidytable

Test if the object is a tidytable

lags..html

Get lagging or leading values

left_join..html

Join two data.tables together

map..html

Apply a function to each element of a vector or list

mutate..html

Add/modify/delete columns

mutate_across..html

Mutate multiple columns simultaneously

mutate_rowwise..html

Add/modify columns by row

n..html

Number of observations in each group

nest..html

Nest data.tables

nest_by..html

Nest data.tables

pipe

Pipe operator

pivot_longer..html

Pivot data from wide to long

pivot_wider..html

Pivot data from long to wide

pull..html

Pull out a single variable

reexports

Objects exported from other packages

relocate..html

Relocate a column to a new position

rename..html

Rename variables by name

rename_with..html

Rename multiple columns

replace_na..html

Replace missing values

row_number..html

Return row number

select..html

Select or drop columns

separate..html

Separate a character column into multiple columns

separate_rows..html

Separate a collapsed column into multiple rows

slice..html

Choose rows in a data.table

summarize..html

Aggregate data using summary statistics

summarize_across..html

Summarize multiple columns

tidytable

Build a data.table/tidytable

tidytable-vctrs

Internal vctrs methods

top_n..html

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

transmute..html

Add new variables and drop all others

uncount..html

Uncount a data.table

unite..html

Unite multiple columns by pasting strings together

unnest..html

Unnest a nested data.table

tidytable

Tidy Interface to 'data.table'

v0.6.1

MIT + file LICENSE

Authors

Mark Fairbanks [aut, cre], Abdessabour Moutik [ctb], Matt Carlson [ctb], Ivan Leung [ctb], Ross Kennedy [ctb]

Initial release

tidytable

Functions (61)

tidytable

We don't support your browser anymore