parser2.rb

require 'remote_table'
require 'roo-xls'
require 'csv'

county = 'Tarrant'
t = RemoteTable.new("/Users/derekwillis/code/openelections-sources-tx/2018/TARRANT_COUNTY-2018_Democratic_Party_Primary_Election_362018-SOSDEMPrecinctReport.xlsx")
rows = t.entries
results = []
headers = ['county', 'precinct', 'office', 'district', 'party', 'candidate', 'votes', 'early_votes', 'election_day']

rows.each do |row|
  if row['race_name'].include?(", District")
    office, district = row['race_name'].split(", District ")
  else
    office = row['race_name']
    district = nil
  end
  if row['race_name'] == 'United States Senator' and row['candidate_name'] == 'Beto O\'Rourke'
    results << [county, row['Precinct_name'], 'Registered Voters', nil, nil, nil, row['Reg_voters'], nil, nil]
  end
  total_votes = row['early_votes'].to_i + row['election_votes'].to_i
  results << [county, row['Precinct_name'], office, district, row['Party_Code'], row['candidate_name'], total_votes, row['early_votes'], row['election_votes']]
end

CSV.open("20180306__tx__primary__#{county.downcase.gsub(' ','_')}__precinct.csv", "w") do |csv|
  csv << headers
  results.map{|r| csv << r}
end