Set `X_Collision` to `False` instead of `Null`

agude / SWITRS-to-SQLite

Python script for converting California's Statewide Integrated Traffic Records System (SWITRS) reports to SQLite.

https://alexgude.com/blog/switrs-to-sqlite/

Other

9 stars 3 forks source link

Set `X_Collision` to `False` instead of `Null` #3

Closed agude closed 2 years ago

agude commented 5 years ago

The various collision type columns (like Bicycle_Collision) are set to NULL instead of False currently when they are untrue. They are set to True when they are true.

Use NULL only if the data is truly missing.

agude commented 5 years ago

Food for thought:

There are 230,366 True values, and all the rest are NULL. Perhaps this is really the best we can hope for?