DIGITAL.CSIC. Repositorio Institucional del CSIC
Publication
Otros (Other)
Excel to WHP-Exchange Bottle file converter tool
This tool was developed for helping users to generate a properly formatted WHP-Exchange format file, automatically doing the following:
- Generating BOTTLE tag
- Including and commenting metadata
- Generating header and units line
- Fixing known paramenters to recommended precision decimals
- Setting END_BOTTLE tag
Can be used by calling python file or notebook locally or by launching the notebook through COLAB
Excel file needs to have the following format:
- FIRST (from the left) sheet has to contain the table of data WITH header names in 1st row, units in 2nd one and data below
- SECOND (from the left) sheet has to contain the metadata as text (if any) or be an empty sheet
if python file is called directly, please use the following format: excel2whpexchange.py [file_name] [institution]
- file_name will be the spreadsheet
- institution will be the identificator for creator institution or user as recommended by WHP-Exchange
example for me: $ python excel2whpexchange.py cruisefile.xlsx CSICIIMAVL, Small tool to convert an spreadsheet Excel (.xlsx) or LibreOffice (.ods) file to WOCE WHP-Exchange format (BOTTLE), This software was supported by the BOCATS2 Project (grant no. PID2019-104279GB-C21) funded by the Spanish Government and is a contribution of the CSIC Interdisciplinary Thematic Platform (PTI) WATER:iOS.
European Commission, COMFORT - Our common future ocean in the Earth system – quantifying coupled cycles of carbon, oxygen, and nutrients for determining and achieving safe operating spaces with respect to tipping points, 820989, Peer reviewed