edbuildr (version 0.3.0)

sd_table_xlsx: A function to create a table of school districts in a selected state or county

Description

This function allows you to write out a table of any school districts with selected data as a formatted excel file.

Usage

sd_table_xlsx(data_year = '2019', state = "New Jersey", county = NULL,
  table_vars = c('Name', 'Enrollment', 'Poverty Rate', 'Percent Nonwhite',
  'Local Revenue PP', 'State Revenue PP', 'Total Revenue PP'))

Arguments

data_year

Four digit year of master data to pull in. Options include 2013- 2019. Defaults to 2019.

state

State name. Defaults to New Jersey.

county

County name. Defaults to NULL.

table_vars

Variable or list of variables to include in the table. Use tables_vars = <U+201C>options<U+201D> to print a list of the variables. Defaults to: Name; Enrollment; Poverty Rate; Percent Nonwhite; Local Revenue, Per Pupil; State Revenue, Per Pupil; Total Revenue, Per Pupil.

Value

An excel workbook which can be written out with openxlsx::saveWorkbook(my_table, file = '~/Documents/state_year.xlsx', overwrite = TRUE)

See Also

sd_neighbor_xlsx, master_codebook, masterpull

Examples

# NOT RUN {
my_table <- sd_table_xlsx(data_year = "2019",
            state = "Maryland",
            county = c("Baltimore County", "Baltimore City", "Howard County", "Carroll County"),
            table_vars = c("Name", "Poverty Rate")
             )
# }