Dynamically add column names to data.table when aggregating
I know we can dynamically add column names when creating columns by reference (using :=
), as described e.g. here: Dynamic column names in data.table.
However, I'm looking to dynamically add column names when we aggregate. Can you help with this?
test_dtb <- data.table(a = sample(1:100, 100), b = sample(1:100, 100), id = rep(1:10, 10))
m = "blah"
test_dtb[ , list((m) = mean(b)), by = id]
The error I get is
Error: unexpected '=' in "test_dtb[ , list((m) =
As mentioned in the comments by lukeA, setNames
can be used:
m <- c("blah", "foo")
test_dtb[ , setNames(list(mean(b), median(b)), m), by = id]