Shape · Statistics

Value Counts

Counts how often each value, or combination of values, appears: one row per distinct value with its count or share.

Also known as: Frequency table, tally

How it works

Pick one or more Columns; with several, each distinct combination is one row. Show proportions writes each row's share of the total instead of the count. Sort by frequency is on by default; off, rows come in alphabetical order of the values. Drop nulls is on by default and leaves out a row when any chosen column is NULL. The tally column is named count, or proportion when showing proportions, unless you set Count column name. No columns means nothing is counted.

Inputs and outputs

Settings

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

Example

Orders per status: columns status, sort by frequency on.

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.
• 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.
• 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.