Reads the data from an Excel file. Validation of the scheme version and
scheme name is always done. Additional validations are done depending on the
arguments validate
. See detals below.
Arguments
- file
the name of the Excel file (.xls or .xlsx) containing the data to be read.
- keepData
if
TRUE
, the data in the spreadsheetfile
will be kept (as indmdScheme_example
. IfFALSE
, it will be replaced with one row with NAs as indmdScheme
. Only used whenraw == FALSE
.- verbose
give verbose progress info. Useful for debugging.
- raw
if
TRUE
the imported spreadsheetfile
will be returned as an object of classdmdScheme_raw
. IfFALSE
, it will be converted to andmdScheme
object.- validate
if
TRUE
results are validated usingvalidate(validateData = FALSE, errorIfStructFalse = TRUE )
.Consequently, an error is raised if the resulting scheme can not be successfully validated against the one in the package. There are not many cases where you want to change this value toFALSE
. But if you do, the result will not be validated. This can lead to invalid schemes!.
Value
either if raw = TRUE
a list of data.frames from the worksheets of
Class dmdScheme_raw
, otherwise an object of class
dmdSchemeSet
Examples
fn <- scheme_path_xlsx()
read_excel(
file = fn
)
#> dmdScheme - dmdSchemeSet
#> MdBibliometric - dmdSchemeData
#> A Names : uploadType | doi | publicationDate | title | description | version | language | keywords | additionalNotes | accessRights | accessRightsInfo | license
#> A Units :
#> A Type : character | character | character | character | character | character | character | character | character | character | character | character
#>
#> uploadType doi publicationDate title
#> D 1 Dataset 110.1234/ffoo.bar 2020-05-26 Microbes under Pressure
#> description
#> D 1 The dataset was generated by putting microbes under pressure through temperatue and oxygen changes and their changes ion abundance were observed.
#> version language
#> D 1 <NA> eng
#> keywords
#> D 1 microbes, temperatur change, oxygen changes, abundance
#> additionalNotes accessRights accessRightsInfo
#> D 1 <NA> Open <NA>
#> license
#> D 1 Creative Commons Attribution 4.0 International
#>
#> MdAuthors - dmdSchemeData
#> A Names : authorID | familyName | givenName | affiliation | orcid | role
#> A Units : NA | NA | NA | NA | NA | NA
#> A Type : character | character | character | character | character | character
#>
#> authorID familyName givenName affiliation orcid
#> D 1 1 Petchey Owen L. University of Zurich, Switzerland <NA>
#> D 2 2 Krug Rainer M. University of Zurich, Switzerland <NA>
#> role
#> D 1 Conceptualization, Investigation
#> D 2 Data curation
#>
#> Experiment - dmdSchemeData
#> A Names : name | temperature | light | humidity | incubator | container | microcosmVolume | mediaType | mediaConcentration | cultureConditions | comunityType | mediaAdditions | duration | comment
#> A Units : NA | NA | NA | NA | NA | NA | ml | NA | g/l | NA | NA | NA | days | NA
#> A Type : character | character | character | character | character | character | numeric | character | numeric | character | character | character | integer | character
#>
#> name temperature light humidity incubator
#> D 1 ASR-expt1 20 semi-ambient ambient not given here
#> container microcosmVolume mediaType
#> D 1 Duran type bottle, red lids, 250ml 100 PPM
#> mediaConcentration cultureConditions comunityType
#> D 1 0.55 dirty initially unknown
#> mediaAdditions
#> D 1 Wheat seeds added on specific dates, see file wheat_seed_additions.csv
#> duration comment
#> D 1 100 <NA>
#>
#> Genus - dmdSchemeData
#> A Names : speciesID | colour | density | functionalGroup | comment
#> A Units : NA | NA | cells / ml | NA | NA
#> A Type : character | character | character | character | character
#>
#> speciesID colour density functionalGroup
#> D 1 tt_1 ATCC 1 bacterivore
#> D 2 unknown unknown <NA> unknown
#> comment
#> D 1 http://www.lgcstandards-atcc.org/products/all/30007.aspx
#> D 2 <NA>
#>
#> Treatments - dmdSchemeData
#> A Names : treatmentID | treatmentLevelHeight | comment
#> A Units : NA | NA | NA
#> A Type : character | character | character
#>
#> treatmentID treatmentLevelHeight comment
#> D 1 Lid_treatment Loose <NA>
#> D 2 Lid_treatment Tight <NA>
#> D 3 species_1 tt_1, unknown <NA>
#> D 4 species_2 unknown <NA>
#> D 5 species_3 tt_1 <NA>
#>
#> Measurement - dmdSchemeData
#> A Names : measurementID | variable | method | unit | object | noOfSamplesInTimeSeries | samplingVolume | dataExtractionID | measuredFrom | comment
#> A Units : NA | NA | NA | NA | NA | NA | ml | NA | NA | NA
#> A Type : character | character | character | character | character | integer | numeric | character | character | character
#>
#> measurementID variable method unit
#> D 1 oxygen concentration DO presens Optode %
#> D 2 abundance abundance molecular count
#> D 3 smell smell nose rotten eggs or not
#> D 4 sequenceData DNA NGS Nucleotide
#> object noOfSamplesInTimeSeries samplingVolume
#> D 1 community 50 0.0
#> D 2 species 6 0.5
#> D 3 community 6 0.0
#> D 4 DNA fragment 6 0.0
#> dataExtractionID measuredFrom comment
#> D 1 none raw <NA>
#> D 2 Mol_Analy_pipeline1 sequenceData <NA>
#> D 3 none raw <NA>
#> D 4 none raw <NA>
#>
#> DataExtraction - dmdSchemeData
#> A Names : dataExtractionID | method | parameter | value | comment
#> A Units : NA | NA | NA | NA | NA
#> A Type : character | character | character | character | character
#>
#> dataExtractionID method parameter value
#> D 1 Mol_Analy_pipeline1 <NA> <NA> <NA>
#> comment
#> D 1 See description in file xxx.yyy
#>
#> DataFileMetaData - dmdSchemeData
#> A Names : dataFileName | columnName | columnData | mappingColumn | type | description | comment
#> A Units : NA | NA | NA | NA | NA | NA | NA
#> A Type : character | character | character | character | character | character | character
#>
#> dataFileName columnName columnData
#> D 1 dissolved_oxygen_measures.csv Jar_ID ID
#> D 2 dissolved_oxygen_measures.csv DO Measurement
#> D 3 dissolved_oxygen_measures.csv Unit_1 other
#> D 4 dissolved_oxygen_measures.csv Mode other
#> D 5 dissolved_oxygen_measures.csv Location other
#> D 6 dissolved_oxygen_measures.csv Date_time other
#> D 7 dissolved_oxygen_measures.csv Lid_treatment Treatment
#> D 8 dissolved_oxygen_measures.csv Jar_type other
#> D 9 dissolved_oxygen_measures.csv Jar_ID ID
#> D 10 smell.csv <NA> Species
#> D 11 smell.csv smell Measurement
#> D 12 smell.csv Date other
#> D 13 smell.csv Lid_treatment Treatment
#> D 14 smell.csv Jar_type other
#> D 15 abundances.csv <NA> Species
#> D 16 abundances.csv Jar_ID ID
#> D 17 abundances.csv Date_time other
#> D 18 abundances.csv Lid_treatment Treatment
#> D 19 abundances.csv Jar_type other
#> D 20 abundances.csv count_number Measurement
#> mappingColumn type description comment
#> D 1 <NA> character <NA> <NA>
#> D 2 oxygen concentration numeric <NA> <NA>
#> D 3 <NA> character <NA> <NA>
#> D 4 <NA> character <NA> <NA>
#> D 5 <NA> character <NA> <NA>
#> D 6 <NA> datetime ymdhms <NA>
#> D 7 Lid_treatment character <NA> <NA>
#> D 8 <NA> character <NA> <NA>
#> D 9 <NA> character <NA> <NA>
#> D 10 species_1 character <NA> <NA>
#> D 11 smell character <NA> <NA>
#> D 12 <NA> datetime ymdhms <NA>
#> D 13 Lid_treatment character <NA> <NA>
#> D 14 <NA> character <NA> <NA>
#> D 15 species_3 character <NA> <NA>
#> D 16 <NA> character <NA> <NA>
#> D 17 <NA> datetime ymdhms <NA>
#> D 18 Lid_treatment character <NA> <NA>
#> D 19 <NA> character <NA> <NA>
#> D 20 abundance numeric <NA> <NA>
#>
read_excel(
file = fn,
raw = TRUE
)
#> $MdBibliometric
#> propertySet valueProperty type
#> 1 MdBibliometric uploadType character
#> 2 <NA> doi character
#> 3 <NA> publicationDate character
#> 4 <NA> title character
#> 5 <NA> description character
#> 6 <NA> version character
#> 7 <NA> language character
#> 8 <NA> keywords character
#> 9 <NA> additionalNotes character
#> 10 <NA> accessRights character
#> 11 <NA> accessRightsInfo character
#> 12 <NA> license character
#> suggestedValues
#> 1 <NA>
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> 10 <NA>
#> 11 <NA>
#> 12 Creative Commons Attribution 4.0 International
#> allowedValues
#> 1 Dataset, Image - Photo, Video / Audio
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> 10 Open, Embargoed, Restricted, Closed
#> 11 <NA>
#> 12 <NA>
#> Description
#> 1 The type of the data. Needs tobe one as specified in the allowedValues
#> 2 The DOI of the dataset. Usually the reserved DOI.
#> 3 Date of publication of the data package in the format YYYY-MM-DD
#> 4 Title of the data package
#> 5 Short description of the data deposited
#> 6 The version of the dataset. Usually empty, but the version should be specified if the dataset is augmented or corrected.
#> 7 The language of the dataset. E.g. "eng", "fr", …
#> 8 Keywords describing the dataset
#> 9 Some additional info, which does not fit in any category.
#> 10 Access rights to the data, normally Open or Embargoed.
#> 11 if Embargoed, the date until embargoed (YYYY-MM-DD), if Restricted, conditions under which access is granted to the data
#> 12 Should normally be "Creative Commons Attribution 4.0 International" (CCA4)
#> DATA
#> 1 Dataset
#> 2 110.1234/ffoo.bar
#> 3 2020-05-26
#> 4 Microbes under Pressure
#> 5 The dataset was generated by putting microbes under pressure through temperatue and oxygen changes and their changes ion abundance were observed.
#> 6 <NA>
#> 7 eng
#> 8 microbes, temperatur change, oxygen changes, abundance
#> 9 <NA>
#> 10 Open
#> 11 <NA>
#> 12 Creative Commons Attribution 4.0 International
#>
#> $MdAuthors
#> propertySet MdAuthors ...3
#> 1 valueProperty authorID familyName
#> 2 unit <NA> <NA>
#> 3 type character character
#> 4 suggestedValues <NA> <NA>
#> 5 allowedValues <NA> <NA>
#> 6 Description Just an id - can be a number Family name of the author
#> 7 DATA 1 Petchey
#> 8 MULTIPLE ROWS 2 Krug
#> ...4 ...5
#> 1 givenName affiliation
#> 2 <NA> <NA>
#> 3 character character
#> 4 <NA> <NA>
#> 5 <NA> <NA>
#> 6 Given name(s) of the authors Affiliation of the author
#> 7 Owen L. University of Zurich, Switzerland
#> 8 Rainer M. University of Zurich, Switzerland
#> ...6
#> 1 orcid
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 ORCID (Open Researcher and Contributor ID, as issued by https://orcid.org)
#> 7 <NA>
#> 8 <NA>
#> ...7
#> 1 role
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 Conceptualization, Data curation, Formal Analysis, Funding acquisition, Investigation, Methodology, Project administration, Resources, Software, Supervision, Validation, Visualization, Writing – original draft, Writing – review & editing
#> 6 Role of the author, using the CRediT – Contributor Roles Taxonomy at https://casrai.org/credit/. Can be more than one.
#> 7 Conceptualization, Investigation
#> 8 Data curation
#>
#> $Experiment
#> propertySet valueProperty unit type
#> 1 Experiment name <NA> character
#> 2 <NA> temperature <NA> character
#> 3 <NA> light <NA> character
#> 4 <NA> humidity <NA> character
#> 5 <NA> incubator <NA> character
#> 6 <NA> container <NA> character
#> 7 <NA> microcosmVolume ml numeric
#> 8 <NA> mediaType <NA> character
#> 9 <NA> mediaConcentration g/l numeric
#> 10 <NA> cultureConditions <NA> character
#> 11 <NA> comunityType <NA> character
#> 12 <NA> mediaAdditions <NA> character
#> 13 <NA> duration days integer
#> 14 <NA> comment <NA> character
#> suggestedValues
#> 1 <NA>
#> 2 treatment, in degrees celsius, measurement
#> 3 treatment,light, dark, cycle , e.g. 16:8 LD
#> 4 treatment, relative humidity in %
#> 5 none, bench
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> 10 axenic, dirty, clean
#> 11 treatment, single trophic level, multiple trophic level
#> 12 <NA>
#> 13 <NA>
#> 14 <NA>
#> Description
#> 1 The name of the experiment.
#> 2 Temperature used for all treatments. If different between treatments, use "treatment" and specify in the Treatment sheet.
#> 3 Light used for all treatments. If different between treatments, use "treatment" and specify in the Treatment sheet.
#> 4 Humidity used for all treatments. If different between treatments, use "treatment" and specify in the Treatment sheet.
#> 5 What type of incubator is used.
#> 6 What type of container is used.
#> 7 Volume of the microcosm container. Not the volume of the culture medium!
#> 8 <NA>
#> 9 <NA>
#> 10 Conditions of the cultures for all treatments.
#> 11 Characterisation of the microbe community.
#> 12 <NA>
#> 13 Length of the experiment in days. This should only include the time in which the measurements were taken!
#> 14 Additional features of the Experiment you want to provide
#> DATA dmdScheme v0.9.9
#> 1 ASR-expt1
#> 2 20
#> 3 semi-ambient
#> 4 ambient
#> 5 not given here
#> 6 Duran type bottle, red lids, 250ml
#> 7 100
#> 8 PPM
#> 9 0.55
#> 10 dirty
#> 11 initially unknown
#> 12 Wheat seeds added on specific dates, see file wheat_seed_additions.csv
#> 13 100
#> 14 <NA>
#>
#> $Genus
#> propertySet
#> 1 valueProperty
#> 2 unit
#> 3 type
#> 4 suggestedValues
#> 5 allowedValues
#> 6 Description
#> 7 DATA
#> 8 MULTIPLE ROWS
#> Genus
#> 1 speciesID
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 Id of the species and strain. Each speciesId has to be unique.
#> 7 tt_1
#> 8 unknown
#> ...3
#> 1 colour
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 Where the species was obtained from.
#> 7 ATCC
#> 8 unknown
#> ...4
#> 1 density
#> 2 cells / ml
#> 3 character
#> 4 treatment
#> 5 <NA>
#> 6 Initial density used for all treatments. If different between treatments, use "treatment" and specify in the Treatment sheet.
#> 7 1
#> 8 <NA>
#> ...5
#> 1 functionalGroup
#> 2 <NA>
#> 3 character
#> 4 bacteria, bacterivore, predator, phototroph
#> 5 <NA>
#> 6 Functional group of the species.
#> 7 bacterivore
#> 8 unknown
#> ...6
#> 1 comment
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> 7 http://www.lgcstandards-atcc.org/products/all/30007.aspx
#> 8 <NA>
#>
#> $Treatments
#> propertySet
#> 1 valueProperty
#> 2 unit
#> 3 type
#> 4 suggestedValues
#> 5 allowedValues
#> 6 Description
#> 7 DATA
#> 8 MULTIPLE ROWS
#> 9 <NA>
#> 10 <NA>
#> 11 <NA>
#> Treatments
#> 1 treatmentID
#> 2 <NA>
#> 3 character
#> 4 species, temperatur, light, initial density, comunity composition, densities, dispersal, viscosity, disturbance, communityType
#> 5 <NA>
#> 6 ID of the the treatment decribed in this a row. Each treatmentId can occur multiple times as it can contain multiple treatment levels.
#> 7 Lid_treatment
#> 8 Lid_treatment
#> 9 species_1
#> 10 species_2
#> 11 species_3
#> ...3
#> 1 treatmentLevelHeight
#> 2 <NA>
#> 3 character
#> 4 value, variable: freetext
#> 5 <NA>
#> 6 The value of the parameter if the parameter is constant over time, or a description of the variability. If unit is speciesId, comma separated list of all species in the treatment.
#> 7 Loose
#> 8 Tight
#> 9 tt_1, unknown
#> 10 unknown
#> 11 tt_1
#> ...4
#> 1 comment
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> 10 <NA>
#> 11 <NA>
#>
#> $Measurement
#> propertySet
#> 1 valueProperty
#> 2 unit
#> 3 type
#> 4 suggestedValues
#> 5 allowedValues
#> 6 Description
#> 7 DATA
#> 8 MULTIPLE ROWS
#> 9 <NA>
#> 10 <NA>
#> Measurement
#> 1 measurementID
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 Id of the Measurement process. This includes methodology, variables . Each measurementId specifies one Measurement process and must be unique in this column. Should be in the mapping column in the DataFileMetaData tab.
#> 7 oxygen concentration
#> 8 abundance
#> 9 smell
#> 10 sequenceData
#> ...3
#> 1 variable
#> 2 <NA>
#> 3 character
#> 4 O2 concentration, video, manual count, abundance, DNA
#> 5 <NA>
#> 6 The variable measured.
#> 7 DO
#> 8 abundance
#> 9 smell
#> 10 DNA
#> ...4 ...5
#> 1 method unit
#> 2 <NA> <NA>
#> 3 character character
#> 4 presens Optode, microscopy %, mmol, count
#> 5 <NA> <NA>
#> 6 Name of the method used. Unit of the measured variable
#> 7 presens Optode %
#> 8 molecular count
#> 9 nose rotten eggs or not
#> 10 NGS Nucleotide
#> ...6
#> 1 object
#> 2 <NA>
#> 3 character
#> 4 species, OUT, gene, community, particles
#> 5 <NA>
#> 6 The object measured. E.g. species in the case of manual count, gene for genetic analysis, particle for particle counters.
#> 7 community
#> 8 species
#> 9 community
#> 10 DNA fragment
#> ...7
#> 1 noOfSamplesInTimeSeries
#> 2 <NA>
#> 3 integer
#> 4 <NA>
#> 5 <NA>
#> 6 Total number of all samples in the time series.
#> 7 50
#> 8 6
#> 9 6
#> 10 6
#> ...8
#> 1 samplingVolume
#> 2 ml
#> 3 numeric
#> 4 <NA>
#> 5 <NA>
#> 6 The sampling volumne. If e.g. atmosphere in container is sampled (oxygen measurements), than enter 0.\r\nPlease use NA if sampling volumne is variable.
#> 7 0
#> 8 0.5
#> 9 0
#> 10 0
#> ...9
#> 1 dataExtractionID
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 as used in the sheet DataExtraction, column dataExtractionID
#> 7 none
#> 8 Mol_Analy_pipeline1
#> 9 none
#> 10 none
#> ...10
#> 1 measuredFrom
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 if measured from the experiment, raw, else the measurementId (first column) of the Measurement it is based on.
#> 7 raw
#> 8 sequenceData
#> 9 raw
#> 10 raw
#> ...11
#> 1 comment
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> 10 <NA>
#>
#> $DataExtraction
#> propertySet
#> 1 valueProperty
#> 2 unit
#> 3 type
#> 4 suggestedValues
#> 5 allowedValues
#> 6 Description
#> 7 DATA
#> 8 MULTIPLE ROWS
#> DataExtraction
#> 1 dataExtractionID
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 Name of the DataExtraction process. This includes methodology, variables . Each name specifies one extraction process and can occur multiple times in the case of multiple parameters in the analysis.
#> 7 Mol_Analy_pipeline1
#> 8 <NA>
#> ...3
#> 1 method
#> 2 <NA>
#> 3 character
#> 4 bemovi x.y.z
#> 5 <NA>
#> 6 Method used for the DataExtraction process. If possible including version (in the case of R packages).
#> 7 <NA>
#> 8 <NA>
#> ...4
#> 1 parameter
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 parameter in the analysis. Only needs to be specified if it varies from the default.
#> 7 <NA>
#> 8 <NA>
#> ...5
#> 1 value
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 value of the parameter (you can enter a number or a word)
#> 7 <NA>
#> 8 <NA>
#> ...6
#> 1 comment
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> 7 See description in file xxx.yyy
#> 8 <NA>
#>
#> $DataFileMetaData
#> propertySet DataFileMetaData
#> 1 valueProperty dataFileName
#> 2 unit <NA>
#> 3 type character
#> 4 suggestedValues <NA>
#> 5 allowedValues <NA>
#> 6 Description the name of the data set.
#> 7 DATA dissolved_oxygen_measures.csv
#> 8 MULTIPLE ROWS dissolved_oxygen_measures.csv
#> 9 <NA> dissolved_oxygen_measures.csv
#> 10 <NA> dissolved_oxygen_measures.csv
#> 11 <NA> dissolved_oxygen_measures.csv
#> 12 <NA> dissolved_oxygen_measures.csv
#> 13 <NA> dissolved_oxygen_measures.csv
#> 14 <NA> dissolved_oxygen_measures.csv
#> 15 <NA> dissolved_oxygen_measures.csv
#> 16 <NA> smell.csv
#> 17 <NA> smell.csv
#> 18 <NA> smell.csv
#> 19 <NA> smell.csv
#> 20 <NA> smell.csv
#> 21 <NA> abundances.csv
#> 22 <NA> abundances.csv
#> 23 <NA> abundances.csv
#> 24 <NA> abundances.csv
#> 25 <NA> abundances.csv
#> 26 <NA> abundances.csv
#> ...3
#> 1 columnName
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 Name of column in the data file. \r\nEach column in the data file needs to be documented!\r\nor NA\r\nif it is for the whole data file and not specified in the dataFileName
#> 7 Jar_ID
#> 8 DO
#> 9 Unit_1
#> 10 Mode
#> 11 Location
#> 12 Date_time
#> 13 Lid_treatment
#> 14 Jar_type
#> 15 Jar_ID
#> 16 <NA>
#> 17 smell
#> 18 Date
#> 19 Lid_treatment
#> 20 Jar_type
#> 21 <NA>
#> 22 Jar_ID
#> 23 Date_time
#> 24 Lid_treatment
#> 25 Jar_type
#> 26 count_number
#> ...4
#> 1 columnData
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 ID, Treatment, Measurement, Species, other
#> 6 The type of the data in the column.\r\nID: ID field (unique ID of unit of replication);\r\nTreatment: specifies treatment; \r\nMeasurement: contains measurements; \r\nSpecies: contains species; \r\nother: other type of data
#> 7 ID
#> 8 Measurement
#> 9 other
#> 10 other
#> 11 other
#> 12 other
#> 13 Treatment
#> 14 other
#> 15 ID
#> 16 Species
#> 17 Measurement
#> 18 other
#> 19 Treatment
#> 20 other
#> 21 Species
#> 22 ID
#> 23 other
#> 24 Treatment
#> 25 other
#> 26 Measurement
#> ...5
#> 1 mappingColumn
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 columnData = Treatment: \r\ntreatmentID as in the Treatment tab; \r\ncolumnData = Species: \r\ntreatmentID refering to species composition as in the Treatment tab\r\ncolumnData = Measurement: \r\nmeasurementID as in the Measurement tab; \r\notherwise:\r\nNA
#> 7 <NA>
#> 8 oxygen concentration
#> 9 <NA>
#> 10 <NA>
#> 11 <NA>
#> 12 <NA>
#> 13 Lid_treatment
#> 14 <NA>
#> 15 <NA>
#> 16 species_1
#> 17 smell
#> 18 <NA>
#> 19 Lid_treatment
#> 20 <NA>
#> 21 species_3
#> 22 <NA>
#> 23 <NA>
#> 24 Lid_treatment
#> 25 <NA>
#> 26 abundance
#> ...6
#> 1 type
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 integer, numeric, character, logical, datetime, date, time
#> 6 Type of the column.
#> 7 character
#> 8 numeric
#> 9 character
#> 10 character
#> 11 character
#> 12 datetime
#> 13 character
#> 14 character
#> 15 character
#> 16 character
#> 17 character
#> 18 datetime
#> 19 character
#> 20 character
#> 21 character
#> 22 character
#> 23 datetime
#> 24 character
#> 25 character
#> 26 numeric
#> ...7
#> 1 description
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 if column contains measurement: General description. If type is datatime, date, or time, give the order of year month day hour minute second as e.g. ymdhms, ymd, or hms. (Do not give any other information, e.g. give nothing about how months are entered (e.g. number or name), or how years, months, day, etc are separated.
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> 10 <NA>
#> 11 <NA>
#> 12 ymdhms
#> 13 <NA>
#> 14 <NA>
#> 15 <NA>
#> 16 <NA>
#> 17 <NA>
#> 18 ymdhms
#> 19 <NA>
#> 20 <NA>
#> 21 <NA>
#> 22 <NA>
#> 23 ymdhms
#> 24 <NA>
#> 25 <NA>
#> 26 <NA>
#> ...8
#> 1 comment
#> 2 <NA>
#> 3 character
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> 10 <NA>
#> 11 <NA>
#> 12 <NA>
#> 13 <NA>
#> 14 <NA>
#> 15 <NA>
#> 16 <NA>
#> 17 <NA>
#> 18 <NA>
#> 19 <NA>
#> 20 <NA>
#> 21 <NA>
#> 22 <NA>
#> 23 <NA>
#> 24 <NA>
#> 25 <NA>
#> 26 <NA>
#>
#> attr(,"dmdSchemeName")
#> [1] "dmdScheme"
#> attr(,"dmdSchemeVersion")
#> [1] "0.9.9"
#> attr(,"propertyName")
#> [1] "dmdScheme"
#> attr(,"fileName")
#> [1] "dmdScheme_0.9.9.xlsx"
#> attr(,"class")
#> [1] "dmdSchemeSet_raw" "list"