Fast Data Aggregation, Modification, and Filtering with Pipes and 'data.table'

Provides pipe-style interface for 'data.table'. Package preserves all 'data.table' features without significant impact on performance. 'let' and 'take' functions are simplified interfaces for most common data manipulation tasks. For example, you can write 'take(mtcars, mean(mpg), by = am)' for aggregation or 'let(mtcars, hp_wt = hp/wt, hp_wt_mpg = hp_wt/mpg)' for modification. Use 'take_if/let_if' for conditional aggregation/modification. Additionally there are some conveniences such as automatic 'data.frame' conversion to 'data.table'.


0.6.1 (2019-01-03)

  • fix tests
  • add 'coalesce' function
  • add 'data.frame' method for 'rollup', 'cube' and 'groupingsets'
  • minor fixes

0.6.0 (2018-08-12)

  • add joins: 'dt_left_join', 'dt_right_join', 'dt_inner_join', 'dt_full_join', 'dt_anti_join', 'dt_semi_join'

0.5.2 (2018-07-18)

  • add 'dcast' and 'melt' methods for data.frame
  • add ':=' operator for 'take'/'take_if'/'summarize' for parametric evaluation

0.5.1 (2018-05-09)

  • fix stupid bug with incorrect minimal version of data.table in DESCRIPTION
  • add 'dplyr'-like interface.

0.5.0 (2018-05-05)

  • initial release

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.


0.8.2 by Gregory Demin, 8 months ago

Report a bug at

Browse source code at

Authors: Gregory Demin [aut, cre]

Documentation:   PDF Manual  

GPL-2 license

Imports data.table, magrittr

Suggests knitr, tinytest, utils, rmarkdown, stats

Imported by citationchaser.

Depended on by expss.

Suggested by fastverse.

See at CRAN