You can use dplyr syntax on data tables, usually with data table speed, especially if you load dtplyr.