The node is dedicated to ease the processing of microscope or plate reader data. It annotates meta information and/or layout data by a certain position in the plate. The meta information is provided by an Excel sheet which follows a specific formatting. The sheet can contain different layers of information (e.g. compound name, compound concentration, ...).
The first layer has to start at C5 in the Excel sheet. This position contains the layer name (used as
column
names in the output
table).The next row (starting at D6) contains the plate column numbers (1,2,3,...), while column 5
(starting
at C7) contains the
plate row identifier (A,B,C,... or 1,2,3,...). The dimensions are limited to 1536 well format (32 rows,
48
columns).
Dimensions have to be the same for all layers. Within the area defined by plate row and column
identifiers
cells can contain
metainformation of different data types (string, double, integer) or left empty.
The next layer starts again with its name in column C with a gap of 2 rows to the previous layer.
Each layer will result in a new column of the output table.
The input table has to provide two numeric columns representing the well position (plate row and plate
column). See
'Plate Row Converter' node to convert row identifiers (A,B,C,...) to its integer representation.
For a screen shot and a download of an example file look here:
HCS-Tools Wiki
Options
Popular Predecessors
Expand Well Position23 %File Reader15 %Concatenate (Optional in)11 %- Concatenate3 %
- File Reader3 %
- Column Filter3 %
- Plate Heatmap Viewer3 %
- Excel Reader3 %
- Expand Well Position2 %
- String to Number2 %
- Envision Reader2 %
CSV Reader2 %Row Splitter (deprecated)2 %Row Filter (deprecated)2 %- Math Formula2 %
- Join Layout2 %
- CSV Reader2 %
- Nominal Value Row Filter2 %
- Empty Table Creator1 %
- Example Data< 1 %
- Plate Row Converter< 1 %
- Load Layout< 1 %
- Expand Barcode< 1 %
- Java Edit Variable< 1 %
Number To String< 1 %- Equal Size Sampling< 1 %
Joiner< 1 %- Number to String< 1 %
- Column Resorter< 1 %
- Table Reader< 1 %
- Auto-Binner< 1 %
- Opera Reader< 1 %
- Operetta Reader< 1 %
Table Row To Variable Loop Start< 1 %Loop End< 1 %- Constant Value Column< 1 %
- GroupBy< 1 %
Column Rename< 1 %- String Manipulation< 1 %
- Create Well Position< 1 %
List Files< 1 %- Group Loop Start< 1 %
- Column Combiner< 1 %
- Nominal Value Row Splitter< 1 %
- Missing Value (Apply)< 1 %
- Numeric Row Splitter< 1 %
- String Replacer< 1 %
Excel Reader (XLS)< 1 %- Domain Calculator< 1 %
- Joiner< 1 %
- Sorter< 1 %
- Numeric Outliers (Apply)< 1 %
- Tika Parser< 1 %
Views
- This node has no views
Workflows
Links
- No links available
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.