This node takes columns with nominal data and maps every category to an integer. For your convenience, you can process multiple columns with this node. However, these columns are processed separately as if you would use a single Category To Number node for every column.
Options
Popular Predecessors
- Column Filter7 %
- CSV Reader6 %
- Missing Value5 %
- Excel Reader5 %
- Rule Engine3 %
Row Filter (deprecated)2 %- String to Number2 %
- Numeric Outliers2 %
XLS Reader2 %- Number to String1 %
- Normalizer1 %
Excel Reader (XLS)1 %- Auto-Binner1 %
Column Appender1 %Cell Splitter1 %- One to Many1 %
- Category to Number1 %
Linear Correlation1 %- GroupBy< 1 %
- Duplicate Row Filter< 1 %
Joiner< 1 %- Statistics< 1 %
- Cell Splitter< 1 %
- Joiner< 1 %
- String Manipulation< 1 %
- Column Renamer< 1 %
- Sorter< 1 %
File Reader< 1 %- Column Resorter< 1 %
- Row Sampling< 1 %
- Math Formula< 1 %
- File Reader< 1 %
- Numeric Binner< 1 %
- Rule-based Row Filter< 1 %
- Python Source (legacy)< 1 %
Extract Date&Time Fields< 1 %- Number Rounder< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Concatenate< 1 %
- Domain Calculator< 1 %
String To Number (PMML)< 1 %Column Rename< 1 %- Color Manager< 1 %
- URL to File Path< 1 %
Excel Reader (XLS)< 1 %- Column Appender< 1 %
String Replace (Dictionary)< 1 %- Value Counter< 1 %
- SDF Reader< 1 %
- PCA< 1 %
- Data Generator< 1 %
- DB Reader< 1 %
- Rank Correlation< 1 %
Database Connection Table Reader< 1 %- Rule-based Row Splitter< 1 %
- R Snippet< 1 %
- Naive Bayes Predictor< 1 %
- Normalizer (PMML)< 1 %
- String Manipulation (Multi Column)< 1 %
- Loop End< 1 %
Table Row to Variable< 1 %- Column Combiner< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Row Filter< 1 %
- Normalizer (Apply)< 1 %
- Pivot< 1 %
- Date&Time Difference< 1 %
Concatenate (Optional in)< 1 %- Column Aggregator< 1 %
Table Reader< 1 %- Correlation Filter< 1 %
- CAIM Binner< 1 %
- Low Variance Filter< 1 %
- k-Medoids< 1 %
- Ungroup< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- File Reader (Complex Format)< 1 %
- Numeric Scorer< 1 %
- Parquet Reader< 1 %
- Table Creator< 1 %
- Loop End (Column Append)< 1 %
- Cluster Assigner< 1 %
- DBSCAN< 1 %
- Linear Regression Learner< 1 %
- SMOTE< 1 %
- SVM Predictor< 1 %
- Random Forest Predictor< 1 %
- Category to Number (Apply)< 1 %
- Column Rename (Regex)< 1 %
- Constant Value Column< 1 %
- Double to Integer< 1 %
Row Splitter (deprecated)< 1 %- Unpivot< 1 %
- Table View (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Murcko Scaffold< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Tree Ensemble Predictor< 1 %
Cell Replacer< 1 %- Number to String (PMML)< 1 %
- Table Reader< 1 %
- Table Manipulator< 1 %
- Extract Color< 1 %
- PCA Apply< 1 %
- Table Editor (JavaScript)< 1 %
- Read Excel Sheet Names< 1 %
- CSV Writer< 1 %
- ARFF Reader< 1 %
CSV Reader< 1 %- Group Loop Start< 1 %
- Hierarchical Clustering< 1 %
- k-Means< 1 %
- Decision Tree Predictor< 1 %
Random Forest Predictor< 1 %- Column Auto Type Cast< 1 %
- Number to Category (Apply)< 1 %
- Cross Joiner< 1 %
- Equal Size Sampling< 1 %
- Reference Column Filter< 1 %
- Nominal Value Row Filter< 1 %
- Denormalizer< 1 %
- Partitioning< 1 %
- Missing Value (Apply)< 1 %
- Rank< 1 %
- RowID< 1 %
- Shuffle< 1 %
- Column Splitter< 1 %
- String Replacer< 1 %
- Table Transposer< 1 %
- Data Explorer< 1 %
- Math Formula (Multi Column)< 1 %
- Java Snippet (simple)< 1 %
- Category to Class< 1 %
- Dictionary Replacer< 1 %
- Bag Of Words Creator< 1 %
- String to Date&Time< 1 %
- K Nearest Neighbor< 1 %
- Logistic Regression Predictor< 1 %
- Column to Grid< 1 %
- Linear Correlation< 1 %
- Column Filter (PMML)< 1 %
Number To String (PMML)< 1 %- String to Number (PMML)< 1 %
- DB Query Reader< 1 %
- Column Expressions< 1 %
- Column Filter (legacy)< 1 %
- Interactive Range Slider Filter Widget< 1 %
- RDKit Find Murcko Scaffolds< 1 %
- RDKit To Molecule< 1 %
- Scorer< 1 %
- Python Script (legacy)< 1 %
- Date&Time Part Extractor< 1 %
- t-SNE (L. Jonsson)< 1 %
- Container Input (JSON)< 1 %
- Value Lookup< 1 %
- String to Path< 1 %
- Scorer (JavaScript)< 1 %
- Java Snippet< 1 %
Naive Bayes Predictor< 1 %Regression Predictor< 1 %- Auto-Binner (Apply)< 1 %
- Date&Time to String< 1 %
- Strings to Binary Objects< 1 %
- Regression Predictor< 1 %
- Edit Numeric Domain< 1 %
- Denormalizer (PMML)< 1 %
- Numeric Row Splitter< 1 %
- Numeric Outliers (Apply)< 1 %
Color Appender< 1 %- OpenBabel< 1 %
Read Excel Sheet Names (XLS)< 1 %- Try (Data Ports)< 1 %
- Table Row to Variable< 1 %
- Excel Writer< 1 %
PCA Apply< 1 %- Add Empty Rows< 1 %
- Crosstab< 1 %
- Shape Manager< 1 %
- Counter Generation< 1 %
- H2O to Table< 1 %
Excel Reader (XLS)< 1 %Python Script (1⇒1)< 1 %- Naming< 1 %
Table Row To Variable Loop Start< 1 %Table Writer< 1 %- PNN Predictor< 1 %
K Nearest Neighbor< 1 %- Logistic Regression Learner< 1 %
- Binner (Dictionary)< 1 %
- Bootstrap Sampling< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- Filter Apply Row Splitter< 1 %
- Numeric Binner (PMML)< 1 %
- String Splitter (Regex)< 1 %
CASE Switch Data (Start)< 1 %- Cache< 1 %
- PMML Predictor< 1 %
- Porter Stemmer< 1 %
- Strings to Document< 1 %
- Container Input (Table)< 1 %
Database Reader< 1 %- Column List Loop Start< 1 %
- X-Aggregator< 1 %
Scorer< 1 %- Column Merger< 1 %
- Vocabulary Extractor (legacy)< 1 %
- Term to String< 1 %
- Integer Input (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Split Collection Column< 1 %
Table Column to Variable< 1 %- Expand Bit Vector< 1 %
- Case Converter< 1 %
Double To Int< 1 %Rank Correlation< 1 %- Spark to Table< 1 %
Excel Writer (XLS)< 1 %- String to Term< 1 %
- Table Column to Variable< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Column Renamer (Dictionary)< 1 %
- CASE Switch Start< 1 %
- DL4J Feedforward Predictor (Classification) (legacy)< 1 %
- Column Filter Configuration< 1 %
- JSON Reader< 1 %
- Outlier Removal< 1 %
- Inject Variables (Data)< 1 %
- Feature Selection Filter< 1 %
Loop End< 1 %- Fuzzy c-Means< 1 %
PCA< 1 %Numeric Scorer< 1 %- Simple Regression Tree Predictor< 1 %
Number To String< 1 %String To Number< 1 %- Column Name Extractor< 1 %
- Lag Column< 1 %
- CAIM Applier< 1 %
- Edit Nominal Domain< 1 %
- End IF< 1 %
- Extract Table Dimension< 1 %
- Box Plot (legacy)< 1 %
- Conditional Label Assigner< 1 %
- Distance Matrix Calculate< 1 %
- Topic Extractor (Parallel LDA)< 1 %
Strings To Document< 1 %- Time Field Extractor (legacy)< 1 %
- Time to String (legacy)< 1 %
- Discretise< 1 %
- Fingerprint to Set Bits List< 1 %
- Missing to Empty Collection< 1 %
- List Folders< 1 %
- Shapefile Polygon Reader< 1 %
- Normalize Plates (Z-Score)< 1 %
- Create Collection Column< 1 %
File Meta Info< 1 %Variable to Table Column< 1 %- Fixed Width File Reader< 1 %
List Files< 1 %Interval Loop Start< 1 %- X-Partitioner< 1 %
Naive Bayes Learner< 1 %- Polynomial Regression Learner< 1 %
Tree Ensemble Predictor< 1 %- Create Bit Vector< 1 %
- Cell Splitter By Position< 1 %
- Column Comparator< 1 %
- Table Validator< 1 %
- Extract Missing Value Cause< 1 %
- One to Many (PMML)< 1 %
- Nominal Probability Distribution Splitter< 1 %
- Decision Tree to Ruleset< 1 %
CASE Switch Data (End)< 1 %- ROC Curve (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- DB Writer< 1 %
- Random Number Assigner< 1 %
- One Row to Many< 1 %
- PMML to Cell< 1 %
- Item Set Finder (Borgelt)< 1 %
- SAS7BDAT Reader< 1 %
- Java Snippet Row Filter< 1 %
- Tika Language Detector< 1 %
- Dictionary Tagger< 1 %
- Document Data Extractor< 1 %
Document vector< 1 %- Value Filter (legacy)< 1 %
- Boolean Input (legacy)< 1 %
- String Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Lift Chart (JavaScript)< 1 %
- XML to JSON< 1 %
- Image Normalizer< 1 %
- Don't Save Start< 1 %
- Date&Time to legacy Date&Time< 1 %
- Legacy Date&Time to Date&Time< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
- Modify Date< 1 %
XML Reader< 1 %- RDKit From InChI< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit Fingerprint< 1 %
- RDKit To InChI< 1 %
- Text Classifier Predictor< 1 %
- Latitude/Longitude to Coordinate< 1 %
- Variable to Table Column< 1 %
- Image Writer (Table)< 1 %
Counting Loop Start< 1 %- SOTA Predictor< 1 %
- Association Rule Learner< 1 %
- PCA Compute< 1 %
- Expand Byte Vector< 1 %
- Row Filter (Labs)< 1 %
- Reference Row Splitter< 1 %
- Target Shuffling< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Linear Discriminant Analysis< 1 %
- Empty Table Switch< 1 %
- Mahalanobis Distance< 1 %
- Scatter Plot (Plotly)< 1 %
- Math Formula (Variable)< 1 %
- Unique Term Extractor< 1 %
- Weka Predictor (3.6) (legacy)< 1 %
- Weka Predictor (3.7)< 1 %
- Path to String< 1 %
- Parameter Optimization Loop Start< 1 %
- Duration to String< 1 %
- XGBoost Predictor< 1 %
- RDKit Canon SMILES< 1 %
Views
- This node has no views
Workflows
Credit Scoring Model(diksha kumari)KNIME Hub- (test) credit score modelKNIME Hub
- 00_Keras_Transfer_LearningKNIME Hub
- 00_Keras_Transfer_LearningKNIME Hub
- 01 Train a Feed Forward Neural NetworkKNIME Hub
- Show all 569 workflows
Links
- Replace all the non-numeric values with 1 - and all the blanks with 0by mlauber71 on 2018-09-30forum.knime.com/p/48239
- Renaming values in a columnby oole on 2019-02-14forum.knime.com/p/54543
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.