Shape · Statistics

Column Profile

Counts the distinct values in each chosen column, as long rows of column, value and count. Useful for spotting typos or dominant categories.

Also known as: Field summary

How it works

Pick the Columns to profile. Each is tallied on its own and the results are stacked into three columns, column, value and count, ordered by column and then by count, highest first. Values are written as text so columns of different types fit one table. Show proportions replaces the count with the share within that column, and Drop nulls (on by default) skips NULL values. No columns means nothing is profiled.

Inputs and outputs

Settings

{
  columns: string[]
  normalize: boolean
  dropna: boolean
}

Example

Check two categorical columns for typos at once: columns status and country.

More in Statistics

• Describe — Summarizes each column in one row: count, blanks, mean, standard deviation, min, percentiles and max. A quick first look at a new dataset.
• Value Counts — Counts how often each value, or combination of values, appears: one row per distinct value with its count or share.
• Correlation Matrix — Shows how strongly each pair of number columns moves together, as a grid of values from −1 to 1.
• Covariance Matrix — Works out the covariance of every pair of number columns, as a grid.
• Linear Regression — Fits a straight-line model of one column from one or more others. Outputs the coefficients, or your rows with predictions and residuals.
• Standardize — Rescales number columns to a common scale: z-score or 0 to 1. Use it before comparing measures in different units.
• Outlier Flag — Adds a true/false column marking rows with unusually high or low values. Rows are kept, so you can filter or review them afterwards.