TADA_Stats: Generate Statistics Table

In USEPA/TADA: EPA TADA (Tools for Automated Data Analysis) R Package

Generate Statistics Table

Description

This function creates a summary table of the dataset based on grouping columns. The 'TADA.ComparableDataIdentifier' column is the required and default grouping column, but the user may include additional columns if desired. The summary table includes the measurement count, location count, censored data stats, min, max, and percentile stats, and a suggested non-detect estimation method. The estimation method is based on the following article: Baseline Assessment of Left-Censored Environmental Data Using R Tech Note. More info can be found here: https://www.epa.gov/sites/default/files/2016-05/documents/tech_notes_10_jun2014_r.pdf Suggested methods are based on the measurement count, the number of non-detects in the dataset, and the number of censoring levels (detection limit types) and methods include Maximum Likelihood Estimation, Robust ROS and Kaplan Meier.

Usage

TADA_Stats(.data, group_cols = c("TADA.ComparableDataIdentifier"))

Arguments

.data

TADA dataframe containing the data downloaded from the WQP, where each row represents a unique data record. Dataframe must include the columns 'TADA.ResultMeasureValue', 'TADA.ResultMeasure.MeasureUnitCode', 'TADA.ResultSampleFractionText', 'TADA.MethodSpeciationName', 'TADA.ComparableDataIdentifier', 'TADA.CensoredData.Flag', 'DetectionQuantitationLimitTypeName', and 'TADA.MonitoringLocationIdentifier' to run this function. The 'TADA.ComparableDataIdentifier' can be added to the dataframe by running the function TADA_CreateComparableID().

group_cols

This function automatically uses 'TADA.ComparableDataIdentifier' as a grouping column. However, the user may want to summarize their dataset by additional grouping columns. For example, a user may want to create a summary table where each row is specific to one comparable data identifier AND one TADA monitoring location. This input would look like: group_cols = c("TADA.MonitoringLocationIdentifier")

Value

stats table

Examples

# Load example dataset:
data(Data_6Tribes_5y_Harmonized)
# Create stats table:
Data_6Tribes_5y_Harmonized_stats <- TADA_Stats(Data_6Tribes_5y_Harmonized)

USEPA/TADA documentation built on April 12, 2025, 1:47 p.m.