# HG changeset patch
# User ecology
# Date 1748427136 0
# Node ID 4da00cf0271994b60ffb0ab5e45302b2c6171dad

planemo upload for repository https://github.com/jeanlecras/tools-ecology/tree/master/tools/WormsMeasurements commit ced658540f05bb07e1e687af30a3fa4ea8e4803c

diff -r 000000000000 -r 4da00cf02719 test-data/enriched_data.tabular
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/enriched_data.tabular	Wed May 28 10:12:16 2025 +0000
@@ -0,0 +1,11 @@
+"decimalLatitude"	"decimalLongitude"	"scientificName"	"Development"	"Fecundity"
+-49.355	70.215	"Abatus cordatus"	NA	NA
+-66.963303	163.223297	"Ctenocidaris spinosa"	NA	NA
+-42.45	-74.75833333	"Loxechinus albus"	NA	NA
+-37.606167	176.705167	"Ogmocidaris benhami"	NA	NA
+-36.201698	175.834198	"Peronella hinemoae"	NA	NA
+-37.494667	176.672501	"Phormosoma bursarium"	NA	NA
+-43.469	173.572	"Pseudechinus huttoni"	NA	NA
+-47.7	179.45	"Pseudechinus novaezealandiae"	NA	NA
+-74.72	164.2183333	"Sterechinus neumayeri"	NA	NA
+-70.51166667	-8.801	"Sterechinus sp"	NA	NA
diff -r 000000000000 -r 4da00cf02719 test-data/enriched_data_inherited.tabular
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/enriched_data_inherited.tabular	Wed May 28 10:12:16 2025 +0000
@@ -0,0 +1,11 @@
+"decimalLatitude"	"decimalLongitude"	"scientificName"	"Development"	"Fecundity"
+-49.355	70.215	"Abatus cordatus"	"planktotrophic"	NA
+-66.963303	163.223297	"Ctenocidaris spinosa"	"direct development"	NA
+-42.45	-74.75833333	"Loxechinus albus"	"planktotrophic"	NA
+-37.606167	176.705167	"Ogmocidaris benhami"	"planktotrophic"	NA
+-36.201698	175.834198	"Peronella hinemoae"	"planktotrophic"	NA
+-37.494667	176.672501	"Phormosoma bursarium"	"planktotrophic"	NA
+-43.469	173.572	"Pseudechinus huttoni"	"planktotrophic"	NA
+-47.7	179.45	"Pseudechinus novaezealandiae"	"planktotrophic"	NA
+-74.72	164.2183333	"Sterechinus neumayeri"	"planktotrophic"	NA
+-70.51166667	-8.801	"Sterechinus sp"	NA	NA
diff -r 000000000000 -r 4da00cf02719 test-data/enriched_data_inherited_ohe.tabular
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/enriched_data_inherited_ohe.tabular	Wed May 28 10:12:16 2025 +0000
@@ -0,0 +1,11 @@
+"decimalLatitude"	"decimalLongitude"	"scientificName"	"Fecundity"	"Development_direct development"	"Development_planktotrophic"
+-49.355	70.215	"Abatus cordatus"	NA	0	1
+-66.963303	163.223297	"Ctenocidaris spinosa"	NA	1	0
+-42.45	-74.75833333	"Loxechinus albus"	NA	0	1
+-37.606167	176.705167	"Ogmocidaris benhami"	NA	0	1
+-36.201698	175.834198	"Peronella hinemoae"	NA	0	1
+-37.494667	176.672501	"Phormosoma bursarium"	NA	0	1
+-43.469	173.572	"Pseudechinus huttoni"	NA	0	1
+-47.7	179.45	"Pseudechinus novaezealandiae"	NA	0	1
+-74.72	164.2183333	"Sterechinus neumayeri"	NA	0	1
+-70.51166667	-8.801	"Sterechinus sp"	NA	NA	NA
diff -r 000000000000 -r 4da00cf02719 test-data/sample.tabular
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/sample.tabular	Wed May 28 10:12:16 2025 +0000
@@ -0,0 +1,11 @@
+"decimalLatitude"	"decimalLongitude"	"scientificName"
+-66.963303	163.223297	"Ctenocidaris spinosa"
+-70.51166667	-8.801	"Sterechinus sp"
+-37.494667	176.672501	"Phormosoma bursarium"
+-37.606167	176.705167	"Ogmocidaris benhami"
+-74.72	164.2183333	"Sterechinus neumayeri"
+-47.7	179.45	"Pseudechinus novaezealandiae"
+-49.355	70.215	"Abatus cordatus"
+-36.201698	175.834198	"Peronella hinemoae"
+-43.469	173.572	"Pseudechinus huttoni"
+-42.45	-74.75833333	"Loxechinus albus"
diff -r 000000000000 -r 4da00cf02719 wormsmeasurements.R
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/wormsmeasurements.R	Wed May 28 10:12:16 2025 +0000
@@ -0,0 +1,131 @@
+##05/05/2025
+##Jean Le Cras
+### Enrich dataset with data from WoRMS
+
+#load libraries
+library(tidyverse)
+library(worrms)
+library(fastDummies)
+
+### parameters
+args <- commandArgs(trailingOnly = TRUE)
+if (length(args) == 0) {
+    stop("This tool needs at least one argument")
+}
+
+scientificName_name <- args[3]
+occurrence <- read.csv(args[1], header=T, sep="\t") %>% 
+  arrange(.[[scientificName_name]])
+measurement_types <- unlist(str_split(args[2], ","))
+include_inherited <- ifelse(args[4]=="true", T, F)
+pivot_wider <- ifelse(args[5]=="true", T, F)
+exclude_NA <- ifelse(args[6]=="true", T, F)
+
+# regex to only keep genus and specific epithet from scientific names
+regex_find <- "^([A-Z][^A-Z(]+)(.*)$"
+regex_replace <- "\\1"
+
+
+# function to extract the measurement values from the attributes data tibble
+extract_traits_values <- function(traits_data) {
+  result <- setNames(rep(NA, length(measurement_types)), measurement_types)
+  
+  if (is.null(traits_data) || nrow(traits_data) == 0) {
+    return(result)
+  }
+  
+  traits_filtered <- traits_data %>%
+    filter(measurementType %in% measurement_types) %>%
+    filter(!is.na(measurementValue))
+  
+  if (nrow(traits_filtered) == 0) {
+    return(result)
+  }
+  
+  for (i in 1:nrow(traits_filtered)) {
+    result[traits_filtered$measurementType[i]] <- traits_filtered$measurementValue[i]
+  }
+  return(result)
+}
+
+# function to call the call the WoRMS API and get the measurement values
+get_life_history_traits <- function(scientific_name) {
+  clean_scientific_name <- trimws(gsub(regex_find, regex_replace, scientific_name))
+
+  if (clean_scientific_name %in% names(cache)) { 
+    return(cache[[clean_scientific_name]])  
+  }
+  
+  worms_id <- tryCatch(
+    wm_name2id(name = clean_scientific_name),
+    error = function(e) NA
+  )
+  
+  if (is.na(worms_id) || length(worms_id) == 0) {
+    cache[[clean_scientific_name]] <<- NULL
+    return(NULL)
+  }
+  
+  data_attr <- tryCatch(
+    wm_attr_data(worms_id, include_inherited=include_inherited),
+    error = function(e) NULL
+  )
+  
+  if (is.null(data_attr)) {
+    cache[[clean_scientific_name]] <<- NULL
+    return(NULL)
+  }
+  
+  traits <- extract_traits_values(data_attr)
+  cache[[clean_scientific_name]] <<- traits
+  return(traits)
+}
+
+# a cache to limit API calls
+cache <- list()
+
+# add a columns conataining the lists of values of the measurments requested
+trait_data <- occurrence %>%
+  mutate(life_history_traits = map(.data[[scientificName_name]], ~ get_life_history_traits(.x)))
+
+# convert the column of lists to multiple columns of unique values
+trait_data <- trait_data %>%
+  unnest_wider(life_history_traits)
+
+# make sur each measurement type has a column
+for (col in measurement_types) {
+  if (!(col %in% names(trait_data))) {
+    trait_data[[col]] <- NA
+  }
+}
+
+# list of quantitativ measurements
+numeric_cols <- c()
+
+# try to convert columns to numeric and remember them
+trait_data <- trait_data %>%
+  mutate(across(all_of(measurement_types), ~ {
+    numeric_col <- suppressWarnings(as.numeric(.))
+    if (all(is.na(.) == is.na(numeric_col))) {
+      numeric_cols <<- c(numeric_cols, cur_column())
+      numeric_col
+    } else {
+      .
+    }
+  }))
+
+# filter NA but only in the added columns
+if (exclude_NA) {
+  trait_data <- trait_data[complete.cases(trait_data[, measurement_types]),]
+}
+
+# determine what are the qualitativ columns to be one hot encoded
+factor_cols <- setdiff(measurement_types, numeric_cols)
+
+# one hot encode quantitativ columns
+if (pivot_wider & length(factor_cols) > 0) {
+  trait_data <- dummy_cols(trait_data, select_columns = factor_cols, remove_selected_columns=T, ignore_na=T)
+}
+
+# write the enriched dataset as tabular
+write.table(trait_data, "enriched_data.tabular", sep="\t", row.names = FALSE)
\ No newline at end of file
diff -r 000000000000 -r 4da00cf02719 wormsmeasurements.xml
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/wormsmeasurements.xml	Wed May 28 10:12:16 2025 +0000
@@ -0,0 +1,127 @@
+<tool id="WormsMeasurements" name="Enrich dataset with WoRMS" version="0.1.2" profile="23.2">
+    <description>Enrich dataset with measurement type data from WoRMS</description>
+
+    <requirements>
+        <requirement type="package" version="4.3.3">r-base</requirement>
+        <requirement type="package" version="0.4.3">r-worrms</requirement>
+        <requirement type="package" version="1.1.4">r-dplyr</requirement>
+        <requirement type="package" version="2.0.0">r-tidyverse</requirement>
+        <requirement type="package" version="1.7.5">r-fastDummies</requirement>
+    </requirements>
+
+    <command detect_errors="exit_code"><![CDATA[
+Rscript '$__tool_directory__/wormsmeasurements.R'
+    '$data'
+    '$measurement_types'
+    '$scientic_name'
+    '$include_inherited'
+    '$pivot_wider'
+    '$exclude_NA'
+    '$output'
+    ]]></command>
+
+    <inputs>
+        <param name="data" type="data" format="tabular" label="occurrence data"/>
+        <param name="measurement_types" type="text" format="txt" label="list of measurement types">
+        </param>
+        <param name="scientic_name" type="text" format="txt" label="scientific names column name" value="scientificName" optional="false">
+            <validator type="regex" message="this field can't be empty">.+</validator>
+        </param>
+        <param name="include_inherited" type="boolean" label="include attributes inherited from parent taxon" checked="false"/>        
+        <param name="pivot_wider" type="boolean" label="one hot encoding on the measurement types" checked="false"/>
+        <param name="exclude_NA" type="boolean" label="exclude lines with missing values (NA)" checked="false"/>
+    </inputs>
+
+    <outputs>
+        <data name="output" from_work_dir="enriched_data.tabular" format="tabular" label="dataset enriched with measurments"/>
+    </outputs>
+
+    <tests>
+        <test>
+            <param name="data" value="sample.tabular"/>
+            <param name="measurement_types" value="Development,Fecundity"/>
+            <param name="scientic_name" value="scientificName"/>
+            <param name="include_inherited" value="true"/>
+            <param name="pivot_wider" value="false"/>
+            <param name="exclude_NA" value="false"/>
+            <output name="output" file="enriched_data_inherited.tabular"/>
+        </test>
+        <test>
+            <param name="data" value="sample.tabular"/>
+            <param name="measurement_types" value="Development,Fecundity"/>
+            <param name="scientic_name" value="scientificName"/>
+            <param name="include_inherited" value="false"/>
+            <param name="pivot_wider" value="false"/>
+            <param name="exclude_NA" value="false"/>
+            <output name="output" file="enriched_data.tabular"/>
+        </test>
+        <test>
+            <param name="data" value="sample.tabular"/>
+            <param name="measurement_types" value="Development,Fecundity"/>
+            <param name="include_inherited" value="true"/>
+            <param name="scientic_name" value="scientificName"/>
+            <param name="pivot_wider" value="true"/>
+            <param name="exclude_NA" value="false"/>
+            <output name="output" file="enriched_data_inherited_ohe.tabular"/>
+        </test>
+    </tests>
+
+    <help><![CDATA[
+==================    
+**What it does ?**
+==================
+
+This tool requests WoRMS (World Register of Marine Species) to get data about a specific by accessing the entry returned by an its scientific name, it looks for the measurementType(s) requested by the user and select the associated measurement value to add it to a dataset.
+
+===================         
+**How to use it ?**
+===================
+
+## Parameters:
+
+- **data**: a dataset containing a variable of scientific names.
+- **list of measurement types**: a list of measurements types present in WoRMS (ex: Development, Fecundity, Size ...) separated by ','.
+- **scientific names column name**: the name of column in the dataset containing scientific names.
+- **include attributes inherited from parent taxon**: usefull when the data you are looking for are incomplete.
+- **one hot encoding on the measurement types**: each possible values of a measurementType becomes a column encoded in 0/1
+- **exclude_NA**: exclude lines with missing measurement value
+
+## Outputs:
+
+The inputed dataset with columns of measurement types or measurements
+
+**Example of input data :**
+"decimalLatitude"	"decimalLongitude"	"scientificName"
+-49.355	70.215	"Abatus cordatus"	"planktotrophic"	NA
+-66.963303	163.223297	"Ctenocidaris spinosa"
+-42.45	-74.75833333	"Loxechinus albus"
+-37.606167	176.705167	"Ogmocidaris benhami"
+-36.201698	175.834198	"Peronella hinemoae"
+-37.494667	176.672501	"Phormosoma bursarium"
+-43.469	173.572	"Pseudechinus huttoni"
+-47.7	179.45	"Pseudechinus novaezealandiae"
+-74.72	164.2183333	"Sterechinus neumayeri"
+-70.51166667	-8.801	"Sterechinus sp"
+
+**Example of output data :**
+"decimalLatitude"	"decimalLongitude"	"scientificName"	"Development"	" Fecundity"
+-49.355	70.215	"Abatus cordatus"	"planktotrophic"	NA
+-66.963303	163.223297	"Ctenocidaris spinosa"	"direct development"	NA
+-42.45	-74.75833333	"Loxechinus albus"	"planktotrophic"	NA
+-37.606167	176.705167	"Ogmocidaris benhami"	"planktotrophic"	NA
+-36.201698	175.834198	"Peronella hinemoae"	"planktotrophic"	NA
+-37.494667	176.672501	"Phormosoma bursarium"	"planktotrophic"	NA
+-43.469	173.572	"Pseudechinus huttoni"	"planktotrophic"	NA
+-47.7	179.45	"Pseudechinus novaezealandiae"	"planktotrophic"	NA
+-74.72	164.2183333	"Sterechinus neumayeri"	"planktotrophic"	NA
+-70.51166667	-8.801	"Sterechinus sp"	NA	NA
+
+]]></help>
+
+    <citations>
+        <citation type="doi">10.32614/CRAN.package.dplyr</citation>
+        <citation type="doi">10.32614/CRAN.package.tidyverse</citation>
+        <citation type="doi">10.32614/CRAN.package.worrms</citation>
+        <citation type="doi">10.32614/CRAN.package.fastDummies</citation>
+    </citations>
+</tool>