sd_table_xlsx: A function to create a table of school districts in a...
In edbuildr: Automated School District Data Download and Processing

Description Usage Arguments Value See Also Examples

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

1
2
3

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'))

`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 = “options” 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.

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

sd_neighbor_xlsx, master_codebook, masterpull

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")
             )