Format downloaded water quality data
Arguments
- df
DOEE Ambient Water Quality data downloaded from https://dcdoeepub.equisonline.com/PUBLIC.html
Examples
format_wq(df_wq_example)
#> # A tibble: 98,073 × 14
#> `Sample ID` Location Date Analyte Unit SAMPLETIME Result `Lab Qualifiers`
#> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 20C0524-01 PTB01 03 Mar… Nitrat… mg/l 10:03 1.23 M4
#> 2 20C0524-01 PTB01 03 Mar… Nitrog… mg/l 10:03 2.91 NA
#> 3 20C0524-01 PTB01 03 Mar… Phosph… NA 10:03 < 0.0… NA
#> 4 20C0524-01 PTB01 03 Mar… Total … mg/l 10:03 1.68 NA
#> 5 20C0524-02 TNS01 03 Mar… Nitrat… mg/l 10:29 0.489 NA
#> 6 20C0524-02 TNS01 03 Mar… Nitrog… mg/l 10:29 1.89 NA
#> 7 20C0524-02 TNS01 03 Mar… Phosph… mg/l 10:29 0.016 NA
#> 8 20C0524-02 TNS01 03 Mar… Total … mg/l 10:29 1.40 NA
#> 9 20C0524-03 TDA01 03 Mar… Nitrat… mg/l 10:53 2.10 NA
#> 10 20C0524-03 TDA01 03 Mar… Nitrog… mg/l 10:53 3.50 NA
#> # ℹ 98,063 more rows
#> # ℹ 6 more variables: `Validator Qualifiers` <chr>,
#> # `Interpreted Qualifiers` <chr>, result_format <dbl>,
#> # qualifier_format <chr>, location_format <chr>, date_format <date>