Dataset Statistics
Summarize each CSV column with count, mean, std, quartiles, and missing rates.
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
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?
Is the standard deviation sample or population?
How are quartiles computed?
How is it different from the data profiler?
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 YouTubeWhat Is A RESTful API?
Traversy Media
APIs are how most data tools receive payloads.
Watch on YouTube
- Introducing JSON
json.org
JSON grammar for data format converters.
- Model for Tabular Data and Metadata on the Web
W3C
Tabular data model behind CSV-oriented workflows.