A Fast, Easy-to-Use Tool for Manipulating Tables in Databases and a Wrapper of MADlib


[Up] [Top]

Documentation for package ‘PivotalR’ version 0.1.18.5

Help Pages

A B C D E F G H I K L M N P R S T U V W misc

PivotalR-package An R font-end to PostgreSQL and Greenplum database, and wrapper for in-database parallel and distributed machine learning open-source library MADlib

-- A --

abalone Abalone data set
abs Mathematical functions that take 'db.obj' objects as the argument
abs-method Mathematical functions that take 'db.obj' objects as the argument
acos-method Mathematical functions that take 'db.obj' objects as the argument
Aggregate functions Functions to perform a calculation on multiple values and return a single value
AIC.glm.madlib.grps AIC methods for Madlib regression objects
AIC.lm.madlib AIC methods for Madlib regression objects
AIC.lm.madlib.grps AIC methods for Madlib regression objects
AIC.logregr.madlib AIC methods for Madlib regression objects
AIC.logregr.madlib.grps AIC methods for Madlib regression objects
Arith methods Arithmetic Operators for 'db.obj' objects
array.len Get the length of the array in an array column
arraydb.to.arrayr Convert strings extracted from database into arrays
as.character Cast columns of 'db.obj' objects to other types
as.character-method Cast columns of 'db.obj' objects to other types
as.data.frame.db.Rquery Read the actual data stored in a table of database.
as.data.frame.db.table Read the actual data stored in a table of database.
as.data.frame.db.view Read the actual data stored in a table of database.
as.Date-method Cast columns of 'db.obj' objects to other types
as.db.data.frame Convert other objects into a 'db.data.frame' object
as.db.data.frame-method Convert other objects into a 'db.data.frame' object
as.db.Rview Convert other objects into a 'db.data.frame' object
as.double Cast columns of 'db.obj' objects to other types
as.double-method Cast columns of 'db.obj' objects to other types
as.environment Evaluate expressions within the context of a database table or view
as.environment.db.obj Evaluate expressions within the context of a database table or view
as.factor-method Convert one column of a 'db.obj' object into a categorical variable
as.integer Cast columns of 'db.obj' objects to other types
as.integer-method Cast columns of 'db.obj' objects to other types
as.interval Cast columns of 'db.obj' objects to other types
as.list-method Combine two 'db.obj' Objects by Columns
as.logical Cast columns of 'db.obj' objects to other types
as.logical-method Cast columns of 'db.obj' objects to other types
as.numeric Cast columns of 'db.obj' objects to other types
as.numeric-method Cast columns of 'db.obj' objects to other types
as.time Cast columns of 'db.obj' objects to other types
as.timestamp Cast columns of 'db.obj' objects to other types
asin-method Mathematical functions that take 'db.obj' objects as the argument
atan-method Mathematical functions that take 'db.obj' objects as the argument
atan2-method Mathematical functions that take 'db.obj' objects as the argument

-- B --

by-method Apply a Function to a 'db.data.frame' Split by column(s)

-- C --

cbind Combine two 'db.obj' Objects by Columns
cbind2 Combine two 'db.obj' Objects by Columns
cbind2-method Combine two 'db.obj' Objects by Columns
clean.madlib.temp Delete all the result tables created during calculations of MADlib
coef.lm.madlib Extract model coefficients for Madlib regression objects
coef.lm.madlib.grps Extract model coefficients for Madlib regression objects
coef.logregr.madlib Extract model coefficients for Madlib regression objects
coef.logregr.madlib.grps Extract model coefficients for Madlib regression objects
col.types Cast columns of 'db.obj' objects to other types
colAgg Functions to perform a calculation on multiple values and return a single value
colMeans-method Functions to perform a calculation on multiple values and return a single value
colSums-method Functions to perform a calculation on multiple values and return a single value
Compare methods Comparison Operators for 'db.obj' objects
conn Utilities for extracting related information about a database connection
conn.eql Check whether two connections are the same
conn.id Find out the connection ID of a 'db.obj' object
conn.id<- Find out the connection ID of a 'db.obj' object
conn.pkg Utilities for extracting related information about a database connection
connection info Utilities for extracting related information about a database connection
content Print the content of a 'db.obj' object
cos-method Mathematical functions that take 'db.obj' objects as the argument
count Functions to perform a calculation on multiple values and return a single value
count-method Functions to perform a calculation on multiple values and return a single value
crossprod Compute the matrix product of 'X^T' and 'Y'.
crossprod-method Compute the matrix product of 'X^T' and 'Y'.

-- D --

db Execute a SQL query
db.array Functions to perform a calculation on multiple values and return a single value
db.connect Create a connection to a database
db.data.frame Create a 'db.data.frame' object pointing to a table/view in the database
db.data.frame-class Class '"db.data.frame"'
db.date.style Cast columns of 'db.obj' objects to other types
db.default.schemas Display or set the search path (i.e. default schemas) for a connected session to a database. The use can easily switch to a schema that he has the privilege to write.
db.disconnect Disconnect a connection to a database
db.existsObject Test whether an object exists in the database
db.list List all the currently active connections with their information
db.obj-class Abstract Class '"db.obj"'
db.objects List all the existing tables/views in a database with their schema names
db.q Execute a SQL query
db.Rcrossprod-class Class '"db.Rcrossprod"'
db.Rquery-class Class '"db.Rquery"' and its sub-class 'db.Rview-class'
db.Rview-class Class '"db.Rquery"' and its sub-class 'db.Rview-class'
db.search.path Display or set the search path (i.e. default schemas) for a connected session to a database. The use can easily switch to a schema that he has the privilege to write.
db.table-class Class '"db.table"'
db.view-class Class '"db.view"'
dbms Utilities for extracting related information about a database connection
dbname Utilities for extracting related information about a database connection
delete Safely delete a 'db.obj' object or a table/view in the database
delete-method Safely delete a 'db.obj' object or a table/view in the database
dim-method Dimension of a table

-- E --

eql Test if two objects point to the same table
eql-method Test if two objects point to the same table
exp Mathematical functions that take 'db.obj' objects as the argument
exp-method Mathematical functions that take 'db.obj' objects as the argument
extractAIC.glm.madlib AIC methods for Madlib regression objects
extractAIC.glm.madlib.grps AIC methods for Madlib regression objects
extractAIC.lm.madlib AIC methods for Madlib regression objects
extractAIC.lm.madlib.grps AIC methods for Madlib regression objects
extractAIC.logregr.madlib AIC methods for Madlib regression objects
extractAIC.logregr.madlib.grps AIC methods for Madlib regression objects
Extraction methods Extract or replace a part of 'db.obj' objects

-- F --

factorial Mathematical functions that take 'db.obj' objects as the argument
factorial-method Mathematical functions that take 'db.obj' objects as the argument

-- G --

generic.bagging This function runs boostrap aggregating for a given training function.
generic.cv Generic cross-validation for supervised learning algorithms
getTree.rf.madlib MADlib wrapper function for Random Forest
grepl Comparison Operators for 'db.obj' objects
grepl-method Comparison Operators for 'db.obj' objects
groups Summary information for Logistic Regression output
groups.lm.madlib Summary information for Logistic Regression output
groups.lm.madlib.grps Summary information for Logistic Regression output
groups.logregr.madlib Summary information for Logistic Regression output
groups.logregr.madlib.grps Summary information for Logistic Regression output

-- H --

host Utilities for extracting related information about a database connection

-- I --

ifelse-method Conditional Element Selection
is.db.data.frame Check if an object is of type 'db.data.frame'
is.factor-method Detect whether a 'db.obj' object is a categorical object
is.na-method Query if the entries in a table are NULL

-- K --

key Get or set the primary key for a table
key<- Get or set the primary key for a table

-- L --

lk Read the actual data stored in a table of database.
log Mathematical functions that take 'db.obj' objects as the argument
log-method Mathematical functions that take 'db.obj' objects as the argument
log10 Mathematical functions that take 'db.obj' objects as the argument
log10-method Mathematical functions that take 'db.obj' objects as the argument
Logical methods Logical operations for 'db.obj' objects
logLik.glm.madlib AIC methods for Madlib regression objects
logLik.glm.madlib.grps AIC methods for Madlib regression objects
logLik.lm.madlib AIC methods for Madlib regression objects
logLik.lm.madlib.grps AIC methods for Madlib regression objects
logLik.logregr.madlib AIC methods for Madlib regression objects
logLik.logregr.madlib.grps AIC methods for Madlib regression objects
lookat Read the actual data stored in a table of database.

-- M --

madlib Utilities for extracting related information about a database connection
madlib.arima Wrapper for MADlib's ARIMA model fitting function
madlib.arima-method Wrapper for MADlib's ARIMA model fitting function
madlib.elnet MADlib's elastic net regularization for generalized linear models
madlib.glm Generalized Linear Regression by MADlib in databases
madlib.kmeans Wrapper for MADlib's Kmeans clustering function
madlib.lda Wrapper for MADlib's Latent Dirichilet Allocation
madlib.lm Linear regression with grouping support, heteroskedasticity
madlib.randomForest MADlib wrapper function for Random Forest
madlib.rpart MADlib wrapper function for Decision Tree
madlib.summary Data summary function
madlib.svm Support Vector Machine with regression and novelty detection
madlib.version Utilities for extracting related information about a database connection
margins Compute the marginal effects of regression models
margins.lm.madlib Compute the marginal effects of regression models
margins.lm.madlib.grps Compute the marginal effects of regression models
margins.logregr.madlib Compute the marginal effects of regression models
margins.logregr.madlib.grps Compute the marginal effects of regression models
Math Functions Mathematical functions that take 'db.obj' objects as the argument
max-method Functions to perform a calculation on multiple values and return a single value
mean-method Functions to perform a calculation on multiple values and return a single value
merge-method Computing a join on two tables
min-method Functions to perform a calculation on multiple values and return a single value

-- N --

na.omit-method Functions for filtering 'NA' values in data
names-method The Names of an object
names<--method The Names of an object
null.data A Data Set with lots of 'NA' values

-- P --

perplexity.lda.madlib Perplexity of LDA predictions
PivotalR Graphical interface for PivotalR based upon shiny
pivotalr Graphical interface for PivotalR based upon shiny
plot.dt.madlib Plot the result of madlib.rpart
port Utilities for extracting related information about a database connection
predict.arima.css.madlib Forecast from MADlib's ARIMA fits
predict.bagging.model Make predictions using the result of 'generic.bagging'
predict.dt.madlib Compute the predictions of the model produced by madlib.rpart
predict.elnet.madlib Predict using the regression result of elastic net regularization
predict.glm.madlib Generate the 'db.Rquery' object that can calculate the predictions
predict.glm.madlib.grps Generate the 'db.Rquery' object that can calculate the predictions
predict.lda.madlib Prediction function for MADlib's LDA models
predict.lm.madlib Generate the 'db.Rquery' object that can calculate the predictions
predict.lm.madlib.grps Generate the 'db.Rquery' object that can calculate the predictions
predict.logregr.madlib Generate the 'db.Rquery' object that can calculate the predictions
predict.logregr.madlib.grps Generate the 'db.Rquery' object that can calculate the predictions
predict.rf.madlib Compute the predictions of the model produced by madlib.randomForest
print-method Display the connection information associated with a 'db' object
print.arima.css.madlib Display results of ARIMA fitting of 'madlib.arima'
print.dt.madlib Print the result of madlib.rpart
print.elnet.madlib Display the results from madlib.elnet function in a pretty format
print.glm.madlib Display results of logistic regression
print.glm.madlib.grps Display results of logistic regression
print.lm.madlib Display results of linear regression
print.lm.madlib.grps Display results of linear regression
print.logregr.madlib Display results of logistic regression
print.logregr.madlib.grps Display results of logistic regression
print.margins Compute the marginal effects of regression models
print.none.obj Function used in GUI to print absolutely nothing
print.rf.madlib Print the result of madlib.randomForest
print.summary.madlib Display the results from summary function in a pretty format

-- R --

relevel-method Convert one column of a 'db.obj' object into a categorical variable
Replacement methods Extract or replace a part of 'db.obj' objects
residuals.glm.madlib Residuals methods for Madlib regression objects
residuals.glm.madlib.grps Residuals methods for Madlib regression objects
residuals.lm.madlib Residuals methods for Madlib regression objects
residuals.lm.madlib.grps Residuals methods for Madlib regression objects
residuals.logregr.madlib Residuals methods for Madlib regression objects
residuals.logregr.madlib.grps Residuals methods for Madlib regression objects
rowMeans-method Compute the sum or mean of all columns in one row of a table
rowSums-method Compute the sum or mean of all columns in one row of a table

-- S --

sample-method Methods for sampling rows of data from a table/view randomly
scale-method Scaling and centering of tables
schema.madlib Utilities for extracting related information about a database connection
sd Functions to perform a calculation on multiple values and return a single value
sd-method Functions to perform a calculation on multiple values and return a single value
show-method Display the connection information associated with a 'db' object
show.arima.css.madlib Display results of ARIMA fitting of 'madlib.arima'
show.elnet.madlib Display the results from madlib.elnet function in a pretty format
show.glm.madlib Display results of logistic regression
show.glm.madlib.grps Display results of logistic regression
show.lm.madlib Display results of linear regression
show.lm.madlib.grps Display results of linear regression
show.logregr.madlib Display results of logistic regression
show.logregr.madlib.grps Display results of logistic regression
show.summary.madlib Display the results from summary function in a pretty format
sign Mathematical functions that take 'db.obj' objects as the argument
sign-method Mathematical functions that take 'db.obj' objects as the argument
sin-method Mathematical functions that take 'db.obj' objects as the argument
sort-method Sort a table or view by a set of columns
sqrt Mathematical functions that take 'db.obj' objects as the argument
sqrt-method Mathematical functions that take 'db.obj' objects as the argument
subset-method Extract a subset of a table or view
sum-method Functions to perform a calculation on multiple values and return a single value
summary-method Data summary function
summary.arima.css.madlib Summary information for MADlib's ARIMA model
summary.elnet.madlib Summary information for Elastic net regularization output
summary.glm.madlib Summary information for Logistic Regression output
summary.glm.madlib.grps Summary information for Logistic Regression output
summary.lm.madlib Summary information for Linear Regression output
summary.lm.madlib.grps Summary information for Linear Regression output
summary.logregr.madlib Summary information for Logistic Regression output
summary.logregr.madlib.grps Summary information for Logistic Regression output

-- T --

tan-method Mathematical functions that take 'db.obj' objects as the argument
Terms Compute the marginal effects of regression models
text.dt.madlib Add labels onto the figure generated by plot.dt.madlib
Type Cast functions Cast columns of 'db.obj' objects to other types

-- U --

unique-method The Unique of an object
user Utilities for extracting related information about a database connection

-- V --

var Functions to perform a calculation on multiple values and return a single value
var-method Functions to perform a calculation on multiple values and return a single value
Vars Compute the marginal effects of regression models
vcov.lm.madlib vcov methods for Madlib regression objects
vcov.lm.madlib.grps vcov methods for Madlib regression objects
vcov.logregr.madlib vcov methods for Madlib regression objects
vcov.logregr.madlib.grps vcov methods for Madlib regression objects

-- W --

with Evaluate expressions within the context of a database table or view
with.db.obj Evaluate expressions within the context of a database table or view

-- misc --

!-method Logical operations for 'db.obj' objects
!=-method Comparison Operators for 'db.obj' objects
$-method Extract or replace a part of 'db.obj' objects
$<--method Extract or replace a part of 'db.obj' objects
%%-method Arithmetic Operators for 'db.obj' objects
%/%-method Arithmetic Operators for 'db.obj' objects
&-method Logical operations for 'db.obj' objects
*-method Arithmetic Operators for 'db.obj' objects
+-method Arithmetic Operators for 'db.obj' objects
--method Arithmetic Operators for 'db.obj' objects
.db Execute a SQL query
/-method Arithmetic Operators for 'db.obj' objects
<-method Comparison Operators for 'db.obj' objects
<=-method Comparison Operators for 'db.obj' objects
==-method Comparison Operators for 'db.obj' objects
>-method Comparison Operators for 'db.obj' objects
>=-method Comparison Operators for 'db.obj' objects
[-method Extract or replace a part of 'db.obj' objects
[<-.db.obj Extract or replace a part of 'db.obj' objects
[[-method Extract or replace a part of 'db.obj' objects
[[<--method Extract or replace a part of 'db.obj' objects
^-method Arithmetic Operators for 'db.obj' objects
|-method Logical operations for 'db.obj' objects