Data Explorer Component

Component displays three tables (one for each data type column group Nominal-Numeric-Date&Time) with all statistics and histogram.

For nominal valued columns (String and Boolean) Unique Count, Missing Value Count, Minimum, Mode, Maximum, Top N value with count and percentage, Bottom N value with count and percentage are displayed. For each column the distribution of nominal values is displayed too.

For numeric valued columns (Double, Long, Integer) Minimum, Mode, Mean, Median, Maximum, Lower Bound, Range, Upper Bound, Standard Deviation, Variance, Q1, Q3, IQR, Bottom Whisker, Top Whisker, Overal Sum, Kurtosis, Skewness, Num of Missing Values, Number of Zeros, Number of Non Outlier, Number of Bottom Outliers, Number of Top Outliers, Top N outlier values, Bottom N Outlier Values are displayed. For each column the histogram is displayed too.

For date & time valued columns (Date, Time, Date & Time etc) Minimum, Mean Date, Median Date, Mode, Maximum, Lower Bound, Upper Bound, Date Range in Days, Unique Count, Number of Missing Values are displayed.

The component configuration dialog offers column selection, Top-Bottom nominal value display limit, Top-Bottom Outlier value display limit and K coefficient for IQR outlier analysis.

Displays statistics and histogram can be read from the out ports 1,2,3 respectively for Nominal, Numeric, Data&Time column group.

The excluded columns can be read from 4th out port.

Options

Apply to Columns
Please select columns that will be explored
Outlier IQR K coefficient
Enter K coefficient for outlier detection as IQR product
Number of elements for Top-Bottom lists
Enter number of top and bottom values in nominal columns
Number of elements for Top-Bottom Outliers
Enter number of top and bottom outlier values for numeric columns

Input Ports

Icon
A table from which to compute statistics.

Output Ports

Icon
Nominal valued column statistics and histogram output
Icon
Numerical valued column statistics and histogram output
Icon
Date & Time valued column statistics and histogram output
Icon
The filtered input date after selected columns excluded

Nodes

Extensions

Links

Download

To use this component in KNIME, download it from the below URL and open it in KNIME:

Download Component
On NodePit since: 2021-07-01
Last update: 2024-04-27
Created with KNIME version: v4.3.3

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!