Beispiel #1
0
import json
import dbutils
import us
import re
from nytimesparse import getFips 
import sys

conn=dbutils.connect()
c=conn.cursor()
if sys.argv[1]='Senate':
    data=json.load(open('/home/anovikova/workspace/data/results_senate.JSON'))
elif sys.argv[1]='President':
    data=json.load(open('/home/anovikova/workspace/data/results_president.JSON'))
statedict=data['counties']

for state in statedict:
    pctreporting=[float(re.sub('[^0-9]', '', num))/100.0 for num in statedict[state]['county_votes']['pct_reporting']]
    fipslist=statedict[state]['county_votes']['location_fips']
    candidates=statedict[state]['candidates']
    statefips=getFips(state)
    for candidate in candidates:
        for x in xrange(0, len(pctreporting)):
            row=[statefips, sys.argv[1], 'NULL', candidate['cand_longname'], candidate['party'][0], statedict[state]['county_votes'][candidate['votes_field']][x], pctreporting[x], fipslist[x]]
            c.execute('REPLACE INTO results_2012 (state, office, district, name, party, votes, reporting, fips_county) VALUES (%s, %s,%s,%s,%s,%s,%s,%s)', row)
    conn.commit()
Beispiel #2
0
import dbutils
import us
from nytimesparse import getFips 
import sys

conn=dbutils.connect()
c=conn.cursor()
data=json.load(open('/home/anovikova/workspace/data/senate_exits.JSON'))
year=sys.argv[1]
states=data[year]['states']

for state in states:
    if state['state']=='US' or state['state']=='':
        fips=0
    else:
        fips=getFips(state['state'])
    for section in state['sections']:
        if section is None:
            continue
        for subsection in section['subsections']:
            if subsection['change']['party']=='dem':
                change=subsection['change']['amount']/100.0
            elif subsection['change']['party']=='rep':
                change=subsection['change']['amount']/-100.0
            else:
                change='NULL'
            try:
                other=subsection['values']['other']/100.0
            except TypeError:
                other='NULL'
            row=[fips, section['title'], subsection['title'], subsection['values']['dem']/100.0, subsection['values']['rep']/100.0, other, subsection['shareOfElectorate']/100.0, change, int(year), 'senate']