loadMetaForm: Fix metadata template

View source: R/Utilities.R

loadMetaFormR Documentation

Fix metadata template

Description

Load and transform our CRUK CI Bioinfomratics Core metadata template into a table suitable for the PlateLayout package

Usage

loadMetaForm(xlsFile)

Arguments

xlsFile

The metadata template Excel file

Details

The function takes the path for an Excel file containing completed CRUK CI metadata template and transforms it into a table suitable for use with the randomizeSinglePlate function.

When loading the Excel file the function skips the first row, making the headers from the second (hidden) row in the template. The third row in the template contains a contents description for each column and so is removed from the table.

Any columns that are completely empty are removed. NA is replaced with a blank characer vector.

Value

The cleaned metadata as a tibble and exports a tsv version

Examples

metadataFile <- system.file("extdata", "metadata_template_example.xls",
                           package = "PlateLayout")
metadataTable <- loadMetaForm(metadataFile)
metadataTable

crukci-bioinformatics/PlateLayout documentation built on Feb. 27, 2023, 6:49 p.m.