countItems: Count items by group

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

Description

Count number of items (permits, licenses, stamps, etc.) by group. This function will collect data from the database if using SQL backend.

Usage

countItems(df, groupVars = NULL)

Arguments

df	A data frame
groupVars	A character vector of variable names to group by

Value

A data frame with columns for grouping variables and a column named items for number of items. Data frame is passed through prettyData function.

See Also

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

Examples

# Demo data: Count number of deer licenses each year between 2010 and 2017
filterData(
  dataSource = "csv",
  activeFilters = list(itemType = "Deer", itemYear = c(2010, 2017))
) %>%
  countItems(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: Count number of deer licenses each year between 2010 and 2017
filterData(
  dataSource = "sql",
  conn = myConn,
  activeFilters = list(itemType = "Deer", itemYear = c(2010, 2017))
) %>%
  countItems(c("itemYear", "itemType"))

## End(Not run)

chrischizinski/huntfishapp documentation built on Sept. 7, 2020, 12:14 p.m.