Articles by David Kun

RDBL – manipulate data in-database with R code only

August 29, 2016 | David Kun

In this post I introduce our own package RDBL, the R DataBase Layer. With this package you can manipulate data in-database without writing SQL code. The package interprets the R code and sends out the corresponding SQL statements to the database, fully transparently. To minimize overhead, the data is only ... [Read more...]

Efficient aggregation (and more) using data.table

November 27, 2015 | David Kun

In my recent post I have written about the aggregate function in base R and gave some examples on its use. This post repeats the same examples using data.table instead, the most efficient implementation of the aggregation logic in R, plus some additional use cases showing the power of ...
[Read more...]

Aggregate – A Powerful Tool for Data Frame in R

November 16, 2015 | David Kun

This post gives a short review of the aggregate function as used for data.frames and presents some interesting uses: from the trivial but handy to the most complicated problems I have solved with aggregate. Aggregate (data.frame): Technical Overview Aggregate is a function in base R which can, as ...
[Read more...]

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)