import_data_haridwar: Imports Haridwar data

In KWB-R/aquanes.report: Automated Reporting Tool for Water Suppliers

Description

Imports Haridwar data

Usage

import_data_haridwar(analytics_path = system.file(file.path("shiny",
  "haridwar/data/analytics.xlsx"), package = "aquanes.report"),
  operation_mySQL_conf = system.file("shiny/haridwar/.my.cnf", package =
  "aquanes.report"),
  operation_meta_path = system.file(file.path("shiny/haridwar/data",
  "operation_parameters.csv"), package = "aquanes.report"),
  excludedSheets = c("Parameters", "Location", "Sites", "#Summary",
  "Site_and_Parameter", "Observations", "dP", "ORP", "Flow",
  "Current_Voltage", "As_total_Arsenator"), skip = 69, debug = TRUE)

Arguments

analytics_path	Define path of analytics EXCEL spreadsheet to be imported (default: system.file(file.path("shiny/haridwar/data", "analytics.xlsx"), package = "aquanes.report"))
operation_mySQL_conf	column name pattern for identifying raw data (default: system.file("shiny/haridwar/.my.cnf", package = "aquanes.report"))
operation_meta_path	path to table with meta data for operational parameters (default: system.file(file.path("shiny/haridwar/data", "operation_parameters.csv"), package = "aquanes.report"))
excludedSheets	all sheets, which are not listed here will be imported as lab data sheets (default: c("Parameters", "Location", "Sites", "#Summary", "Site_and_Parameter", "Observations", "dP", "ORP", "Flow", "Current_Voltage", "As_total_Arsenator"))
skip	number of rows to skip for each lab data sheet (default: 69), i.e. for all sheets which are not explictly excluded with parameter "excludedSheets"
debug	if TRUE print debug messages (default: TRUE)

Value

returns data frame with Haridwar raw data (operation & analytics)

KWB-R/aquanes.report documentation built on Sept. 10, 2019, 8:04 a.m.