openelections / openelections-data-ks

Pre-processed results for Kansas elections
5 stars 12 forks source link

Remove trailing almost-empty columns #69

Closed warwickmm closed 3 years ago

warwickmm commented 3 years ago

This removes some trailing columns that were essentially empty, except for a few rows. The extra value in these rows (p or P followed by a number) do not appear to correspond to anything from the source files. Since the header for this column was also missing, we removed this column to avoid potential confusion.

https://github.com/openelections/openelections-data-ks/blob/913c5c0931fb217b03c026b895d15036e4d71b11/2018/20180807__ks__primary__cherokee__precinct.csv#L164-L166 https://github.com/openelections/openelections-data-ks/blob/913c5c0931fb217b03c026b895d15036e4d71b11/2018/20180807__ks__primary__cherokee__precinct.csv#L1041-L1043 https://github.com/openelections/openelections-data-ks/blob/913c5c0931fb217b03c026b895d15036e4d71b11/2018/20180807__ks__primary__cherokee__precinct.csv#L1321-L1323 https://github.com/openelections/openelections-data-ks/blob/913c5c0931fb217b03c026b895d15036e4d71b11/2018/20180807__ks__primary__ford__precinct.csv#L876-L878 https://github.com/openelections/openelections-data-ks/blob/913c5c0931fb217b03c026b895d15036e4d71b11/2018/20180807__ks__primary__riley__precinct.csv#L364-L366 https://github.com/openelections/openelections-data-ks/blob/913c5c0931fb217b03c026b895d15036e4d71b11/2018/20180807__ks__primary__riley__precinct.csv#L860-L862 https://github.com/openelections/openelections-data-ks/blob/913c5c0931fb217b03c026b895d15036e4d71b11/2018/20180807__ks__primary__riley__precinct.csv#L1058-L1060 https://github.com/openelections/openelections-data-ks/blob/913c5c0931fb217b03c026b895d15036e4d71b11/2018/20180807__ks__primary__riley__precinct.csv#L1561-L1563