Reference

Overview

table.express table.express-package

Building 'data.table' expressions with data manipulation verbs

Expression Delimiters

Delimiters between expressions and data.tables

start_expr()

Start expression

chain()

Chain

end_expr()

End and evaluate expression

Single-Table Verbs

arrange(<ExprBuilder>) arrange(<data.table>)

Arrange rows

distinct(<ExprBuilder>) distinct(<data.table>)

Rows with distinct combinations of columns

filter(<ExprBuilder>) filter(<data.table>)

Filter rows

group_by(<ExprBuilder>) group_by(<data.table>)

Grouping clauses

mutate(<ExprBuilder>) mutate(<EagerExprBuilder>) mutate(<data.table>)

Add or update columns

order_by()

Order by clause

select(<ExprBuilder>) select(<EagerExprBuilder>) select(<data.table>)

Select clause

summarize(<ExprBuilder>) summarise(<ExprBuilder>) summarize(<EagerExprBuilder>) summarise(<EagerExprBuilder>) summarize(<data.table>) summarise(<data.table>)

Summarize columns

transmute(<ExprBuilder>) transmute(<EagerExprBuilder>) transmute(<data.table>)

Compute new columns

where()

Where clause

filter_sd()

Filter subset of data

mutate_sd()

Mutate subset of data

transmute_sd()

Transmute subset of data

filter_on()

Filter with secondary indices

key_by()

Set key to group by

max_by() min_by()

Find rows with extrema in specific columns

Two-Table Verbs

anti_join(<ExprBuilder>) anti_join(<data.table>) full_join(<ExprBuilder>) full_join(<data.table>) inner_join(<ExprBuilder>) inner_join(<data.table>) left_join(<ExprBuilder>) left_join(<data.table>) mutate_join() right_join(<ExprBuilder>) right_join(<data.table>) semi_join(<ExprBuilder>) semi_join(<data.table>)

Joining verbs

Utilities

frame_append()

Append expressions to the frame

nest_expr()

Nest expressions as a functional chain

R6 Classes

ExprBuilder

Frame expression builder

EagerExprBuilder

Eager frame expression builder