R/import_analytics_haridwar.R
import_sheet.Rd
Imports an analytics sheet from an EXCEL spreadsheet
import_sheet(xlsPath, sheet, col_names = TRUE, col_rawData_pattern = "raw", col_ignore_pattern = "mean|empty|X_|RX|not_used", skip = 69, tz_org = "UTC", tz_export = "UTC")
xlsPath | path to xls file with analytics data |
---|---|
sheet | a sheet in spreadsheet defined with "xlsPath" containing analytics data (check with: readxl::excel_sheets(xlsPath)) |
col_names | do the (default: TRUE) (default: "DateTime"), |
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") |
returns data frame with normalised analytics data in list form