Performing Column Analysis

Perform column analysis to analyze the sample data based on columns.

Procedure

  1. On the home page, click project 1 to go to the project data page.
  2. On the toolbar, click Profile.
    The "Profiling analysis" page is displayed.
  3. From the Analysis type list, select Column analysis.
    A column analysis report is generated.
  4. View the column analysis report.
    The report shows the following two aspects of the columns:
    • Numeric columns: Provides mathematical results on operations of Empties, Nulls, Uniqueness, Unique count, Min, Max, Mean, Sum, Standard deviation, and Quartile.
    • String columns: Provides column count on the subjects of Empties, Nulls, Uniqueness, Unique count, Min length, Max length, and Mean length.