C R Operators and Functions Supported by Oracle Machine Learning for R

The OML4R packages support many R operators and functions that you can use with OML4R objects.

This appendix lists the R operators and functions that OML4R supports.

The OML4R sample programs include several examples using each category of these functions with OML4R data types.

You are not restricted to using this list of functions. If a specific function that you need is not supported by OML4R, you can pull data from the database into the R engine memory using ore.pull to create an in-memory R object first, and use any R function.

The following operators and functions are supported. See R documentation for syntax and semantics of these operators and functions. Syntax and semantics for these items are unchanged when used on a corresponding database-mapped data type (also known as an OML4R data type).

  • Mathematical transformations: abs, sign, sqrt, ceiling, floor, trunc, cummax, cummin, cumprod, cumsum, log, loglo, log10, log2, log1p, acos, acosh, asin, asinh, atan, atanh, cos, cosh, sin, sinh, tan, atan2, tanh, gamma, lgamma, digamma, trigamma, factorial, lfactorial, round, signif, pmin, pmax, zapsmall, rank, diff, besselI, besselJ, besselK, besselY

  • Basic statistics: mean, summary, min, max, sum, any, all, median, range, IQR, fivenum, mad, quantile, sd, var, table, tabulate, rowSums, colSums, rowMeans, colMeans, cor, cov

  • Arithmetic operators: +, -, *, /, ^, %%, %/%

  • Comparison operators: ==, >, <, !=, <=, >=

  • Logical operators: &, |, xor

  • Set operations: unique, %in%, subset

  • String operations: tolower, toupper, casefold, toString, chartr, sub, gsub, substr, substring, paste, nchar, grepl

  • Combine Data Frame: cbind, rbind, merge

  • Combine vectors: append

  • Vector creation: ifelse

  • Subset selection: [, [[, $, head, tail, window, subset, Filter, na.omit, na.exclude, complete.cases

  • Subset replacement: [<-, [[<-, $<-

  • Data reshaping: split, unlist

  • Data processing: eval, with, within, transform

  • Apply variants: tapply, aggregate, by

  • Special value checks: is.na, is.finite, is.infinite, is.nan

  • Metadata functions: nrow, NROW, ncol, NCOL, nlevels, names, names<-, row, col, dimnames, dimnames<-, dim, length, row.names, row.names<-, rownames, rownames<-, colnames, levels, reorder

  • Graphics: arrows, boxplot, cdplot, co.intervals, coplot, hist, identify, lines, matlines, matplot, matpoints, pairs, plot, points, polygon, polypath, rug, segments, smoothScatter, sunflowerplot, symbols, text, xspline, xy.coords

  • Conversion functions: as.logical, as.integer, as.numeric, as.character, as.vector, as.factor, as.data.frame

  • Type check functions: is.logical, is.integer, is.numeric, is.character, is.vector, is.factor, is.data.frame

  • Character manipulation: nchar, tolower, toupper, casefold, chartr, sub, gsub, substr

  • Other ore.frame functions: data.frame, max.col, scale

  • Hypothesis testing: binom.test, chisq.test, ks.test, prop.test, t.test, var.test, wilcox.test

  • Various Distributions: Density, cumulative distribution, and quantile functions for standard distributions

  • ore.matrix function: show, is.matrix, as.matrix, %*% (matrix multiplication), t, crossprod (matrix cross-product), tcrossprod (matrix cross-product A times transpose of B), solve (invert), backsolve, forwardsolve, all appropriate mathematical functions (abs, sign, and so on), summary (max, min, all, and so on), mean