Dataset Statistics

Summarize each CSV column with count, mean, std, quartiles, and missing rates.

FreeNo accountOn your device

Runs in your browser. How to verify

Loading tool…

About this tool

Drop a CSV and get a summary line for each column: how many values, how many are missing, how many are unique and, for numeric columns, the min, max, mean, median, standard deviation and first and third quartiles. Similar to pandas describe().

How to use

1
Step 1
Paste CSV text or drop a file.
2
Step 2
Press Process.
3
Step 3
Read the per-column summary in the JSON result.

How it works

Standard deviation is the sample version (divides by n − 1). Quartiles use linear interpolation between ranks, the same default as NumPy. The summary also lists the total number of missing cells, the number of numeric columns and the count of exact duplicate rows.

Worked example

Sales table

Input
region,product,units,revenue (7 rows, one blank units cell)
Output
units: count 6, missing 1 (14.286%), min 3, max 12, mean 7.833, median 8.5, std 3.430, q1 5.5, q3 10 revenue: min 30, max 190, mean 87.857, median 80, std 52.110, q1 57.5, q3 100 totalMissingCells 1, duplicateExactRowCount 1
Walkthrough
units has only 6 of 7 values, which is why count is 6 and missing is 1.

Limitations

  • Text columns get counts, missing and unique values but no numeric statistics.
  • There are no skewness or kurtosis columns; use the normality tester.
  • Output is JSON, not a CSV.

Questions

How do I get summary statistics from a CSV?
Paste or drop the CSV and press Process.
Is the standard deviation sample or population?
Sample (n − 1).
How are quartiles computed?
By linear interpolation, matching NumPy's default percentile method.
How is it different from the data profiler?
This is a compact numeric summary with quartiles; the profiler adds top values, histograms and duplicate row indexes.

Features

  • Quartiles and std
  • Missing %
  • Unique counts
  • Runs in your browser

Related resources

Guides and videos from around the web—opens on YouTube or the publisher’s site.

  • SQL Tutorial - Full Database Course

    freeCodeCamp.org

    SQL and tabular data sit next to CSV/JSON data tools.

    Watch on YouTube
  • What Is A RESTful API?

    Traversy Media

    APIs are how most data tools receive payloads.

    Watch on YouTube