Data profile — messy_sales.csv

demo\messy_sales.csv · generated 2026-07-10 05:23 UTC · tidysheet v0.1.0
Rows
32
Columns
9
Duplicate rows
2
File size
1.9 KB
Quality score
95.6 / 100

Quality dimensions weights: completeness 0.35, validity 0.25, consistency 0.2, uniqueness 0.2

completeness94.1
validity100.0
consistency94.8
uniqueness93.8

Columns

columntypesemantic nullsdistinct qualityissues
order_id BIGINT 0.0% 30 100.0
customer VARCHAR 0.0% 30 96.3 2
country VARCHAR country 0.0% 30 99.6
status VARCHAR 0.0% 13 89.8 3
amount VARCHAR numeric_text 0.0% 30 100.0 1
discount_pct VARCHAR numeric_text 0.0% 15 80.9 2
quantity VARCHAR numeric_text 0.0% 7 98.6 2
order_date VARCHAR date_text 0.0% 30 100.0 1
source VARCHAR 0.0% 1 100.0 1

Column detail

order_id BIGINT quality 100.0
values 32 distinct 30 min 1 median 16.50 max 31 mean 16.44 std 9.28
missing 0.0% (0)
top values
valuecountshare
292 6.2%
312 6.2%
11 3.1%
21 3.1%
31 3.1%
41 3.1%
51 3.1%
61 3.1%
71 3.1%
81 3.1%
customer VARCHAR quality 96.3
values 32 distinct 30 len min/avg/max 7 / 10.50 / 15 whitespace issues 1
missing 0.0% (0)
top values
valuecountshare
Ryan Scott2 6.2%
Zoe Adams2 6.2%
jane doe 1 3.1%
ANA GARCIA1 3.1%
Ava Martinez1 3.1%
Ben Harris1 3.1%
Bob Lee1 3.1%
Chris Wong1 3.1%
David Kim1 3.1%
Emma Brown1 3.1%
country VARCHAR country · 100% quality 99.6
values 32 distinct 30 len min/avg/max 2 / 5.12 / 14
missing 0.0% (0)
top values
valuecountshare
Netherlands2 6.2%
Portugal2 6.2%
Australia1 3.1%
Brazil1 3.1%
Canada1 3.1%
China1 3.1%
DE1 3.1%
FR1 3.1%
Germany1 3.1%
IN1 3.1%
status VARCHAR quality 89.8
values 32 distinct 13 len min/avg/max 1 / 7.06 / 10 whitespace issues 2 null-like tokens 2
missing 0.0% (0)
top values
valuecountshare
Shipped11 34.4%
Pending6 18.8%
pending3 9.4%
Cancelled2 6.2%
shipped2 6.2%
-1 3.1%
N/A1 3.1%
Refunded1 3.1%
SHIPPED1 3.1%
cancelled1 3.1%
amount VARCHAR numeric_text · 100% quality 100.0
values 32 distinct 30 len min/avg/max 6 / 7.31 / 9
missing 0.0% (0)
top values
valuecountshare
$1,850.602 6.2%
$66.602 6.2%
$1,100.001 3.1%
$1,234.501 3.1%
$1,999.991 3.1%
$125.001 3.1%
$150.751 3.1%
$2,000.001 3.1%
$2,499.001 3.1%
$220.401 3.1%
discount_pct VARCHAR numeric_text · 100% quality 80.9
values 32 distinct 15 len min/avg/max 2 / 2.91 / 5 null-like tokens 14
missing 0.0% (0)
top values
valuecountshare
N/A14 43.8%
10%3 9.4%
28%2 6.2%
5%2 6.2%
12.5%1 3.1%
15%1 3.1%
18%1 3.1%
2%1 3.1%
20%1 3.1%
22%1 3.1%
quantity VARCHAR numeric_text · 100% quality 98.6
values 32 distinct 7 len min/avg/max 1 / 1.00 / 1 null-like tokens 1
missing 0.0% (0)
top values
valuecountshare
111 34.4%
210 31.2%
34 12.5%
44 12.5%
-1 3.1%
51 3.1%
61 3.1%
order_date VARCHAR date_text · 100% quality 100.0
values 32 distinct 30 len min/avg/max 10 / 10.00 / 10
missing 0.0% (0)
top values
valuecountshare
20/02/20242 6.2%
2024-02-212 6.2%
02/02/20241 3.1%
04/02/20241 3.1%
06/02/20241 3.1%
09/02/20241 3.1%
11/02/20241 3.1%
13/02/20241 3.1%
16/02/20241 3.1%
18/01/20241 3.1%
source VARCHAR quality 100.0
values 32 distinct 1 len min/avg/max 3 / 3.00 / 3
missing 0.0% (0)
top values
valuecountshare
web32 100.0%
Generated locally by tidysheet — no data left this machine.