read_lims: Read AGAT LIMS data files

In bentrueman/cwrshelpr: Functions for CWRS Data Analysis

Read AGAT LIMS data files

Description

Read AGAT LIMS data files

Usage

read_lims(
  path,
  sheet_name = 1,
  first_line = "AGAT Workorder",
  meta_rows = 4,
  work_order
)

Arguments

path	Path to stored ICP-MS files
sheet_name	Name of MS Excel sheet where data are stored
first_line	The first column matches this pattern at the first line of data. As an input to stringr::str_detect(), this can be a partial match or a regex.
meta_rows	How many rows contain metadata that should appear in the column names? Default is 4.
work_order	The AGAT LIMS work order number. Used to select columns containing numeric data.

Value

A tibble with columns param, unit, rdl (detection limit), value, date, bdl (below detection indicator), and sample

Examples

file <- list.files(
   path = system.file("extdata", package = "cwrshelpr"),
   full.names = TRUE,
   pattern = ".+\\.xlsx"
)
read_lims(file[3], work_order = "00A123456")

bentrueman/cwrshelpr documentation built on July 1, 2023, 4:29 a.m.