[Generated by Task Expert Agent]

ResourceSet to Data Table

Transforms a ResourceSet (output from Quality Check tasks) into a Table organized by batch/sample pairs.

Description

This task extracts data from a ResourceSet containing multiple Table resources (one per batch/sample). It creates a unified table where:

• The first column is the index column (e.g., temperature, time)
• Each subsequent column represents a batch/sample pair (named "Batch_Sample")
• Column values are taken from the selected data column

Inputs

• resource_set: ResourceSet containing Table resources with batch/sample tags

Configuration

• index_column: Column name to use as the table index (e.g., "Temp", "Time")
• data_column: Column name containing the data to extract (e.g., "Biomasse", "pH")

Output

• data_table: Table with index column and one column per batch/sample pair

Usage Example

Given a ResourceSet with 3 tables (Batch1_Sample1, Batch1_Sample2, Batch2_Sample1), each containing columns [Time, Biomasse, pH], selecting:

• index_column = "Time"
• data_column = "Biomasse"

Will produce a table:

Time | Batch1_Sample1 | Batch1_Sample2 | Batch2_Sample1
-----|----------------|----------------|---------------
0    | 0.1            | 0.12           | 0.11
24   | 0.5            | 0.48           | 0.52
48   | 1.2            | 1.15           | 1.25

Notes

• Batch and sample information is extracted from resource tags
• Missing values (NaN) in the index column are automatically removed
• Tables are merged using outer join to preserve all time points
• Final table is sorted by the index column