Offending values per rule
The most common values each cleaning rule removes.
87 rows Download CSV
| keyTEXT | rankINTEGER | valueTEXT | rowsINTEGER |
|---|---|---|---|
| r1_11 | 5 | year(pickup_dt) = 2003 | 4 |
| r1_12 | 1 | year(dropoff_dt) = 2020 | 1607 |
| r1_12 | 2 | year(dropoff_dt) = 2009 | 440 |
| r1_12 | 3 | year(dropoff_dt) = 2008 | 103 |
| r1_12 | 4 | year(dropoff_dt) = 2002 | 11 |
| r1_12 | 5 | year(dropoff_dt) = 2003 | 6 |
| r1_13 | 1 | VendorID = 4 | 199180 |
| fare_zscore | 1 | fare (nearest $100) = 300.0 | 347 |
| fare_zscore | 2 | fare (nearest $100) = 400.0 | 267 |
| fare_zscore | 3 | fare (nearest $100) = 500.0 | 79 |
| fare_zscore | 4 | fare (nearest $100) = 600.0 | 20 |
| fare_zscore | 5 | fare (nearest $100) = 700.0 | 5 |
| min_fare | 1 | fare = 2.0 | 94 |
| min_fare | 2 | fare = 0.1 | 38 |
| min_fare | 3 | fare = 0.01 | 24 |
| min_fare | 4 | fare = 0.5 | 13 |
| min_fare | 5 | fare = 0.65 | 13 |
| positive_duration | 1 | minutes = 0.0 | 2238 |
| positive_duration | 2 | minutes = -40.3 | 9 |
| positive_duration | 3 | minutes = -46.9 | 9 |
| positive_duration | 4 | minutes = -51.9 | 9 |
| positive_duration | 5 | minutes = -45.7 | 8 |
| speed | 1 | miles per minute (nearest 10) = undefined (zero or negative duration) | 2238 |
| speed | 2 | miles per minute (nearest 10) = 60.0 | 853 |
| speed | 3 | miles per minute (nearest 10) = 70.0 | 690 |