This node calculates statistical moments such as minimum, maximum, mean, standard deviation, variance, median, overall sum, number of missing values and row count across all numeric columns, and counts all nominal values together with their occurrences. The dialog offers two options for choosing the median and/or nominal values calculations:
Options
Settings
Histogram
Popular Successors
- Column Filter4 %
XLS Writer3 %Row Filter (deprecated)3 %- Missing Value2 %
- GroupBy2 %
- Partitioning2 %
- Excel Writer2 %
- Linear Correlation2 %
- CSV Writer2 %
Table to PDF2 %- Statistics2 %
- Math Formula2 %
Number To String1 %- Crosstab1 %
- Numeric Outliers1 %
- Missing Value Column Filter1 %
- Loop End< 1 %
- Rank< 1 %
- Rule Engine< 1 %
- Scatter Plot (legacy)< 1 %
- String Manipulation< 1 %
- Color Manager< 1 %
- Joiner< 1 %
- Histogram (legacy)< 1 %
- Linear Regression Learner< 1 %
- R Snippet< 1 %
- Scatter Matrix (legacy)< 1 %
- Value Counter< 1 %
Database Writer< 1 %- Category to Number< 1 %
- Concatenate< 1 %
- Table View (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- Data to Report (BIRT)< 1 %
- Container Output (Table)< 1 %
- Normalizer< 1 %
- Box Plot (legacy)< 1 %
- Number to String< 1 %
- Duplicate Row Filter< 1 %
- Reference Row Filter< 1 %
XLS Sheet Appender< 1 %Extract Date&Time Fields< 1 %- R Plot< 1 %
- Auto-Binner< 1 %
Joiner< 1 %- SMOTE< 1 %
Column Rename< 1 %- Histogram< 1 %
XGBoost Tree Ensemble Learner< 1 %- Interactive Table (legacy)< 1 %
- Math Formula (Variable)< 1 %
- Table Row to Variable< 1 %
- Anonymization< 1 %
PCA< 1 %- Rule-based Row Filter< 1 %
- Interactive Histogram (legacy)< 1 %
Naive Bayes Learner< 1 %- Nominal Probability Distribution Creator< 1 %
- Bar Chart< 1 %
- DB Writer< 1 %
- Equal Size Sampling< 1 %
- Rank Correlation< 1 %
- CSV Reader< 1 %
- Conditional Box Plot (legacy)< 1 %
- Sunburst Chart (JavaScript)< 1 %
Excel Writer (XLS)< 1 %- Container Input (Table)< 1 %
Table Row To Variable Loop Start< 1 %- One-way ANOVA< 1 %
CV< 1 %- Image Writer (Table)< 1 %
- k-Means< 1 %
- PCA Compute< 1 %
- Pie chart (legacy)< 1 %
Loop End (3 ports)< 1 %Regression Predictor< 1 %- Numeric Scorer< 1 %
- Double to Integer< 1 %
- Sorter< 1 %
- Table Difference Finder< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Lift Chart (JavaScript)< 1 %
- Create Collection Column< 1 %
- Decision Tree to Image< 1 %
- Logistic Regression Learner< 1 %
Random Forest Learner< 1 %- String to Number< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Row Splitter< 1 %
- Statistics View< 1 %
- Bar Chart (JFreeChart)< 1 %
- Bubble Chart (JFreeChart)< 1 %
- Tile View (JavaScript)< 1 %
- Variable to Table Column< 1 %
- Table Column to Variable< 1 %
Number To String (PMML)< 1 %- Shuffle< 1 %
- Data Explorer< 1 %
Shapiro Wilk Normality Test< 1 %Excel Sheet Appender (XLS)< 1 %Python Script (2⇒1)< 1 %- Information Gain Calculator< 1 %
- Extract Variables (Data)< 1 %
- File Reader< 1 %
- DBSCAN< 1 %
- Logistic Regression Predictor< 1 %
- Table Transposer< 1 %
- Scatter Plot (Plotly)< 1 %
- Java Snippet (simple)< 1 %
- Bag Of Words Creator< 1 %
- Matlab Plot< 1 %
- Java Edit Variable< 1 %
K Nearest Neighbor< 1 %Tree Ensemble Learner< 1 %- Tree Ensemble Learner< 1 %
- Simple Regression Tree Learner< 1 %
- RowID< 1 %
- String Replacer< 1 %
- Ungroup< 1 %
- Table View< 1 %
- Random Number Assigner< 1 %
- Stacked Area Chart (JavaScript)< 1 %
- Table to HTML (legacy)< 1 %
- Radar Plot Appender< 1 %
- Weka Predictor (3.7)< 1 %
Python Plot< 1 %Table Row to Variable< 1 %Scorer< 1 %- Random Forest Learner (Regression)< 1 %
- Auto-Binner (Apply)< 1 %
- Column Auto Type Cast< 1 %
- One to Many< 1 %
- Table Validator< 1 %
- Top k Row Filter< 1 %
- Kolmogorov-Smirnov Test< 1 %
- Shape Manager< 1 %
- Parallel Coordinates Plot (JavaScript)< 1 %
- String to Path< 1 %
- Google Sheets Updater< 1 %
- Heatmap (JavaScript)< 1 %
- Moving Average< 1 %
- Range Filter< 1 %
- 2D/3D Scatterplot< 1 %
- ARIMA Visualization< 1 %
- Inject Variables (Data)< 1 %
Image Writer (Table Column)< 1 %- ARFF Writer< 1 %
Loop End (2 ports)< 1 %- Regression Predictor< 1 %
- Number to Category (Apply)< 1 %
Column Appender< 1 %- Column to Grid< 1 %
- Numeric Outliers (Apply)< 1 %
Color Appender< 1 %- Distance Matrix Writer< 1 %
- Stacked Area Chart (Plotly)< 1 %
- Column Filter (legacy)< 1 %
- Parameter Optimization Loop End< 1 %
Table Column to Variable< 1 %- Java Snippet< 1 %
- Feature Selection Filter< 1 %
Loop End< 1 %- Interval Loop Start< 1 %
- Naive Bayes Learner< 1 %
- Naive Bayes Predictor< 1 %
- Hierarchical Cluster View< 1 %
- Numeric Binner< 1 %
Cell Replacer< 1 %- Column Filter (PMML)< 1 %
- Normalizer Apply (PMML)< 1 %
- Rule Engine (Dictionary)< 1 %
- Independent groups t-test< 1 %
- Interactive Pie chart (legacy)< 1 %
- Scatter Plot< 1 %
- Matrix Distance< 1 %
- Distance Matrix Calculate< 1 %
- k-Medoids< 1 %
- Violin Plot (Plotly)< 1 %
- Math Formula (Multi Column)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Rule Viewer (local) (Legacy)< 1 %
- Geo-Coordinate Row Filter< 1 %
Excel Sheet Appender (XLS)< 1 %- Keygraph Keyword Extractor< 1 %
- Tag Cloud< 1 %
- Value Filter (legacy)< 1 %
- Scorer (JavaScript)< 1 %
- R Learner< 1 %
- Modify Time< 1 %
- R Snippet< 1 %
- Fingerprints Expander< 1 %
- Audio Data Extractor< 1 %
- Read Images< 1 %
- Table Writer< 1 %
- Table Row to Variable Loop Start< 1 %
- X-Partitioner< 1 %
- Hierarchical Clustering< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
- Decision Tree Predictor< 1 %
- MultiLayerPerceptron Predictor< 1 %
- RProp MLP Learner< 1 %
Logistic Regression Learner< 1 %- Scorer< 1 %
- Association Rule Learner< 1 %
- SVM Learner< 1 %
- Random Forest Learner< 1 %
- Binner (Dictionary)< 1 %
- Create Bit Vector< 1 %
- Column Name Extractor< 1 %
- Lag Column< 1 %
- Column Merger< 1 %
- Column Rename (Regex)< 1 %
Linear Correlation< 1 %- Correlation Filter< 1 %
- Table Validator (Reference)< 1 %
- Extract Missing Value Cause< 1 %
- Filter Apply Row Splitter< 1 %
- Row Splitter (Labs)< 1 %
- Low Variance Filter< 1 %
- Denormalizer< 1 %
- Pivot< 1 %
- Missing Value (Apply)< 1 %
- Denormalizer (PMML)< 1 %
- Normalizer (PMML)< 1 %
- String to Number (PMML)< 1 %
- Reference Column Resorter< 1 %
- Row Sampling< 1 %
- Unpivot< 1 %
- Renderer to Image< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Numeric Median Test< 1 %
- Single sample t-test< 1 %
Merge Variables< 1 %- Enrichment Plotter (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Visualization Property Extractor< 1 %
- Size Manager< 1 %
- ROC Curve (legacy)< 1 %
- Scatter Plot Matrix< 1 %
- Conditional Box Plot (JavaScript)< 1 %
- Table to PDF (legacy)< 1 %
- Line Chart (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
Excel Reader (XLS)< 1 %- Excel Reader< 1 %
- DF< 1 %
- Strings to Document< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Column Filter Configuration< 1 %
- ROC Curve (JavaScript)< 1 %
- Row to Network< 1 %
- Parameter Optimization Loop Start (Table)< 1 %
- Python View (legacy)< 1 %
Column Filter QuickForm (legacy)< 1 %- Date&Time to String< 1 %
- Date&Time Part Extractor< 1 %
- Date Field Extractor (legacy)< 1 %
- Sum Formula< 1 %
- Notched Boxplot (JFreechart)< 1 %
Python Snippet< 1 %- Python Plot< 1 %
- ARIMA Learner< 1 %
Table Row to Variable< 1 %- Table to Image< 1 %
CSV Writer< 1 %Table Writer< 1 %- Feature Selection Loop Start (1:1)< 1 %
- Loop End (Column Append)< 1 %
- Counting Loop Start< 1 %
- Group Loop Start< 1 %
Table Row To Variable Loop Start< 1 %Variable Loop End< 1 %Naive Bayes Predictor< 1 %- Cluster Assigner< 1 %
- Silhouette Coefficient< 1 %
- Decision Tree Learner< 1 %
- K Nearest Neighbor< 1 %
- Polynomial Regression Learner< 1 %
- Entropy Scorer< 1 %
- PCA< 1 %
- Random Forest Predictor< 1 %
- Simple Regression Tree Predictor< 1 %
- Bootstrap Sampling< 1 %
Cell Splitter< 1 %- Cell Splitter< 1 %
- Column Combiner< 1 %
- Column Comparator< 1 %
- Column Aggregator< 1 %
- Column Appender< 1 %
- Column Resorter< 1 %
- Constant Value Column< 1 %
- Cross Joiner< 1 %
- Domain Calculator< 1 %
- Reference Column Filter< 1 %
- Reference Column Splitter< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- Nominal Value Row Filter< 1 %
Row Splitter (deprecated)< 1 %- Row Filter (Labs)< 1 %
- Table Manipulator< 1 %
- Normalizer (Apply)< 1 %
- Many to One (PMML)< 1 %
- Number to String (PMML)< 1 %
- Number Rounder< 1 %
- Numeric Row Splitter< 1 %
- Column Splitter< 1 %
- String Manipulation (Multi Column)< 1 %
String Replace (Dictionary)< 1 %- Value Lookup< 1 %
- Rule-based Row Splitter< 1 %
- Cronbach Alpha< 1 %
- Paired t-test< 1 %
- Wilcoxon-Mann-Whitney Test< 1 %
- Linear Discriminant Analysis< 1 %
- Cache< 1 %
- Extract Table Dimension< 1 %
- Extract Table Spec< 1 %
- Timer Info< 1 %
- Lift Chart (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Box Plot< 1 %
- Heatmap< 1 %
- Line Plot< 1 %
- Pie Chart< 1 %
- Stacked Area Chart< 1 %
- DB Delete (Table)< 1 %
- Counter Generation< 1 %
- Gaussian Distributed Assigner< 1 %
- Numeric Distances< 1 %
- 3D Scatter Plot (Plotly)< 1 %
- Bar Chart (JavaScript)< 1 %
- Box Plot (JavaScript)< 1 %
- Histogram (JavaScript)< 1 %
- Line Plot (Plotly)< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
- Radar Plot (Plotly)< 1 %
- Column Expressions (legacy)< 1 %
- Table to H2O< 1 %
- Item Set Finder (Borgelt)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
Excel Writer (XLS)< 1 %- Send to Power BI< 1 %
- Spark Line Appender< 1 %
- Tableau Writer< 1 %
- Unique Term Extractor< 1 %
- Google Sheets Appender< 1 %
- Decision Tree View (JavaScript)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Interactive Value Filter Widget< 1 %
- JSON Path< 1 %
- Variance Filter< 1 %
- Quantile Filter< 1 %
Python Script (2⇒1)< 1 %- Python Script (legacy)< 1 %
- Date&Time Difference< 1 %
- String to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
- Moving Aggregator< 1 %
- Workflow Service Output< 1 %
- Result< 1 %
- Fast Fourier Transform (FFT)< 1 %
- Outlier Removal< 1 %
Database Reader< 1 %- Chunk Loop Start< 1 %
- Fuzzy Rule Learner< 1 %
PCA Compute< 1 %Gradient Boosted Trees Learner (Regression)< 1 %- Random Forest Predictor (Regression)< 1 %
- Add Empty Rows< 1 %
- Cell Splitter By Position< 1 %
- Edit Numeric Domain< 1 %
- Nominal Probability Distribution Splitter< 1 %
- Ruleset Editor< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
CASE Switch Data (End)< 1 %Table to HTML< 1 %- Google Sheets Writer< 1 %
Simple Table View (JavaScript)< 1 %- Mass Calculator< 1 %
- Timed Loop End (2 port)< 1 %
- BinningAnalysis< 1 %
- Normalize Plates (Z-Score)< 1 %
PBAC Scorer< 1 %Element Selector< 1 %- Binary Objects to Strings< 1 %
Variable to Table Column< 1 %CSV Reader< 1 %Variable Condition Loop End< 1 %- Fuzzy Rule Predictor< 1 %
- Hierarchical Clustering (DistMatrix)< 1 %
- SOTA Predictor< 1 %
- Case Converter< 1 %
- String to SVG< 1 %
- Edit Nominal Domain< 1 %
Linear Discriminant Analysis< 1 %- Capture Workflow End< 1 %
- Microsoft Access Connector< 1 %
PMML Predictor< 1 %Send to Power BI< 1 %- Document Data Extractor< 1 %
- Term to String< 1 %
- Integer Input (legacy)< 1 %
- Median Filter< 1 %
Python Script (1⇒1)< 1 %- Table Difference Checker< 1 %
- Date&Time Shift< 1 %
Open in Python< 1 %- R Snippet (2:1)< 1 %
- MarvinView< 1 %
- Strings to Binary Objects< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %Table Column to Variable< 1 %Backward Feature Elimination Start (1:1)< 1 %- X-Aggregator< 1 %
- PNN Predictor< 1 %
Numeric Scorer< 1 %Gradient Boosted Trees Learner< 1 %Random Forest Predictor< 1 %- Many to One< 1 %
Column Filter< 1 %- HiLite Row Splitter< 1 %
- One to Many (PMML)< 1 %
Rank Correlation< 1 %- Kaplan-Meier Estimator< 1 %
- Shapiro-Wilk Test< 1 %
- IF Switch< 1 %
- HiLite Table (legacy)< 1 %
- PMML Transformation Apply< 1 %
- Parallel Chunk End (multi port)< 1 %
- Random Number Assigner (Apache)< 1 %
- Boosting Learner Loop End< 1 %
- Boosting Predictor Loop End< 1 %
- Generic Web Service Client< 1 %
- Association Rule Learner (Borgelt)< 1 %
- OSM Map View< 1 %
- Frequency Filter< 1 %
- Dictionary Replacer (File-based)< 1 %
- CLAHE< 1 %
- Time Difference (legacy)< 1 %
- Row Splitter (col+)< 1 %
- Fingerprints< 1 %
- RDKit Descriptor Calculation< 1 %
- AP Calculator< 1 %
- Frequency Domain Features (FDF)< 1 %
- Time Domain Features (TDF)< 1 %
- Forge Score Machine Learning< 1 %
- TableToFile< 1 %
- Correlation Matrix To Pairs< 1 %
- Correlation Pairs To Matrix< 1 %
Loop End (Upto 6 ports)< 1 %- Set To List< 1 %
- Collection Size< 1 %
- SMARTSViewer< 1 %
- XML To Table< 1 %
- Number Formatter< 1 %
- Plate Heatmap Viewer< 1 %
- Matlab Snippet< 1 %
- Open in R< 1 %
MarvinSpace< 1 %ChemSpider (deprecated)< 1 %- Pareto Ranking< 1 %
- Split Collection Column< 1 %
Binary Objects to Files< 1 %- Binary Objects to PNGs< 1 %
- Files to Binary Objects< 1 %
- Find MIME-Type< 1 %
- Breakpoint< 1 %
- Catch Errors (Data Ports)< 1 %
Database Update< 1 %Parameterized Database Query< 1 %File Reader< 1 %Table Reader< 1 %- Feature Selection Loop End< 1 %
Counting Loop Start< 1 %- Column List Loop Start< 1 %
Recursive Loop End< 1 %Recursive Loop Start< 1 %- PNN Learner (DDA)< 1 %
- Fuzzy c-Means< 1 %
Decision Tree Learner< 1 %- MDS< 1 %
- MDS Projection (DistMatrix)< 1 %
- SOTA Learner< 1 %
- SVM Predictor< 1 %
Tree Ensemble Learner< 1 %Random Forest Learner< 1 %- Gradient Boosted Trees Learner< 1 %
- Tree Ensemble Learner (Regression)< 1 %
Concatenate (Optional in)< 1 %- Category to Number (Apply)< 1 %
String To Number< 1 %- Column Renamer (Dictionary)< 1 %
- CAIM Binner< 1 %
- Interactive HiLite Collector< 1 %
- Subset Matcher< 1 %
- Numeric Binner (PMML)< 1 %
String To Number (PMML)< 1 %- String Splitter (Regex)< 1 %
- Set Operator< 1 %
- Proportion Test< 1 %
Wilcoxon Signed-Rank< 1 %- Wilcoxon Signed-Rank< 1 %
- Linear Discriminant Analysis Compute< 1 %
- End IF< 1 %
- Send Email< 1 %
- Shape Appender< 1 %
Parquet Writer< 1 %- Molecule Type Cast< 1 %
- Fingerprint Bayesian Learner< 1 %
- Parallel Chunk End< 1 %
- DB Merge< 1 %
- Time Series Generator< 1 %
- Java Distance< 1 %
- Mahalanobis Distance< 1 %
- String Distances< 1 %
- Similarity Search< 1 %
- 2D Density Plot (Plotly)< 1 %
- Bubble Chart (Plotly)< 1 %
- Model Loop Start< 1 %
- PMML Predictor< 1 %
- HeatMap (JFreeChart)< 1 %
- Table Indexer< 1 %
- Java Snippet Row Filter< 1 %
Tableau Writer (TDE)< 1 %- Term Co-Occurrence Counter< 1 %
- TF< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Brat Document Writer< 1 %
- Category to Class< 1 %
- Chi-Square Keyword Extractor< 1 %
- Case Converter< 1 %
- N Chars Filter< 1 %
- Number Filter< 1 %
- Punctuation Erasure< 1 %
- Snowball Stemmer< 1 %
Document vector< 1 %- Document Viewer< 1 %
- Column Selection (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Column Filter Widget< 1 %
- JSON Row Combiner and Writer< 1 %
- String to JSON< 1 %
- Container Output (JSON)< 1 %
JSON Writer< 1 %- Average Filter< 1 %
- Image Normalizer< 1 %
- Image Viewer< 1 %
- Exp...< 1 %
- Binary Classification Inspector< 1 %
MongoDB Writer< 1 %- Object Inserter< 1 %
- Assign Partition< 1 %
- Network Viewer< 1 %
- Multiobjective Score Computation< 1 %
- Rowset Filter< 1 %
- Score Erosion< 1 %
Python Learner< 1 %Python Script (1⇒1)< 1 %Python Script (2⇒2)< 1 %- R View (Table)< 1 %
- Table to R< 1 %
- GET Request< 1 %
- POST Request< 1 %
- String to Duration< 1 %
- Extract Duration Fields< 1 %
- Window Loop Start< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- XGBoost Predictor< 1 %
- XML Row Combine and Write< 1 %
- XML Writer< 1 %
XML Writer< 1 %- XPath< 1 %
- Remove Empty Rows< 1 %
- Fingerprint Similarity< 1 %
- RDKit From InChI< 1 %
- RDKit Interactive Table< 1 %
- RDKit Remove Hs< 1 %
Location Extractor< 1 %Map Viewer< 1 %
Views
- Statistics View
- Displays all statistic moments (for all numeric columns), nominal values (for all selected categorical columns) and the most frequent/infrequent values from the categorical columns (Top/bottom).
Workflows
[Latest] Consolidated 3 Mar 1210KNIME Hub- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 00. Install ExtensionsKNIME Hub
- 01 Dealing with String DataKNIME Hub
- Show all 1085 workflows
Links
- demo how to count missing values in tablesby HansS on 2019-11-04forum.knime.com/p/73940
- weighted statisticsby johannes.schweig on 2019-01-30forum.knime.com/p/53793
- Frequencyby ipazin on 2018-04-27forum.knime.com/p/42108
- Data explorationby ipazin on 2019-01-07forum.knime.com/p/52411
- Find out General Information of a columnby HansS on 2022-07-23forum.knime.com/p/164183
- Show all 6 links
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.