CSV Data Dictionary

Instructions

  1. Create a CSV data dictionary using the CSV_dd_templatearrow-up-right. You can create either: a. One data dictionary for each data file or b. One data dictionary representing all data files in your dataset

  2. See the CSV_dd_quick_guide for more details about completing the template

  3. Enter a new row in the data dictionary for each column/row name in your data matrix a. Use "*" wildcard when the description applies to multiple column/row names b. For example - if the same description applies to all spectra data column names in the data file(s) i. one row in the data dictionary can refer to "wave_*" and this definition will be understood to apply to multiple column names within a data sheet

  4. View an example CSV_dd_example

  5. Save the CSV_dd template following the CSV Reporting Format guidancearrow-up-right with the filename "dd.csv" or "*_dd.csv". Alternatively you may choose to name you data dictionary: a. With the same name as the associated data file, but include '_dd.csv' at the end of the file name b. Create a unique filename for your data dictionary c. Incorporate a wildcard into the filename if data dictionary applies to multiple data files (for example - "soil_cores_*_dd.csv")

Contents of the CSV_dd

For each variable provide the following:

  • Column or Row Name

  • Unit

  • Definition

  • Column or Row Long Name

  • Data Type

  • Missing Value Code

Notes

Following the recommended format and structure of the CSV Reporting Format will facilitate File Level Metadata extraction of some fields using the File Level Metadata Extractorarrow-up-right.

Last updated

Was this helpful?