Smart Retail Intelligence / Data Quality
System Ready
online_retail_II.xlsx

Data Quality

Current-dataset integrity, preprocessing and defensive validation summary.

Uploaded rows

525,461

Rows received before cleaning

Processed rows

518,596

Rows in the active dataset

Duplicates removed

6,865

Removed during activation

Cancelled records

10,182

Invoices beginning with C

Active dataset checks

Analytical columns13
Remaining duplicate rows 0
Missing critical values 0
Invalid dates 0
Invalid quantities 0
Invalid prices 0

Business-value checks

Zero-price records3,681
Negative-price records3
Negative-quantity records12,302

Customer segmentation uses identified, positive purchase transactions. Anomaly detection retains the wider valid transaction dataset.

Defensive validation pipeline

File Type Validation Empty File Validation Required Columns Validation Critical Fields Validation Data Types Validation Date Validation Quantity Validation Price Validation