Cleaning funnel
Rows left after every cleaning rule, revived pipeline next to the counts printed by the 2021 notebook.
28 rows Download CSV
| stepINTEGER | stageTEXT | labelTEXT | ruleTEXT | revived_rowsINTEGER | notebook_rowsINTEGER | difference_pctREAL |
|---|---|---|---|---|---|---|
| 26 | Merge | Join collisions; drop Unknown boroughs (final analysis dataset) | 74910889 | 74908426 | 0.003 | |
| 27 | Model | Join shapefile zone names (cell 255) | 74942128 | null | null | |
| 28 | Model | Drop rows without an event count (dropna, cell 269) | 74941355 | null | null |