clean_swim: Clean Up USA Swimming Top Times Report

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

Description

clean_swim prepares the data for easy use.

Usage

clean_swim(data)

Arguments

data	A data frame with the same column names as the file downloaded by individual_swims

Details

clean_swim prepares the data for easy use. It starts by selecting only needed columns. The function also creates a unique ID for each athlete. Swim times are also convertd from character strings to numeric variable repersenting seconds.

All of the operations are performed based on column name. The column names for the provided data frame need to match the column names from the file downloaded by individual_swims.

In order to make the data more usable, only needed columns are kept from the orignal data frame. In addition two columns, athlete_id and swim_time2 are created by the function. A complete listing of the columns returned by the function can be found below.

In order to identify unique athletes a unique identifier is created for each athlete. The unique id follows the format used by USA Swimming. Bithdate First; 3 letters of first name; first 4 leters of last name. (mm/dd/yyjansmit). It is stored in the column athlete_id .

In the top time report downloaded by individual_swims, the athlete's time in a races is stored as a character string. For shorter races, those under a minute, the string has the format "SS.ss". For races over a minute the character string has the format "MM:SS.ss".

Since we typically want to work an athletes time, we need to convert swim time to a numeric format. In clean_swim a new column swim_time2 is created to store converted time. The athlete's time is repersented in seconds.

Value

The function returns a data frame with the following columns:

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