Get summary of WW viral concentrations by state
Source:R/pre_processing.R
get_state_level_summary.RdThis uses the same processing steps that biobot uses (described in: https://github.com/biobotanalytics/covid19-wastewater-data#wastewater-data) We make columns for the unweighted avg concentraiton across the state, the population weighted average, the population weighted average with a 300,000 person threshold for site-specific population served, and a 3 week rolling average of the weighted concentration with the threshold, for both the state and national level. If there are gaps in weeks for a state, the 3 week average is across a longer time frame. We purposely do not use expand grid to inflate this, as we want those states with missing/ incomplete data to be missing data when the model is fit (rather than have NA values).