All functions

build_dataset()

Runs the entire data cleaning procedure for a given year

get_conf_attendance()

Cleans a tibble containing SIOP annual conference participants

make_demo_data()

A function wrapper that serially executes all steps related to demographic cleaning of raw XLSX membership data.

make_dues()

Wrapper function for binding several raw tibbles of dues data that could exist by month, into a single tibble that is then inputted as the dues argument in make_final_data

make_final_data()

A function wrapper that takes the cleaned dues and demo data and merges it, and cleans by SID, and finalizes a cleaned dataset ready for further analysis.

step_academicapplied()

Categorize whether a member works in an applied or academic setting.

step_agegroup()

Clean and categorize a member's age. Bins have been pre-established according to best practices. Age is calculated from the date the function was ran. Results may therefore vary.

step_birthdate()

Re-factor the Birthdate column to be a true Date variable

step_city()

Cleans and categorizes open-ended city name data and corrects errors.

step_country()

Cleans a member's country of residence/location.

step_dues()

Cleans a variety of columns in dues data

step_ethnicity()

Cleans a member's racial ethnicity.

step_field()

Cleans a member's field of study

step_gender()

Cleans a member's gender

step_highestdegree()

Cleans a member's highest earned degree.

step_interests()

Cleans primary interests categories, up to 3 in total

step_involvement()

Cleans Involvement Sought field

step_membergroup()

Cleans a member's categorization as individual or prospect

step_other_orgs()

Cleans Other Organizational Affiliations and licensure fields

step_privatepublic()

Cleans a member's school categorization

step_profitnon()

Cleans a member's school categorization.

step_sector()

Cleans a member's primary employment sector.

step_sid()

Removes SID duplicates

step_state()

Cleans a member's state of residence, USA only.