/WiscSIMSDataExtractor

Package for extracting data from WiscSIMS archive and

Primary LanguageRGNU General Public License v3.0GPL-3.0

WiscSIMSDataExtractor

Package for extracting data from WiscSIMS laboratory archival excel files and reformatting it for import into the Sparrow data system.

Funding support

Sparrow

NSF-1740694

WiscSIMS

Current functions

  1. ColumnRename()

    Standardizes column names using a lookup table based on observation of the SIMS archive.

  2. GeneralSIMSImporter()

    Uses ColumnRename() and associated code to standardize the excel tables and prepare them for import into Sparrow. This is a useful stand alone function for quickly opening and browsing SIMS data and is the core of the SessionSummary.Rmd document.

  3. SparrowReformater()

    Creates a JSON file and uses a PUT() to hand the file over to Sparrow. Additional code for implementation in docker with Sparrow is in WiscSIMS-Sparrow github repository.

Improvements to make...

  • Make BracketRecalculate() a stand alone function
  • Make MountID() a stand alone function
  • Make SessionSummary() markdown document a stand alone function
  • Make lookup tables as dataframes within the package.
  • Add more documentation and finish packaging the functions.
  • Refine error handling and reporting.