openelections-data-tx
openelections-data-tx copied to clipboard
3 CSV files have formating issues
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