Up: Component summary Component

Labels2Columns

Reads columns of data, the unique entries of the label column are transposed as column names. Respective values are copied in each column. The resulting CSV file also contains a row ID column as the first column, to enable direct compatibility with StatisticalTest component.

Version 1.1
Bundle tools
Categories Convert
Authors Ville Rantanen (ville.rantanen@helsinki.fi), Sirkku Karinen (Sirkku.Karinen@significo.fi)
Issue tracker View/Report issues
Requires python
Source files component.xml LabelsToColumns.py
Usage Example with default values

Inputs

Name Type Mandatory Description
in CSV Mandatory A CSV file with column entries and their values.

Outputs

Name Type Description
out CSV Data converted to columns. Extra rows are padded with NaNs.

Parameters

Name Type Default Description
label string (no default) Column name to fetch resulting columns names from.
order string "" Order list for the unique groups e.g. "3,2,1". Note, only numbers and commas allowed.
removeDuplicates boolean false If true, removes those columns that contain exactly the same values.
useRowId boolean true Created column with unique row identification.
useValueName boolean true Created column names are named [values]_[columns].
valueNameSeparator string "_" String used to separate value and column name if useValueName is set true.
values string (no default) Column name to fetch values. Also a comma separated list of value column names is accepted.

Test cases

Test case Parameters▼ IN
in		 OUT
out
case1 properties in out

label=clusterId,
values=Mean,
useValueName=true,
valueNameSeparator=+
case2 properties in out

label=clusterId,
values=Mean,StDev,
useValueName=false,
order =
case3 properties in out

label=clusterId,
values=Mean,
useValueName=false,
useRowId = false
case4_removeDuplicates properties in out

label=Tests,
values=Gene,Value,
useValueName=false,
useRowId = false,
removeDuplicates=true
case5_removeDuplicates properties in out

label=Tests,
values=Gene,Value,
useValueName=false,
useRowId = false,
removeDuplicates=true
Generated 2019-02-08 07:42:18 by Anduril 2.0.0