Skip to contents

Combine the three R2Q concentration tables (treshold values, background and stromwater)

Source: R/helping_functions.R
combine_concentration_tables.Rd

This function reduces the input tables to the columns "Substance", "Unit", renames the Value column according to the table data and combines all tables

Usage

combine_concentration_tables(
  threshold_table,
  storm_table,
  background_table,
  onlyComplete = FALSE
)

Arguments

threshold_table

the internal threshold table loaded with "get_thresholds"

storm_table

the internal stormwater concentration table loaded with "get_stormwater_concentrations"

background_table

the filled in background pollution data table (Excel File) loaded with "load_background_data"

onlyComplete

If TRUE (default) only such substances remain in the data frame with complete concentration triplet (threshold, stromwater, river) in the same unit

Value

A data frame with the information threshold values, threshold value type, background concentration and stormwater concentration per substance and concentration unit.

Details

Caution: This function uses the Column names of the tables. Do not change the first two column names of the pollution data. Column names must be

  1. "Substance" and 2) "Unit".