Skip to main content

Columns

Lists the columns in the step and enables you to review univariate and multi-variate statistics. By default, you will see univariate column profile.

Click on the dropdown on the top right corner, to choose the right column statistical option. Following options are supported.

  • Column Profile
  • MultiVariate Analysis

Univarate Column Information​

  • Select columns to see profile for, using the search option under SELECT COLUMN Section. Once you select the column to build the profile. A Univariate Profile Card is shown in the right panel. Each card shows variety of descriptive statistics based on the column type.

For Numerical Columns, The Card is shown as below:

[Numeric Column Profile Image]

Numeric Column Field Statistics​

  1. Datatype
  2. Number Of Records
  3. Is unique flag
  4. Number of Distinct Values
  5. The Percentage of the distinct values
  6. Not Null values
  7. Cardinality
  8. Number of zeros(count)
  9. Percentage of zeros
  10. Minimum Value in the column
  11. Maximum Value in the column
  12. Average Value in the column
  13. Value that appears most often(Mode)
  14. Sum of all the values in the column
  15. Mean absolute Deviation (MAD)
  16. amount of variation or dispersion of a set of values. i.e the Standard Deviation.
  17. Variance
  18. Coefficient of Variation(CV) :A statistical measure of the relative dispersion of data points in a data series around the mean.
  19. The Interquartile Range (IQR)
  20. Skewness of the column.

For Categorical Columns(Text/String), The Card is shown as below:

[Categorical Column Profile Image]

Categorical Column Field Statistics​

  1. Datatype of the column
  2. Number of Records
  3. Is unique flag
  4. Percentage of Unique Values
  5. Number of Distinct Values
  6. Percentage of Distinct Values
  7. Value that appears often (Mode)
  8. Memory Usage
  9. Cardinality
  10. Count of Not Null Values

With all these stats for categorical columns you will see an option to see all the values in that column with the name Uniques . Inside the Unqiues you will see the values and the count of number of times that particular value was seen. You will also be able to sort the values by their ascending and descending order.

Get the power of futuristic Data & AI Platform for your enterprise.