Generates for each row of a given input table a bit vector. The bit vectors are either generated from
multiple numerical or string columns, a string column containing the bit positions to set, hexadecimal
or binary strings or a collection column. In order to adjust the node settings please select first the
source column object e.g. if the bit vector should be created from multiple string/numerical columns or
from a single string/collection column. Depending on the selected option the corresponding dialog
elements are enabled.
Bit vectors from a single column
In the case of a single input column only the selected single column to be parsed is considered for the generation of the bit vectors.Single string column
In the case of a string input only the column containing the string is considered for the generation of the bit vectors. The string is parsed and converted into a bit vector. There are three valid input formats which can be parsed and converted:- Hexadecimal strings: Strings consisting only of the characters 0-9 and A - F (where lower- or uppercase is not important). The represented hexadecimal number is converted into a binary number which is represented by the resulting bit vector.
- Binary strings: Strings consisting only of 0s and 1s are parsed and converted into the according bit vectors.
- ID strings: Strings consisting of numbers (separated by spaces) where the numbers refer to those positions in the bit vector which should be set. (Typical input format for association rule mining).
Single collection column
In the case of a single collection column each unique collection element gets a bit position assigned. The length of the bit vectors corresponds to the number of unique elements in a collection cells. For example if the input table contains two rows with the collections {a,b} and {b,c} the corresponding bit vectors will be [110] and [011].Bit vectors from multiple columns
In the case of multiple columns the bit positions in the resulting bit vector correspond to the column position in the input table. For example if the second and third column of a given input table is selected and the first column is omitted the bit vectors of each row will have length 2. The first bit of the bit vector is set if the value of the second column matches the selected criterion likewise the second bit of the bit vector is set if the value of the third column matches the selected criterion. The columns to consider when creating the bit vector can be specified in the multiple column selection section. Using the enforce exclusion/inclusion option the node can be configured to handle previously unknown columns. If the enforce exclusion option is selected all unknown columns are added automatically to the include list whereas if the enforce inclusion option is selected all unknown columns are added to the exclude list. The columns to include can be also defined by a pattern if the Wildcard/Regex Selection option is selected.Multiple string columns
The bit of a vector is set if the corresponding column value does match/does not match the specified pattern depending on the "Set bit if pattern does match/does not match" option. The pattern may contain wildcards such as '?' or '*' to match any one character or any sequence (including none) of characters. It can also be a complex regular expression.Multiple numeric columns
There are two options to determine if the bit is set for the value in the corresponding column or not:- Either a global threshold is defined, then all values which are above or equal to the threshold are converted into set bits, all other bit positions remain 0, or
- A certain percentage of the mean of each column is used as a threshold, then all values which are above or equal to the percentage of the mean are converted into set bits. As an example let's say the mean percentage is set to 50% and the mean of col1 is 2 and the mean of col2 is 8. Then the corresponding bit for col1 is set if the value is above or equal to 1 and for col2 if the value is above or equal to 4.
Missing values
For numeric data the incoming missing values will result in 0s. For multiple string columns a missing values will also result in 0s. For the string input missing values will also result in a missing value in the output table. If a string could not be parsed it will also result in a missing cell in the output table and an error message with detailed information is printed in the console. For a collection column all missing collection elements are ignored.Options
Popular Predecessors
Excel Reader (XLS)18 %Cell Splitter7 %XLS Reader4 %Number To String3 %Database Reader3 %String To Number2 %Excel Reader (XLS)2 %File Reader2 %- Constant Value Column Filter1 %
- String Replacer1 %
- Sorter1 %
Column Appender< 1 %- Column Merger< 1 %
Table Reader< 1 %- Fuzzy Rule Learner< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Column Aggregator< 1 %
- Fingerprints< 1 %
- Java Snippet< 1 %
Document vector< 1 %Numeric Row Splitter (deprecated)< 1 %- Concatenate< 1 %
- Java Snippet (simple)< 1 %
- Category to Number< 1 %
- Column Resorter< 1 %
Column Rename< 1 %- Table View (JavaScript) (legacy)< 1 %
Python Script (1⇒1)< 1 %- CDK to Molecule< 1 %
- Item Set Finder (Borgelt)< 1 %
- Chemical Fingerprint< 1 %
Column Splitter< 1 %- Rule Engine< 1 %
- String to Number< 1 %
- Column Renamer< 1 %
- Group Loop Start< 1 %
- Missing Value< 1 %
- String Manipulation< 1 %
- Strings to Document< 1 %
- RDKit Substructure Counter< 1 %
- TF< 1 %
- File Reader (Complex Format)< 1 %
CSV Reader< 1 %- Math Formula< 1 %
- Value Counter< 1 %
- Similarity Search< 1 %
- Column Appender< 1 %
- RDKit Descriptor Calculation< 1 %
Table Creator< 1 %Auto-Binner< 1 %- Row Sampler< 1 %
- Ungroup< 1 %
- Rule-based Row Filter< 1 %
- Rule-based Row Splitter< 1 %
- Statistics< 1 %
- Math Formula (Multi Column)< 1 %
- Category to Class< 1 %
- Punctuation Erasure< 1 %
- Document Vector< 1 %
- Column Renamer (Dictionary)< 1 %
- Double to Integer< 1 %
- Extract Table Spec< 1 %
- Molecular Properties< 1 %
- Columns to Collection< 1 %
- Split Collection Column< 1 %
Scorer< 1 %- Association Rule Learner< 1 %
- Numeric Binner< 1 %
- Create Bit Vector< 1 %
- Expand Bit Vector< 1 %
- Expand Byte Vector< 1 %
- One to Many< 1 %
- Column Filter< 1 %
- Reference Column Filter< 1 %
- Nominal Value Row Filter< 1 %
Row Splitter (deprecated)< 1 %Row Filter (deprecated)< 1 %- GroupBy< 1 %
- Normalizer< 1 %
- Pivot< 1 %
- RowID< 1 %
- Table Transposer< 1 %
SDF Reader< 1 %- RDKit Fingerprint< 1 %
- Cell Splitter< 1 %
- Number to String< 1 %
- Filter Apply< 1 %
Excel Reader (XLS)< 1 %- Document Vector Applier< 1 %
- Column Filter (legacy)< 1 %
- CSV Reader< 1 %
- Linear Correlation< 1 %
- Joiner< 1 %
- Excel Reader< 1 %
Date&Time Difference< 1 %- Table Row to Variable< 1 %
Database Looping< 1 %- Loop End (Column Append)< 1 %
- Column Combiner< 1 %
- Column Name Replacer< 1 %
- Table Structure Creator< 1 %
- Edit Nominal Domain< 1 %
- Missing Value Column Filter< 1 %
Number To String (PMML)< 1 %- Unpivot< 1 %
- R Snippet< 1 %
- Fingerprint Similarity< 1 %
Cell Replacer< 1 %- Cross Joiner< 1 %
- IDF< 1 %
- String Manipulation (Multi Column)< 1 %
- MolConverter< 1 %
- Create Byte Vector< 1 %
- Table Partitioner< 1 %
- One to Many (PMML)< 1 %
- Reference Column Resorter< 1 %
Color Manager< 1 %- Distance Matrix Calculate< 1 %
Read Excel Sheet Names (XLS)< 1 %List Files< 1 %- Fuzzy c-Means< 1 %
- Decision Tree Predictor< 1 %
Double To Int< 1 %- Missing Value (Apply)< 1 %
String To Number (PMML)< 1 %- Conditional Box Plot (legacy)< 1 %
- Column Expressions (legacy)< 1 %
- Density< 1 %
- Collection Size< 1 %
- Table Manipulator< 1 %
Database Connection Table Reader< 1 %k-Means (deprecated)< 1 %Auto-Binner (Apply)< 1 %- Number to Category (Apply)< 1 %
Constant Value Column< 1 %- Table Validator< 1 %
- Reference Row Filter< 1 %
Joiner< 1 %- Normalizer (Apply)< 1 %
String Replace (Dictionary)< 1 %- Molecule Type Cast< 1 %
Stop Word Filter< 1 %Bag of Words Creator< 1 %Document vector hashing< 1 %MongoDB Reader< 1 %- RDKit Molecule Substructure Filter< 1 %
- Fingerprint to String< 1 %
- Strings to Binary Objects< 1 %
- Column List Loop Start< 1 %
- X-Partitioner< 1 %
- Hierarchical Clustering< 1 %
- Bootstrap Sampling< 1 %
- Low Variance Filter< 1 %
- Number Rounder< 1 %
- Fingerprint Bayesian Learner< 1 %
- Counter Generation< 1 %
- OpenBabel< 1 %
- Word Vector Apply (legacy)< 1 %
- Double Input (legacy)< 1 %
- RDKit Count-Based Fingerprint< 1 %
- Variable to Table Row< 1 %
- Molecule to CDK< 1 %
- Substructure Match Counter< 1 %
- Substructure Matcher< 1 %
- MarvinSketch< 1 %
- ARFF Reader< 1 %
Loop End< 1 %Counting Loop Start< 1 %k-Means (deprecated)< 1 %- SMOTE< 1 %
- Cell Splitter By Position< 1 %
- Column to Grid< 1 %
- Domain Calculator< 1 %
- Subset Matcher< 1 %
CASE Switch Data (Start)< 1 %- Case Converter< 1 %
- Bag Of Words Creator< 1 %
- Document Data Extractor< 1 %
- Term Vector< 1 %
- Duplicate Filter< 1 %
- Speedy SMILES De-salt< 1 %
- Fingerprint to Binary String< 1 %
- Fingerprint to Set Bits List< 1 %
- PNGs to Binary Objects< 1 %
- Breakpoint< 1 %
Variable to Table Column< 1 %Table Row To Variable Loop Start< 1 %- CSV Array Reader< 1 %
Database Pivot< 1 %Line Reader< 1 %Backward Feature Elimination Start (1:1)< 1 %- Chunk Loop Start< 1 %
- Cluster Assigner< 1 %
PCA Apply< 1 %- Logistic Regression Learner< 1 %
- Constant Value Row Appender< 1 %
Concatenate (Optional in)< 1 %- Category to Number (Apply)< 1 %
- Many to One< 1 %
Linear Correlation< 1 %- Extract Missing Value Cause< 1 %
- Nominal Value Row Splitter< 1 %
- Column Filter (PMML)< 1 %
- Normalizer (PMML)< 1 %
- Number to String (PMML)< 1 %
- String Splitter (Regex)< 1 %
- String Manipulation (Variable)< 1 %
- Decision Tree to Ruleset< 1 %
- Ruleset Editor< 1 %
- Ruleset to Table< 1 %
- Cache< 1 %
- Data Generator< 1 %
- Crosstab< 1 %
Parquet Reader< 1 %- External Tool< 1 %
- Geo-Coordinate Row Filter< 1 %
- Vocabulary Extractor (legacy)< 1 %
- Term Co-Occurrence Counter< 1 %
- Number Filter< 1 %
- Tika Parser< 1 %
Document Data Extractor< 1 %- Document Vector Hashing Applier< 1 %
Meta Info Inserter< 1 %- String to Term< 1 %
- Google Sheets Reader< 1 %
- Column Selection (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- JSON Column Combiner< 1 %
- Container Input (Table)< 1 %
JSON Reader< 1 %- Moving Aggregator< 1 %
String to Date/Time< 1 %XML Reader< 1 %- Discretise< 1 %
- 3D WHIM< 1 %
- RDKit From Molecule< 1 %
- Binary Objects to Strings< 1 %
- Loop End< 1 %
- Column Comparator< 1 %
- String to Number (PMML)< 1 %
- Rank< 1 %
- Rule Engine (Dictionary)< 1 %
Oracle Connector< 1 %- DF< 1 %
- Dictionary Replacer< 1 %
- Stanford Lemmatizer< 1 %
- Meta Info Extractor< 1 %
- Tags to String< 1 %
- Path to String< 1 %
- RDKit Find Murcko Scaffolds< 1 %
Views
- Statistics View
- Provides information about the generation of the bit vectors from the data. In particular this is the number of processed rows, the total number of generated zeros and ones and the resulting ratio of 1s to 0s.
Workflows
00_Topic_Modeling_with_Verified_ComponentsKNIME Hub- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 01_ClusteringKNIME Hub
- 02_Topic_Scoring_ExampleKNIME Hub
- 02_Topic_Scoring_ExampleKNIME Hub
- Show all 90 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.