| /dports/devel/R-cran-data.table/data.table/man/ |
| H A D | groupingsets.Rd | 14 \method{rollup}{data.table}(x, j, by, .SDcols, id = FALSE, \dots)
16 \method{cube}{data.table}(x, j, by, .SDcols, id = FALSE, \dots)
18 \method{groupingsets}{data.table}(x, j, by, sets, .SDcols, id = FALSE, jj, \dots)
26 \item{.SDcols}{columns to be used in \code{j} expression in \code{.SD} object.}
56 rollup(DT, j = lapply(.SD, sum), by = c("color","year","status"), id=TRUE, .SDcols="value")
61 cube(DT, j = lapply(.SD, sum), by = c("color","year","status"), id=TRUE, .SDcols="value")
|
| H A D | shift.Rd | 49 DT[, (anscols) := shift(.SD, 1, 0, "lead"), .SDcols=cols]
54 DT[, shift(.SD, 1:2, NA, "lead", TRUE), .SDcols=2:4]
62 DT[order(year), (cols) := shift(.SD, 1, type="lag"), .SDcols=cols]
|
| H A D | data.table.Rd | 31 .SDcols,
144 …SDcols}{ Specifies the columns of \code{x} to be included in the special symbol \code{\link{.SD}} …
146 …ndcol} is also allowed (as in \code{by}), e.g., \code{DT[, lapply(.SD, sum), by=x:y, .SDcols=a:f]}.
148 …ith \code{!} or \code{-} (there's no difference between these), e.g. \code{.SDcols = !c('x', 'y')}.
150 …SDcols=patterns(regex1, regex2, ...)}. The included columns will be the \emph{intersection} of the…
277 DT[, ..colNum] # same, equivalent to DT[, .SD, .SDcols=colNum]
369 DT[, .SD, .SDcols=x:y] # select columns 'x' through 'y'
370 DT[ , .SD, .SDcols = !x:y] # drop columns 'x' through 'y'
371 DT[ , .SD, .SDcols = patterns('^[xv]')] # select columns matching '^x' or '^v'
423 # using rleid, get max(y) and min of all cols in .SDcols for each consecutive run of 'v'
[all …]
|
| H A D | special-symbols.Rd | 44 DT[, .SD, .SDcols=x:y] # select columns 'x' and 'y'
51 by=rleid(v), .SDcols=v:b] # compute 'j' for each consecutive runs of 'v'
|
| H A D | assign.Rd | 116 lapply(.SD, tan), .SDcols = c('b', 'd', 'e')]
120 DT[ , (sq_cols) := lapply(.SD, `^`, 2L), .SDcols = sq_cols]
129 .SDcols = sq_col_idx]
|
| H A D | split.Rd | 51 fdt = DT[, c(lapply(.SD, as.factor), list(y=y)), .SDcols=x1:x3]
|
| /dports/devel/R-cran-data.table/data.table/inst/doc/ |
| H A D | datatable-sd-usage.Rmd | 67 ## Column Subsetting: `.SDcols`
69 …act what `.SD` is is to limit the _columns_ contained in `.SD` using the `.SDcols` argument to `[`:
73 Pitching[ , .SD, .SDcols = c('W', 'L', 'G')]
90 Teams[ , sapply(.SD, is.character), .SDcols = fkt]
106 Teams[ , (fkt) := lapply(.SD, factor), .SDcols = fkt]
118 # while .SDcols accepts a logical vector,
122 Teams[ , (fkt_idx) := lapply(.SD, as.character), .SDcols = fkt_idx]
129 Teams[ , .SD, .SDcols = patterns('team')]
135 Teams[ , (team_idx) := lapply(.SD, factor), .SDcols = team_idx]
168 Pitching[ , coef(lm(ERA ~ ., data = .SD))['W'], .SDcols = c('W', rhs)]
[all …]
|
| H A D | datatable-intro.Rmd | 571 #### .SDcols {.bs-callout .bs-callout-info}
573 Using the argument `.SDcols`. It accepts either column names or column indices. For example, `.SDco…
577 Now let us try to use `.SD` along with `.SDcols` to get the `mean()` of `arr_delay` and `dep_delay`…
583 .SDcols = c("arr_delay", "dep_delay")] ## for just those specified in .SDcols
679 * We can use `.SD` and `.SDcols` in `j` to operate on multiple columns using already familiar base …
681 …1. `DT[, lapply(.SD, fun), by = ..., .SDcols = ...]` - applies `fun` to all columns specified in `…
|
| H A D | datatable-reference-semantics.Rmd | 249 flights[, c(out_cols) := lapply(.SD, max), by = month, .SDcols = in_cols]
254 …s and the new columns to add in separate variables and provide them to `.SDcols` and for `LHS` (fo…
258 …iple columns. In the RHS, to compute the `max` on columns specified in `.SDcols`, we make use of t…
|
| H A D | datatable-faq.Rmd | 154 …ing _several_ but not _all_ of the columns, you can combine `.SD` with `.SDcols`; see `?data.table…
|
| /dports/devel/R-cran-data.table/data.table/vignettes/ |
| H A D | datatable-sd-usage.Rmd | 67 ## Column Subsetting: `.SDcols`
69 …act what `.SD` is is to limit the _columns_ contained in `.SD` using the `.SDcols` argument to `[`:
73 Pitching[ , .SD, .SDcols = c('W', 'L', 'G')]
90 Teams[ , sapply(.SD, is.character), .SDcols = fkt]
106 Teams[ , (fkt) := lapply(.SD, factor), .SDcols = fkt]
118 # while .SDcols accepts a logical vector,
122 Teams[ , (fkt_idx) := lapply(.SD, as.character), .SDcols = fkt_idx]
129 Teams[ , .SD, .SDcols = patterns('team')]
135 Teams[ , (team_idx) := lapply(.SD, factor), .SDcols = team_idx]
168 Pitching[ , coef(lm(ERA ~ ., data = .SD))['W'], .SDcols = c('W', rhs)]
[all …]
|
| H A D | datatable-intro.Rmd | 571 #### .SDcols {.bs-callout .bs-callout-info}
573 Using the argument `.SDcols`. It accepts either column names or column indices. For example, `.SDco…
577 Now let us try to use `.SD` along with `.SDcols` to get the `mean()` of `arr_delay` and `dep_delay`…
583 .SDcols = c("arr_delay", "dep_delay")] ## for just those specified in .SDcols
679 * We can use `.SD` and `.SDcols` in `j` to operate on multiple columns using already familiar base …
681 …1. `DT[, lapply(.SD, fun), by = ..., .SDcols = ...]` - applies `fun` to all columns specified in `…
|
| H A D | datatable-reference-semantics.Rmd | 249 flights[, c(out_cols) := lapply(.SD, max), by = month, .SDcols = in_cols]
254 …s and the new columns to add in separate variables and provide them to `.SDcols` and for `LHS` (fo…
258 …iple columns. In the RHS, to compute the `max` on columns specified in `.SDcols`, we make use of t…
|
| H A D | datatable-faq.Rmd | 154 …ing _several_ but not _all_ of the columns, you can combine `.SD` with `.SDcols`; see `?data.table…
|
| /dports/devel/R-cran-data.table/data.table/po/ |
| H A D | R-zh_CN.po | 587 "当传入 .SDcols 的参数为一个方程时，该方程将应用于每一列，并须返回单个非缺失值"
590 msgid ".SDcols missing at the following indices:"
591 msgstr ".SDcols 的如下位置为缺失值："
594 msgstr ".SDcols 为数值，但同时具有 +ve 和 -ve 索引"
596 msgid ".SDcols is numeric but out of bounds [1,"
597 msgstr ".SDcols 为数值但超出了 [1,"
602 msgid ".SDcols should be column numbers or names"
603 msgstr ".SDcols 应为列数或是列名"
606 msgstr ".SDcols 中的部份项目不是列名:"
621 "This j doesn't use .SD but .SDcols has been supplied. Ignoring .SDcols. See ?"
[all …]
|
| H A D | R-data.table.pot | 430 msgid "When .SDcols is a function, it is applied to each column; the output of this function must b…
433 msgid ".SDcols missing at the following indices:"
436 msgid ".SDcols is numeric but has both +ve and -ve indices"
439 msgid ".SDcols is numeric but out of bounds [1,"
445 msgid ".SDcols should be column numbers or names"
448 msgid "Some items of .SDcols are not column names:"
451 msgid "'(m)get' found in j. ansvars being set to all columns. Use .SDcols or a single j=eval(macro)…
457 msgid "This j doesn't use .SD but .SDcols has been supplied. Ignoring .SDcols. See ?data.table."
|
| H A D | zh_CN.po | 3606 "you're looking for 'DT[,lapply(.SD,mean),by=,.SDcols=]'. See ?data.table."
3609 "SD,mean),by=,.SDcols=]'。参见 ?data.table 。"
3654 "likely, you may be looking for 'DT[,lapply(.SD,min),by=,.SDcols=]'"
3659 "SDcols=]'"
3705 "likely, you may be looking for 'DT[,lapply(.SD,max),by=,.SDcols=]'"
3710 "的命令是 'DT[,lapply(.SD,max),by=,.SDcols=]'"
3742 "by=,.SDcols=]'"
3747 "的命令是 'DT[,lapply(.SD,median),by=,.SDcols=]'"
3828 "佳的方式是使用'DT[,lapply(.SD,var),by=,.SDcols=]'。"
3857 "likely, you may be looking for 'DT[,lapply(.SD,prod),by=,.SDcols=]'"
[all …]
|
| H A D | data.table.pot | 3358 "you're looking for 'DT[,lapply(.SD,mean),by=,.SDcols=]'. See ?data.table."
3402 "likely, you may be looking for 'DT[,lapply(.SD,min),by=,.SDcols=]'"
3443 "likely, you may be looking for 'DT[,lapply(.SD,max),by=,.SDcols=]'"
3473 "by=,.SDcols=]'"
3535 "diagonal elements, 'DT[,lapply(.SD,var),by=,.SDcols=]' is the optimized way "
3562 "likely, you may be looking for 'DT[,lapply(.SD,prod),by=,.SDcols=]'"
|
| /dports/devel/R-cran-data.table/data.table/ |
| H A D | NEWS.md | 173 …SDcols=is.numeric` now works; i.e., `SDcols=` accepts a function which is used to select the colum…
637 33. Using `get`/`mget` in `j` could cause `.SDcols` to be ignored or reordered, [#1744](https://git…
653 41. Using `get`/`mget` in `j` could cause `.SDcols` to be ignored or reordered, [#1744](https://git…
871 12. `DT[..., .SDcols=]` now accepts `patterns()`; e.g. `DT[..., .SDcols=patterns("^V")]`, for filte…
904 10. `DT[..., .SDcols=integer(0L)]` could fail, [#3185](https://github.com/Rdatatable/data.table/iss…
908 …SDcols=integer()]` failed with `.SDcols is numeric but has both +ve and -ve indices`, [#1789](http…
920 3. `.SDcols=` is more helpful when passed non-existent columns, [#3116](https://github.com/Rdatatab…
1262 15. `.SD` would incorrectly include symbol on lhs of `:=` when `.SDcols` is specified and `get()` a…
|