Offending values per rule
The most common values each cleaning rule removes.
87 rows Download CSV
| keyTEXT | rankINTEGER | valueTEXT | rowsINTEGER |
|---|---|---|---|
| dropna | 1 | missing congestion_surcharge | 5300601 |
| dropna | 2 | missing passenger_count | 444383 |
| dropna | 3 | missing RatecodeID | 444383 |
| dropna | 4 | missing store_and_fwd_flag | 444383 |
| r1_1 | 1 | trip_distance = 0.0 | 705157 |
| r1_1 | 2 | trip_distance = -1.74 | 2 |
| r1_1 | 3 | trip_distance = -1.75 | 2 |
| r1_1 | 4 | trip_distance = -2.29 | 2 |
| r1_1 | 5 | trip_distance = -0.07 | 1 |
| r1_2 | 1 | passenger_count = 0.0 | 1453468 |
| r1_2 | 2 | passenger_count = 7.0 | 404 |
| r1_2 | 3 | passenger_count = 8.0 | 255 |
| r1_2 | 4 | passenger_count = 9.0 | 220 |
| r1_3 | 1 | RatecodeID = 99.0 | 3726 |
| r1_4 | 1 | fare_amount = 0.0 | 33013 |
| r1_4 | 2 | fare_amount = -2.5 | 31867 |
| r1_4 | 3 | fare_amount = -3.0 | 12738 |
| r1_4 | 4 | fare_amount = -52.0 | 12122 |
| r1_4 | 5 | fare_amount = -4.5 | 11829 |
| r1_5 | 1 | extra = -0.5 | 53961 |
| r1_5 | 2 | extra = -1.0 | 23312 |
| r1_5 | 3 | extra = -4.5 | 2160 |
| r1_5 | 4 | extra = -1.7 | 266 |
| r1_5 | 5 | extra = -2.5 | 169 |
| r1_6 | 1 | mta_tax = 0.0 | 482698 |