report_top_times: Query Database for Event Rankings

In warlicks/swimR: Gather College Swimming Results From USA Swimming Top Time Reports

Description

Extract Top Times

Usage

report_top_times(con, conference = NULL, team_name = NULL,
  team_code = NULL, gender = "Both", athlete = NULL, event = "All",
  multiple_results = TRUE, top = 3)

Arguments

con	a database connection.
conference	a character vector with the name of an NCAA swimming conference. If not provided the output include all conferences.
team_name	A character vector with the name of an NCAA swimming conference. If not provided the output include all teams.
team_code	a character vector with the team code of an NCAA swimming team If not provided the output include all teams.
gender	a character vector. Indicates the output should include men, women or both. Defaults to "Both". Other options are "M" for men and "F" for women.
athlete	a character vector with the name or athlete id of a swimmier. If not provided the results include all swimmers. The athlete id follows the USA Swimming standard.
event	a character vector with the name of swimming envent. If not provided the results include all events.
multiple_results	a boolean indicator that determines if multiple results for the same athlete in a single event should be included in the output.
top	an integer indicating how many results to return per event.

Details

report_top_times queries a SQL database to produce a ranking of swimmers in the specified events. The function is flexiable and can rank swimmers across all of Division 1, within a specific conference or within a team. It can also produce a ranking of an individual swimmer's resutls.

Value

a data frame of ranked swimming results.

warlicks/swimR documentation built on May 4, 2019, 12:59 a.m.