lahman

0th

Percentile

Cache and retrieve an src_sqlite of the Lahman baseball database.

This creates an interesting database using data from the Lahman baseball data source, provided by Sean Lahman at http://www.seanlahman.com/baseball-archive/statistics/, and made easily available in R through the Lahman package by Michael Friendly, Dennis Murphy and Martin Monkman. See the documentation for that package for documentation of the inidividual tables.

Keywords
internal
Usage
lahman_sqlite(path = NULL)

lahman_postgres(dbname = "lahman", ...)

lahman_mysql(dbname = "lahman", ...)

lahman_df()

lahman_dt()

copy_lahman(src, ...)

has_lahman(type, ...)

lahman_srcs(..., quiet = NULL)

Arguments
...

Other arguments passed to src on first load. For mysql and postgresql, the defaults assume you have a local server with lahman database already created. For lahman_srcs, character vector of names giving srcs to generate.

type

src type.

quiet

if TRUE, suppress messages about databases failing to connect.

Aliases
  • copy_lahman
  • has_lahman
  • lahman
  • lahman_df
  • lahman_dt
  • lahman_mysql
  • lahman_postgres
  • lahman_sqlite
  • lahman_srcs
Examples
library(dplyr) # Connect to a local sqlite database, if already created if (has_lahman("sqlite")) { lahman_sqlite() batting <- tbl(lahman_sqlite(), "Batting") batting } # Connect to a local postgres database with lahman database, if available if (has_lahman("postgres")) { lahman_postgres() batting <- tbl(lahman_postgres(), "Batting") }
Documentation reproduced from package dplyr, version 0.5.0, License: MIT + file LICENSE

Community examples

Looks like there are no examples yet.