openelections-data-tx icon indicating copy to clipboard operation
openelections-data-tx copied to clipboard

3 CSV files have formating issues

Open frankrojas6591 opened this issue 2 years ago • 0 comments

I found 3 csv files were "inconsistent". I wrote a notebook to go thru ALL csv files to check if they are all normalized (via panda read_csv). [OpenElectionsData-Tx-NormalizeCSV.ipynb]. Below are the 3 files that had issues... and wrote code to adjust columns and methods of reading them.

/2020/20201103__tx__general__precinct.csv: 'Bad Office' (columns needed to be shifted) /2018/20181106__tx__general__precinct.csv: 'Bad Office' (columns needed to be shifted) /2020/20200303__tx__primary__precinct.csv: 'Bad Index'. (varying number of cols per row)

I was able to do work arounds and get all files...

I've built 2 py classes as a subdir /pyOE/* class OE_CSV(OpenElections) class OpenElections(object)

frankrojas6591 avatar Oct 05 '22 15:10 frankrojas6591