[datatable-help] finding dt columns by partial name
Bacou, Melanie
mel at mbacou.com
Thu Mar 10 21:49:51 CET 2016
Hi Carl,
I'm not 100% sure what you're after, but I'm assuming you're looking for
something like:
dt[, .SD, .SDcols=names(dt) %like% "Call1"]
That's syntax you can use to select all columns of a data.table
containing "Call1".
--Mel.
On 3/10/2016 2:00 PM, carlsutton wrote:
> Hi
>
> I did search but did not see an answer.
>
> I have a dt with 580 + columns. many of the columns will have variations of
> a name to specifically identify them, ie, call23,Call111, doCall.now, etc.
> Since I cannot recall the exact column names I have been resorting to df
> <- data.frame(dt) and then
> a <- grep("Call1", colnames(df))
> colnames(df[a])
>
> which then returns the columns names containing Call1.
>
> If I try this with the data table ie, colnames(dt[a]) I get null.
>
> Any suggestions? I am feeling rather ignorant converting a dt back to a
> data frame and available memory may be a concern further down the road.
>
> Carl Sutton
>
>
>
> -----
> Carl Sutton
> --
> View this message in context: http://r.789695.n4.nabble.com/finding-dt-columns-by-partial-name-tp4718464.html
> Sent from the datatable-help mailing list archive at Nabble.com.
> _______________________________________________
> datatable-help mailing list
> datatable-help at lists.r-forge.r-project.org
> https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help
More information about the datatable-help
mailing list