Offending values per rule
The most common values each cleaning rule removes.
87 rows Download CSV
| keyTEXT | rankINTEGER | valueTEXT | rowsINTEGER |
|---|---|---|---|
| r1_6 | 2 | mta_tax = -0.5 | 160944 |
| r1_6 | 3 | mta_tax = 1.44 | 250 |
| r1_6 | 4 | mta_tax = 0.25 | 82 |
| r1_6 | 5 | mta_tax = 3.3 | 61 |
| r1_7 | 1 | tolls_amount = -6.12 | 2685 |
| r1_7 | 2 | tolls_amount = -5.76 | 293 |
| r1_7 | 3 | tolls_amount = -10.5 | 119 |
| r1_7 | 4 | tolls_amount = -2.8 | 50 |
| r1_7 | 5 | tolls_amount = -12.5 | 48 |
| r1_8 | 1 | improvement_surcharge = -0.3 | 164903 |
| r1_8 | 2 | improvement_surcharge = 0.0 | 52051 |
| r1_8 | 3 | improvement_surcharge = 1.0 | 19 |
| r1_8 | 4 | improvement_surcharge = 0.03 | 10 |
| r1_9 | 1 | total_amount = 0.0 | 19499 |
| r1_9 | 2 | total_amount = -6.8 | 11191 |
| r1_9 | 3 | total_amount = -7.8 | 10411 |
| r1_9 | 4 | total_amount = -8.3 | 10399 |
| r1_9 | 5 | total_amount = -6.3 | 10294 |
| r1_10 | 1 | congestion_surcharge = -2.5 | 119536 |
| r1_10 | 2 | congestion_surcharge = -0.75 | 3 |
| r1_10 | 3 | congestion_surcharge = -1.5 | 1 |
| r1_11 | 1 | year(pickup_dt) = 2020 | 428 |
| r1_11 | 2 | year(pickup_dt) = 2009 | 358 |
| r1_11 | 3 | year(pickup_dt) = 2008 | 185 |
| r1_11 | 4 | year(pickup_dt) = 2002 | 13 |