Auxiliary Wastewater Data
In Covid19Wastewater: Prepare, Analyze, and Visualize Covid-19 Wastewater Data

knitr::opts_chunk$set(Warning = FALSE, message = FALSE, echo = FALSE)

Auxiliary Wastewater data

library(Covid19Wastewater)
library(dplyr)
library(ggplot2)
library(tidyr)

This dataframe contains all columns dropped from the main wastewater dataframe. It is merged using https://github.com/UW-Madison-DSI/Covid19Wastewater/blob/main/docs/data/data_disc.md

data(Aux_info_data, package = "Covid19Wastewater")
Aux_info_data%>%
  select(sample_id:bcov_rec_rate)%>%
  head()%>%
  knitr::kable()


Aux_info_data%>%
  select(sample_type:n2_num_ntc_amplify)%>%
  head()%>%
  knitr::kable()

Aux_info_data%>%
  select(avg_sars_cov2_conc:analytical_comments)%>%
  head()%>%
  knitr::kable()

Aux_info_data%>%
  select(inhibition_detect:equiv_sewage_amt)%>%
  head()%>%
  knitr::kable()

Missing Columns

These rows have many missing values. For some columns over 90% of the rows are missing. Below is a table showing what percent of the data is missing for each column.

Aux_info_data%>%
  summarise(across(everything(), ~100 * mean(is.na(.x))))%>%
  pivot_longer(everything(), names_to = "column name", values_to = "na %")%>%
  knitr::kable()