Loading ScholarTool content...
Loading ScholarTool content...
Upload or paste CSV data to inspect columns, missing values, duplicates, numeric summaries, type guesses, outliers, and correlations.
Profile summary
6 rows x 6 columns
Use the profile as a first-pass data quality review before cleaning, modeling, or statistical analysis. The CSV remains in the browser.
| Metric | Value |
|---|---|
| Detected delimiter | , |
| Columns | 6 |
| Duplicate rows | 1 |
| Numeric columns | 3 |
Use the profile as a first-pass data quality review before cleaning, modeling, or statistical analysis. The CSV remains in the browser.
| Column | Type | Missing | Missing % | Unique | Constant |
|---|---|---|---|---|---|
| sample_id | numeric | 0 | 0.00 | 5 | no |
| material | categorical | 0 | 0.00 | 3 | no |
| temperature_c | numeric | 1 | 16.67 | 4 | no |
| pressure_kpa | numeric | 0 | 0.00 | 5 | no |
| passed | boolean | 0 | 0.00 | 2 | no |
| notes | categorical | 0 | 0.00 | 5 | no |
| Column | Count | Mean | Median | SD | Min | Q1 | Q3 | Max | Outliers |
|---|---|---|---|---|---|---|---|---|---|
| sample_id | 6 | 3.33333 | 3.50000 | 1.63299 | 1.00000 | 2.25000 | 4.75000 | 5.00000 | 0 |
| temperature_c | 5 | 34.0000 | 35.0000 | 11.4018 | 20.0000 | 25.0000 | 45.0000 | 45.0000 | 0 |
| pressure_kpa | 6 | 109.300 | 107.950 | 9.27211 | 98.4000 | 102.400 | 117.625 | 120.100 | 0 |
| Column | Unique values | Top values | High cardinality |
|---|---|---|---|
| material | 3 | steel (4); aluminum (1); copper (1) | no |
| passed | 2 | true (5); false (1) | no |
| notes | 5 | high load (2); baseline (1); low pressure (1); missing temperature (1); repeat (1) | no |
| column | sample_id | temperature_c | pressure_kpa |
|---|---|---|---|
| sample_id | 1 | 0.8321 | 0.7225 |
| temperature_c | 0.8321 | 1 | 0.7474 |
| pressure_kpa | 0.7225 | 0.7474 | 1 |
Profile CSV columns from parsed rows using descriptive statistics
Missing values include empty cells, NA, N/A, null, undefined, and missing.
Outliers use the IQR screen: values below Q1 - 1.5 IQR or above Q3 + 1.5 IQR.
| Symbol | Meaning | Unit |
|---|---|---|
| n | Non-missing numeric count | rows |
| mean | Arithmetic average | column unit |
| sd | Sample standard deviation | column unit |
| Q1 | First quartile | column unit |
| Q3 | Third quartile | column unit |
| IQR | Interquartile range used for outlier screening | column unit |
Profile CSV data locally in the browser to inspect row counts, columns, missing values, duplicate rows, inferred data types, numeric summaries, categorical values, outliers, and correlations.
Paste a sensor CSV with pressure and temperature columns. The profiler reports row count, missing temperature cells, duplicate rows, pressure statistics, and a quick correlation matrix for numeric columns.
This tool is intended for educational, estimation, and preliminary data review use. Always verify critical data-processing decisions with validated workflows and qualified professional judgment before using results in real research, compliance, or engineering decisions.
ScholarTool is powered by ScholarEase Consultancy Services LLP. Professional engineering, simulation, research, and technical documentation support is available through the connected services website.
Visit ScholarEaseLast reviewed: 2026-06-17