readMWRresultsview {MassWateR}

Create summary spreadsheet of the water quality monitoring results

Description

Create summary spreadsheet of unique values for each column in the water quality results file to check for data mistakes prior to running the readMWRresults function

Usage

readMWRresultsview(
  respth,
  columns = NULL,
  output_dir,
  output_file = NULL,
  maxlen = 8
)

Arguments

respth

character string of path to the results file

columns

character string indicating which columns to view, defaults to all

output_dir

character string of the output directory for the rendered file

output_file

optional character string for the name of the .csv file output, must include the file extension

maxlen

numeric to truncate numeric values to the specified length

Details

Acceptable options for the columns argument include any of the column names in the results file. The default setting (NULL) will show every column in the results file.

The output of this function can be useful to troubleshoot the checks when importing the water quality monitoring result file with readMWRresults (see https://massbays-tech.github.io/MassWateR/articles/MassWateR.html#data-import-and-checks).

Value

Creates a spreadsheet at the location specified by output_dir. Each column shows the unique values.

Examples

respth <- system.file('extdata/ExampleResults.xlsx', package = 'MassWateR')

# all columns
readMWRresultsview(respth, output_dir = tempdir())

# parameters and units
readMWRresultsview(respth, columns = c('Characteristic Name', 'Result Unit'),
   output_dir = tempdir())