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/20201103txgeneralprecinct.csv: 'Bad Office' (columns needed to be shifted)
/2018/20181106txgeneralprecinct.csv: 'Bad Office' (columns needed to be shifted)
/2020/20200303txprimary__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)
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/20201103txgeneralprecinct.csv: 'Bad Office' (columns needed to be shifted) /2018/20181106txgeneralprecinct.csv: 'Bad Office' (columns needed to be shifted) /2020/20200303txprimary__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)