openelections / openelections-data-ct

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

Remove unnecessary characters from 20141104__ct__general__east_hartford__precinct.csv #8

Closed warwickmm closed 3 years ago

warwickmm commented 3 years ago

2014/20141104ctgeneral__east_hartford__precinct.csv contains some entries that contain a single hyphen -, possibly to indicate a missing value.

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

There are also entries where a , is used as a thousands separator, which required the use of surrounding double quotes:

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

These can be removed to simplify consumption of this file.