Convert 2015 specials PDF results

openelections / openelections-data-ia

Election results for Iowa

4 stars 6 forks source link

Convert 2015 specials PDF results #2

Open dwillis opened 8 years ago

dwillis commented 8 years ago

Available here. Using Tabula, create CSV files that look like this one. For races that have both county and precinct-level results, create separate files for both.

[ ] State Representative District 4, Jan. 4, 2015 (filename would be 20150104__ia__special__general__precinct.csv for precinct results)
[x] State Representative District 23, Feb. 10, 2015 (filename would be 20150210__ia__special__general__precinct.csv for precinct results)
[x] State Representative District 5, Nov. 3, 2015 (filename would be 20151103__ia__special__general__precinct.csv for precinct results)
[x] State Representative District 21, Dec. 8, 2015 (filename would be 20151208__ia__special__general__precinct.csv for precinct results)

keithly commented 3 years ago

@dwillis I started working on this, and have a few questions.

"...create CSV files that look like this one" - the link is broken. I took a guess that this file is a good example for county-level
Some of the precinct-level results are listed as "Unofficial". for example Do you still want those?
I used tabula-java to get the county-level results converted to csv. I tried to use the existing scripts to convert to the openelections format similar to the way it's shown in the README: ./bin/parse_2014_special_county.py --infile canvass.csv --outfile 20151208__ia__special__general__county.csv However, I keep getting ModuleNotFoundError: No module named 'openelexdata' no matter where I execute the python script from. How is this supposed to work?
What version of python should be used here?

dwillis commented 3 years ago

@keithly thanks for working on this! Here is a good example of a precinct-level results file. It's just like the county-level one but with an additional precinct column.

We don't want unofficial results, so if that's all they have unfortunately you can skip them. The openelexdata module exists in this repository, so depending on where you are running the command from it should be able to find it. Perhaps @ghing (who originally wrote it) could be of service, although it has been a few years. We were using Python 2.7 at the time this work was started, but it should be possible to use Python 3.X, too.

keithly commented 3 years ago

@dwillis I have these results completed. I tried to make a new branch / PR adding the files, but I don't have rights to do that.

dwillis commented 3 years ago

@keithly Thanks! I've given you write access to the repo.

keithly commented 3 years ago

I've created PR #30 with the data