search

openelections / openelections-data-ct

Pre-processed election results for Connecticut elections
3 stars 5 forks source link

Column header is missing or there's an extra column #6

Open warwickmm opened 3 years ago

warwickmm commented 3 years ago

2014/20141104ctgeneraldanburyprecinct.csv has a trailing empty column header

https://github.com/openelections/openelections-data-ct/blob/b6c6e1f183b11ce0f5a092e08403d4b861896468/2014/20141104__ct__general__danbury__precinct.csv#L1

The values for this column are empty until line 709, where the value appears to be the sum of Poll, Abs, EDR, and Unknown columns:

https://github.com/openelections/openelections-data-ct/blob/b6c6e1f183b11ce0f5a092e08403d4b861896468/2014/20141104__ct__general__danbury__precinct.csv#L707-L711

If this column is meaningful, we should provide a column header. If not, we should simply remove this column.

warwickmm commented 3 years ago

2014/20141104ctgeneralberlinprecinct.csv#L167-L170 has a similar issue. It does not have a missing column header, but starting on line 169 a new column appears that is the sum of the prior 3 columns:

https://github.com/openelections/openelections-data-ct/blob/b6c6e1f183b11ce0f5a092e08403d4b861896468/2014/20141104__ct__general__berlin__precinct.csv#L167-L170

warwickmm commented 3 years ago

2014/20141104ctgeneral__new_canaan__precinct.csv has a similar issue. A column header is empty, but there are no values until line 114. The values appear to be the sum of the prior 4 columns:

https://github.com/openelections/openelections-data-ct/blob/b6c6e1f183b11ce0f5a092e08403d4b861896468/2014/20141104__ct__general__new_canaan__precinct.csv#L112-L115