calcGenderProportion: Calculate gender proportion

In natbprice/huntfishapp: Exploratory Data Analysis Application for Hunting, Fishing, and Outdoor Recreation

Description

Calculate gender proportion by group. This function collects data from the database.

Usage

calcGenderProportion(df, groupVars = NULL)

Arguments

df	A data frame with a column named customerUID
groupVars	A character vector of variable names to group by

Value

A dataframe with columns for grouping variables and a column named genderProportion for gender proportion. Data frame is passed through prettyData function.

See Also

Other analysis functions: calcChurn, calcParticipation, calcRecruitment, countCustomers, countItems, itemGroupCount, sumRevenue

Examples

# Demo data: Gender proportions for customers purchasing a fishing
# license between 2010 and 2017
filterData(
  dataSource = "csv",
  activeFilters = list(itemType = "Fish", itemYear = c(2010, 2017))
) %>%
  calcGenderProportion(c("itemYear", "itemType"))
## Not run: 
# Database connection. Suggest using keyring package to avoid hardcoding
# passwords
myConn <- DBI::dbConnect(odbc::odbc(),
  dsn = "HuntFishApp", # Your datasource name
  uid = keyring::key_get("HuntFishAppUID"), # Your username
  pwd = keyring::key_get("HuntFishAppPWD")
) # Your password

# SQL Backend: Gender proportions for customers purchasing a fishing
# license between 2010 and 2017
filterData(
  dataSource = "sql",
  conn = myConn,
  activeFilters = list(itemType = "Fish", itemYear = c(2010, 2017))
) %>%
  calcGenderProportion(c("itemYear", "itemType"))

## End(Not run)

natbprice/huntfishapp documentation built on Sept. 2, 2020, 11:01 p.m.