2020 Bronx County general file has inconsistent number of columns
warwickmm opened this issue · 1 comments
warwickmm commented
2020/counties/20201103__ny__general__bronx__precinct.csv has rows with an inconsistent number of columns:
Header ['county', 'precinct', 'office', 'district', 'party', 'candidate', 'votes', 'public_counter_votes', 'emergency_votes', 'absentee_military_votes', 'federal_votes', 'affidavit_votes', 'manually_counted_emergency', 'special_presidential'] has 14 entries, but there are 15640 rows with an inconsistent number of columns:
Row 2 (15 entries): ['Bronx', '1~77', 'President', '', 'Republican', 'Donald J. Trump / Michael R. Pence', '23', '178', '', '46', '0', '3', '1', '0', '0']
Row 3 (15 entries): ['Bronx', '1~77', 'State Senate', '29', 'Democratic', 'Jose M. Serrano', '199', '178', '', '46', '0', '3', '1', '0', '0']
Row 4 (15 entries): ['Bronx', '1~77', 'President', '', 'Green', 'Howie Hawkins / Angela Nicole Walker', '0', '178', '', '46', '0', '3', '1', '0', '0']
Row 5 (15 entries): ['Bronx', '1~77', 'State Assembly', '77', 'Democratic', 'Latoya Joyner', '194', '178', '', '46', '0', '3', '1', '0', '0']
Row 6 (15 entries): ['Bronx', '1~77', 'State Senate', '29', 'Republican', 'Jose A. Colon', '18', '178', '', '46', '0', '3', '1', '0', '0']
Row 7 (15 entries): ['Bronx', '1~77', 'President', '', 'Independence', 'Brock Pierce / Karla Ballard', '0', '178', '', '46', '0', '3', '1', '0', '0']
Row 8 (15 entries): ['Bronx', '1~77', 'State Assembly', '77', 'Conservative', 'Benjamin Eggleston', '4', '178', '', '46', '0', '3', '1', '0', '0']
Row 9 (15 entries): ['Bronx', '1~77', 'President', '', 'Working Families', 'Joseph R. Biden / Kamala D. Harris', '3', '178', '', '46', '0', '3', '1', '0', '0']
Row 10 (15 entries): ['Bronx', '1~77', 'President', '', 'Democratic', 'Joseph R. Biden / Kamala D. Harris', '196', '178', '', '46', '0', '3', '1', '0', '0']
Row 11 (15 entries): ['Bronx', '1~77', 'State Assembly', '77', 'Republican', 'Tanya Carmichael', '18', '178', '', '46', '0', '3', '1', '0', '0']
[Truncated to 10 examples]