Statistics View

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub.
In the node configuration, you can choose the columns you want to display. Only numeric and text based columns are supported.
The configuration also offers a preview of the table, which should help to get the statistics in the desired shape quickly.
This node accepts either numeric or nominal based columns, while all other types will be ignored. Note that in case nominal columns, the calculated numeric statistics refer to the string length. All statistics calculation will ignore missing and NaN values. For first and last element in a nominal dimension the lexicographic order will be used.

Interactivity between multiple views is currently only possible for views coming from the KNIME Views extension.

Options

Selected Columns

Selects the columns to calculate statistics from.

Displayed Statistics

Select the statistics that should be displayed in the table:
Note: Missing values and (in case of numeric columns) NaN values are ignored.

• Name: When selected, a column with the dimension name is displayed.
• Type: When selected, a column with the assigned data type of this column is displayed.
• Number unique values: When selected, a column shows the number of unique values this column has.
• Minimum: When selected, a column "Minimum" listing the minimum for each selected column is displayed. Note that for nominal columns the minimum is taken with respect to the lexicographic order.
• Maximum: When selected, a column "Maximum" listing the maximum for each selected column is displayed. Note that for nominal columns the maximum is taken with respect to the lexicographic order.
• Common values: When selected, a column "10 most common values" is displayed. For each column the 10 most common values are displayed together with the absolute and proportional frequency of occurrence (e.g., 'A (120, 24%), B (50, 10%), ...').

Note: For the following properties, the string length is used in case of nominal columns.

• Quantiles: One can choose between several p-quantiles with values p = 1%, 5%, 10%, 25%, 50%, 75%, 90%, 95% and 99%. When selected, a column with the respective dimension quantile is displayed.
• Mean: When selected, a column with the dimension mean is displayed.
• Sum: When selected, a column with the dimension sum is displayed.
• Mean absoulte deviation: When selected, a column with the dimension mean absolute deviation is displayed.
• Standard deviation: When selected, a column with the dimension standard deviation is displayed.
• Variance: When selected, a column with the dimension variance is displayed.
• Skewness: When selected, a column with the dimension skewness is displayed.
• Kurtosis: When selected, a column with the dimension kurtosis is displayed.

Title

The title of the table shown above the generated image. If left blank, no title will be shown.

Show table size

Whether to display the number of rows and columns above the table or not.

Pagination

Enables or disables the ability to only show a certain number of rows. Enabling pagination hides the option “Show table size”.

Page size

Select the amount of rows shown per page

Column width

Set the width of the individual columns:

• Fixed: the column sizing is fixed
• Fit content: the columns are sized according to the largest element in the column within the first 11 rows or within the current page when the page size is smaller than 11.
• Fit content and header: the content and the headers are considered for the size calculation of the columns.

Enable global search

Enables or disables the ability to perform a global search inside the table.

Enable column search

Enables or disables the ability to perform a column search inside the table.

Enable sorting by header

Enables or disables the ability to sort the table by clicking on the column headers

Enable copying cells

When checked, the cells of the table are selectable and can be copied. Click on a cell to select it. To select a range, select a cell, then click another cell with shift pressed or with the left mouse button pressed, drag over other cells.

Views

Statistics View

A table view of statistics from the data.

Workflows

• 00_Your_First_Workflow_SolutionKNIME Hub
• 01. Descriptive StatisticsKNIME Hub
• 02_Data_Cleaning_ExerciseKNIME Hub
• 04 VisualizationKNIME Hub
• 09_Example_for_StatisticsKNIME Hub
• Show all 213 workflows

Links

• No links available

Developers