colrect: Collect clustered data on multiple sheets into rectangle...

In luciphr/colrectr: What the Package Does (One Line, Title Case)

Description

Collect clustered data on multiple sheets into rectangle dataframe

Usage

colrect(
  path,
  sheet_regex,
  row = NULL,
  col = NULL,
  regex = NULL,
  offset = c(0, 0),
  ends = NULL,
  info = NULL
)

Arguments

path	Path to the xls/xlsx file.
sheet_regex	regex to search key
row	Row position of df where the keyword appears
col	Column position of df where the keyword appears
regex	Regular expression to match keywords
offset	The offset (c(row, pos)) of the cluster topleft from the coordination of keyword
ends	List of regex to locate row- and column- ends of each cluster Form should be like ends = list(row = "2019", col = "[Dd]ecember$"). Regex row = must specify the end of 'left most' columnn of df, not that of the column with key matched by regex
info	Parameters to make key:value list such as key_offset Offset c(row, col) of key topleft from df topleft. If NULL, automatically set to keyn key_dim Dimension c(row, col) of key value_offset Offset c(row, col) of value topleft from df topleft value_dim Dimension c(row, col) of value

luciphr/colrectr documentation built on Dec. 21, 2021, 12:41 p.m.