read_multsheets: Read multiple files (csv or excel) and/or multiple sheets...

In IdahoAgStats/facthelpeR: Helper Functions for Importing and Cleaning Data

Read multiple files (csv or excel) and/or multiple sheets (within an excel file) and handle headers that span multiple rows.

Description

Read in multiple files and or multiple sheets and handle headers that span multiple rows (using read_header()) This function must be provided a data.frame with file information. The data.frame can be initalized with the function list_sheetnames()

Usage

read_multsheets(
  data_folder,
  df,
  na = c("NA"),
  col_names,
  guess_max = 1000,
  complete_cases = TRUE
)

read.multsheets(
  data_folder,
  df,
  na = c("NA"),
  col_names,
  guess_max = 1000,
  complete_cases = TRUE
)

Arguments

data_folder	A string denoting the folder that contains the files to be read in
df	A data.frame with the column "filename", which can be inialized by the function list_sheetnames() Required data.frame columns: filename: name of the .xlsx or .csv Optional columns: sheets: name of the sheet (required for excel files with multiple sheets) list_names: names to label the element in the list. If list_names is not provided, the function will label the list elements using the concatenation of the file and sheet name header_start: the row number corresponding to the start of the header header_end: the row number corresponding to the last row of the header header_end = 1 corresponds to the header being in only the first row and corresponds to skipping 0 rows. If header_end is not provided, the default is set to 1, which will skip 0 rows. Note: If header_end is NA, the file/sheet will be removed (not read in)
na	Character vector of strings to interpret as missing values. By default, readxl treats blank cells as missing data.
col_names	TRUE to use the first row as column names, FALSE to get default names, or a character vector giving a name for each column. If user provides col_types as a vector, col_names can have one entry per column, i.e. have the same length as col_types, or one entry per unskipped column.
guess_max	Maximum number of data rows to use for guessing column types.
complete_cases	A logical. The default TRUE will remove empty rows

See Also

Other readin functions: list_sheetnames(), read_excelsheet(), read_header(), read_ods_multsheets(), read_sheets()

IdahoAgStats/facthelpeR documentation built on Jan. 29, 2024, 9:22 a.m.