Top "Data.table" questions

The R data.

write.csv for large data.table

I have a data.table that is not very big (2 GB) but for some reason write.csv takes an extremely …

r file-io csv dataframe data.table
Understanding exactly when a data.table is a reference to (vs a copy of) another data.table

I'm having a little trouble understanding the pass-by-reference properties of data.table. Some operations seem to 'break' the reference, and …

r reference copy data.table assignment-operator
R data.table apply function to rows using columns as arguments

I have the following data.table x = structure(list(f1 = 1:3, f2 = 3:5), .Names = c("f1", "f2"), row.names = c(NA, -3…

r data.table mapply
Efficient way to rbind data.frames with different columns

I have a list of data frames with different sets of columns. I would like to combine them by rows …

r data.table rbind
How do I select rows by two criteria in data.table in R

Let's say I have a data.table and I want to select all the rows where the variable x has …

r select subset data.table
Apply function on a subset of columns (.SDcols) whilst applying a different function on another column (within groups)

This is very similar to a question applying a common function to multiple columns of a data.table uning .SDcols …

r data.table subset lapply
Efficient alternatives to merge for larger data.frames R

I am looking for an efficient (both computer resource wise and learning/implementation wise) method to merge two larger (size&…

r merge dataframe plyr data.table
Why does X[Y] join of data.tables not allow a full outer join, or a left join?

This is a bit of a philosophical question about data.table join syntax. I am finding more and more uses …

r join data.table
Using .I to return row numbers with data.table package

Would someone please explain to me the correct usage of .I for returning the row numbers of a data.table? …

r data.table
How do I run apply on a data.table?

I have a data.table with columns 2 through 20 as strings with spaces (e.g., "Species Name"). I want to run …

r apply data.table