Skip to contents

Read water-quality CSV (robust parsing)

Source: R/io_clean.R
read_wq.Rd

Reads a CSV file with comma or semicolon delimiter and comma or dot as decimal mark, ignoring unit suffixes (e.g., "0,04 mg/L"). Everything is read as text first, column names are normalized, and likely numeric columns are parsed robustly. A conservative safeguard adjusts obviously out-of-range pH values (e.g., 72 -> 7.2).

Usage

read_wq(path, tz = "America/Bahia")

Arguments

path

Path to the CSV file.

tz

Time zone for dates (kept for compatibility; dates are Date).

Value

A tibble with:

  • normalized, lowercase column names (spaces to _, non-alnum removed);

  • numeric columns parsed ignoring unit strings;

  • data parsed to Date (tries ymd then dmy);

  • ponto coerced to character (if present).

Parsed numeric candidates

c("ph","od","turbidez","dbo","coliformes","p_total","ptotal", "fosforo_total","temperatura","ec","condutividade","n_nitrato","n_nitrito", "amonia","nt_total","n_total","ntk","nkjeldahl","nitrogenio_total", "solidos_totais","solidos_suspensos","tds","conducao","qi","iqa","iet", "iet_carlson","iet_lamparelli","nsfwqi","vazao")

See also

clean_units(), validate_wq(), conama_check(), iqa()

Examples

if (FALSE) { # \dontrun{
# Minimal example (write a small CSV and read it):
tmp <- tempfile(fileext = ".csv")
writeLines(
  c("ponto;data;ph;od;turbidez",
    "R1_01;2025-01-20;7,2;6,8;5,1",
    "R1_01;21/01/2025;7.1;7.0;4.8 mg/L"),
  tmp
)
x <- read_wq(tmp)
str(x)
} # }