Community Cohort Evaluation Tool

This repository contains an R tool used by the Chicago Metropolitan Agency for Planning to group the 284 municipalities and 77 Chicago Community Areas (CCAs) in the region into cohorts, which are then used to determine local contribution levels for Local Technical Assistance projects.

Below is the project structure, with notes about each file. The important files are shown in bold.

• community_cohort_tool.R: the Community Cohort Evaluation Tool
• community-cohort-tool.Rproj: RStudio project specification file
• docs/
  • index.Rmd: an Rmarkdown version of community_cohort_tool.R that generates an HTML report
  • index.html: the report generated by index.Rmd
• input/
  • community_cohort_inputs.xlsx: spreadsheet containing all input data, weights and cohort score thresholds
• output/
  • 1yr/
    • cohort_assignments_cca_1yr_{YYYY}.csv: CCA-level results generated by community_cohort_tool.R based on the latest data available that year
    • cohort_assignments_muni_1yr_{YYYY}.csv: municipal-level results generated by community_cohort_tool.R based on the latest data available that year
  • 3yr/
    • cohort_assignments_cca_3yr_{YYYY}_{YYYY}.csv: CCA-level results generated by community_cohort_tool.R containing 3-year rolling average scores and the resultant cohorts -- these are the official cohorts, as of 2022
    • cohort_assignments_muni_3yr_{YYYY}_{YYYY}.csv: municipal-level results generated by community_cohort_tool.R containing 3-year rolling average scores and the resultant cohorts -- these are the official cohorts, as of 2022