dbData: Function to get sufficient statistics of variables from an...

In heike/dbData: Database Access for Sufficient Statistics of Data Graphics

Description

Function to get sufficient statistics of variables from an SQL database

Usage

  dbData(data, vars = list(), binwidth = -1, where = "")

Arguments

data	dataDB object
vars	list of variable names
binwidth	vector of bin sizes for each variable. -1 for minimal binwidth
where	character string with conditional statement for SQL query

Examples

connect <- dbConnect(dbDriver("MySQL"), user="2009Expo",
password="R R0cks", port=3306, dbname="baseball",
host="headnode.stat.iastate.edu")
pitch <- new("dataDB", co=connect, table="Pitching")
names(pitch)
head(pitch, n=10)[,1:8]
pitch.stats <- dbData(vars=list("H", "SO"), pitch)

require(ggplot2)
qplot(H, SO, alpha=Freq, data=pitch.stats)
qplot(H, SO, fill=Freq, data=dbData(pitch, list("SO", "H"),
  binwidth=c(10,50)), geom="tile")
qplot(H, SO, fill=Freq, data=dbData(pitch, list("SO", "H", "yearID"),
  binwidth=c(10,50, -1)), facets=~yearID, geom="tile")
qplot(H, SO, fill=Freq, data=dbData(pitch, list("SO", "H", "yearID"),
  binwidth=c(10,50, -1), where="yearID > 1990"), facets=~yearID, geom="tile")

heike/dbData documentation built on May 17, 2019, 3:23 p.m.