Analyse CSV column statistics

Profile CSV columns with types, missing counts, distinct values, ranges, means, and medians.

freeworks offlinenothing uploaded
ToolCSV Statistics
Input
Output
—
Put this on your own site

The frame below runs the same code as this page, in the reader's own browser. Nothing is sent to us, and nothing is sent to you.

Pick a dark background and the text and panels follow it, so the frame stays readable on a dark page.

Preview

How it works

Columns are type-detected, empty cells counted, distinct serialized values measured, and numeric values sorted for minimum, maximum, mean, and median. The byte-size report counts the original text as UTF-8.

  • A header row gives the report meaningful column names.
  • Numeric-looking cells are dynamically typed while empty fields remain outside numeric summaries.

Worked example

Analyze employee CSV with numeric columns
Compute statistics for a 4-row CSV. Detects age and salary as numeric, calculates mean and median
Input
											name,age,salary
Alice,30,95000
Bob,25,62000
Carol,41,110000
Dave,28,58000
Output
												Name    Type    Unique count  Null count  Min value  Max value  Mean   Median
------  ------  ------------  ----------  ---------  ---------  -----  ------
name    string  4             0           Alice      Dave
age     number  4             0           25         41         31     29
salary  number  4             0           58000      110000     81250  78500

When to use this

Survey profiling checks distributions, warehouse loads check missingness, and QA compares export summaries.

Edge cases

  • An empty string is counted as null and excluded from the mean.
  • One non-numeric label makes a mostly numeric column mixed.
  • An even-sized sample reports the average of the two middle sorted values.

References