R/import_analytics_haridwar.R
import_sheets.RdImports multiple analytics sheets from an EXCEL spreadsheet
import_sheets(xlsPath, sheets_analytics, sheet_parameters = "Parameters", sheet_sites = "Sites", sheet_location = "Location", col_rawData_pattern = "raw", col_ignore_pattern = "mean|empty|X_|RX|not_used", skip = 69, tz_org = NULL, tz_export = "UTC", dbg = TRUE)
| xlsPath | path to xls file with analytics data |
|---|---|
| sheets_analytics | a character vector with the names of the sheets with analytics data (check with: readxl::excel_sheets(xlsPath)) |
| sheet_parameters | sheet name containing parameter metadata (default: "Parameters") |
| sheet_sites | sheet name containing sites metadata (default: "Sites") |
| sheet_location | sheet name containing location metadata (default: "Location") |
| col_rawData_pattern | specify pattenr of columns containing raw data (default: "raw") |
| col_ignore_pattern | specify pattern of columns that should be ignored of importing (default: "mean|empty|X_|RX|not_used") |
| skip | number of rows in sheet to skip (default: 69), |
| tz_org | specify timezone of samples (default: "UTC") |
| tz_export | specify timezone for data export (default: "UTC") |
| dbg | print debug messages (default: TRUE) |
returns data frame with normalised analytics data in list form