get_meta_df: get metadata df
In ianmoran11/tidyABS: The tidyABS package converts ABS excel tables to tidy data frames.
Description
This function:
1. Identifies which cells are likely to to contains meta data (in top right corner)
2. groups them according to their indenting, bold and italic formatting
3. Specifies the unpivotr function specifying the direction of the header w.r.t. table data
Usage
1
get_meta_df(sheet, value_ref, col_groups, formats)
Arguments
sheet
sheet object read in by tidyxl::xlsx_cells
value_ref
data frame representing corners of numeric cells in excel sheet
col_groups
format object read in by tidyxl::xlsx_cells
formats
format object read in by tidyxl::xlsx_cells
ianmoran11/tidyABS documentation built on May 30, 2019, 4:03 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description
This function: 1. Identifies which cells are likely to to contains meta data (in top right corner) 2. groups them according to their indenting, bold and italic formatting 3. Specifies the unpivotr function specifying the direction of the header w.r.t. table data
Usage
1 | get_meta_df(sheet, value_ref, col_groups, formats)
|
Arguments
sheet |
sheet object read in by |
value_ref |
data frame representing corners of numeric cells in excel sheet |
col_groups |
format object read in by |
formats |
format object read in by |
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.