Metadata Catalogue Metadata Catalogue https://metadatacatalogue.lifewatch.eu/ https://metadatacatalogue.lifewatch.eu//srv/eng/portal.opensearch https://metadatacatalogue.lifewatch.eu//srv/eng/rdf.search?any= eng Continents, countries, sea regions of the world. https://metadatacatalogue.lifewatch.eu//srv/eng/thesaurus.download?ref=external.place.regions ecoportal.fos_1.rdf https://metadatacatalogue.lifewatch.eu//srv/eng/thesaurus.download?ref=external.ecoportal.fos application/xml XML text/html HTML d9fc8450-10d0-4774-92af-257a1fc4e488 Biodiversity data from excel retriever This is a NaaVRE workflow component / building block written in R that retrieves, validates, and saves biodiversity data and metadata from an Excel file for further processing. If the input file is not found in either location, the script stops with an error. It reads two sheets from the Excel file: Metadata and Data. It defines required columns for both data and metadata and checks if all required columns are present in the dataframes. If columns are missing or extra columns are present, the script stops with an error message. Finally, it writes the metadata and data to separate CSV files (metadata.csv and data.csv) in the temporary directory. R Excel to CSV data management data validation Marco-Bolo WWW:LINK-1.0-http--link https://github.com/QCDIS/Biodiversity_time_series_analyses_from_European_marine_ecosystems/blob/main/codebase/Data_cleaning_analysis_Example_1_03.ipynb WWW:LINK-1.0-http--link https://beta.naavre.net/jupyter/hub/user-redirect/lab/tree/Virtual%20Labs/Biodiversity%20Time%20Series%20Analyses/Git%20public/workflows/Biodiversity_time_series_analyser.naavrewf?profile=biotisan-euromarec license Senckenberg Society For Nature Research Andrés Peredo Arce