Atrebas created this extremely helpful overview page showing how to program standard data manipulation and data transformation routines in R’s famous packages dplyr and data.table.

The document has been been inspired by this stackoverflow question and by the data.table cheat sheet published by Karlijn Willems.

Resources for data.table can be found on the data.table wiki, in the data.table vignettes, and in the package documentation. Reference documents for dplyr include the dplyr cheat sheet, the dplyr vignettes, and the package documentation.

Here’s a hyperlinked table of contents:

• Introduction
  • About
  • Update
  • data.table and dplyr
  • Create example data
• Basic operations
  • Filter rows
  • Sort rows
  • Select columns
  • Summarise data
  • Add/update/delete columns
  • by
• Going further
  • Advanced columns manipulation
  • Chain expressions
  • Indexing and Keys
  • set*()modifications
  • Advanced use of by
• Miscellaneous
  • Read / Write data
  • Reshape data
  • Other
• Join/Bind data sets
  • Join
  • More joins
  • Bind
  • Set operations
• Summary