bcgov / water-quality-analysis

R scripts to calculate water quality trends and the water quality index at selected ambient monitoring stations in B.C.
Apache License 2.0
11 stars 4 forks source link

Eliminate erroneous and/or patchy data #5

Closed joethorley closed 8 years ago

joethorley commented 8 years ago

@colinpmillar Can you write code in the 02_clean.R script to identify and eliminate erroneous water quality data or data that is too patchy to have any use?

joethorley commented 8 years ago

This is what the exec summary of a recent report (Tristar 2016) states

In performing our evaluation for each water body, we performed a preliminary assessment of data quality. This involved removing a number of obvious errors form the database that we used (e.g., -999 entries). We also pointed out that many temperature values were recorded as less than zero degrees C. Finally, we examined any data points that were above a levels of the mean concentration plus three standard deviations, and assessed whether the data were valid or possibly an error.

joethorley commented 8 years ago

done