def find_national_scores():
getAll = school_scores.get_all()
returnVal = { }
for year in range(2005, 2016, 1):
itemDict = {}
itemDict['Sums'] = { }
itemDict['Sums']['SAT'] = 0
itemDict['Sums']['GPA'] = 0
itemDict['Sums']['SAT-Total'] = 0
itemDict['Sums']['GPA-Total'] = 0
itemDict['Averages'] = { }
itemDict['Averages']['SAT'] = 0
itemDict['Averages']['GPA'] = 0
returnVal[ str(year) ] = itemDict
for item in getAll:
itemDict = returnVal[ item['Year'] ]
itemDict['Sums']['SAT'] += (item['Total']['Verbal'] + item['Total']['Math']) * item['Total']['Test-takers']
itemDict['Sums']['SAT-Total'] += item['Total']['Test-takers']
##GPA calcs
checkerList = ['A', 'B', 'C']
for checker in checkerList:
itemDict['Sums']['GPA'] += ( 69 - ord(checker) ) * item['GPA'][checker]['Test-takers']
itemDict['Sums']['GPA-Total'] += item['GPA'][checker]['Test-takers']
for key in returnVal.keys():
itemDict = returnVal[key]
itemDict['Averages']['SAT'] = round( itemDict['Sums']['SAT'] * 1.0 / itemDict['Sums']['SAT-Total'] * 10 ) / 10
itemDict['Averages']['GPA'] = round( itemDict['Sums']['GPA'] * 1.0 / itemDict['Sums']['GPA-Total'] * 10 ) / 10
return returnVal
def main():
# returns all of the score data as a list
list_of_records = school_scores.get_all()
# 1. print out the first element
print("list_of_records[0]:\n", list_of_records[0])
for record in list_of_records:
# 2. print out the state name and year for each row in the data set
print(record["State"]["Name"], " (", record["Year"], ")", end="\t")
# 3. print out the total number of test-takers for each state per year
total_info = record["Total"]
print(total_info["Test-takers"], " test takers")
def find_state_scores(state):
getAll = school_scores.get_all()
returnVal = { }
for year in range(2005, 2016, 1):
itemDict = { }
returnVal[ str(year) ] = itemDict
for item in getAll:
if item['State']['Code'] == state:
itemDict = returnVal[str(item['Year'])]
itemDict['State'] = state
itemDict['Year'] = item['Year']
itemDict['Averages'] = {}
itemDict['Averages']['SAT'] = item['Total']['Verbal'] + item['Total']['Math']
itemDict['Averages']['GPA'] = calculate_GPA( item['GPA'] )
return returnVal
def main():
#get the data into a list
list_of_record = school_scores.get_all()
years = [
'2005', '2006', '2007', '2008', '2009', '2010', '2011', '2012', '2013',
'2014', '2015'
]
incomes = [
"Less than 20k", "Between 20-40k", "Between 40-60k", "Between 60-80k",
"Between 80-100k", "More than 100k"
]
takers_1_list = get_takers_per_income1(list_of_record)
takers_6_list = get_takers_per_income6(list_of_record)
get_table_test_takers(takers_1_list, takers_6_list, years)
import school_scores
scores_list = school_scores.get_all()
index = 0
print(scores_list[0])
test_takers = []
for row in scores_list:
#gets out state and yr
print(row["State"]["Name"], row["Year"])
for row in scores_list:
test_takers.append(row["Total"]["Test-takers"])
import school_scores
list_of_record = school_scores.get_all()
for g in list_of_record:
print(g['GPA'])
import school_scores as scores
scorelist = scores.get_all()
#for i in range(len(scorelist)):
#print(scorelist[i]['Year'])
for item in scorelist: #opens each thing
state = item["State"] #opens state in thing
statename = state["Name"] #opens name in state
year = item["Year"]
print(statename, ", ", year)
itemDict['Sums']['Illicit Drugs'] += item['Totals']['Illicit Drugs']['Dependence Past Year']['12-17']*10
itemDict['Sums']['Alcohol'] += item['Totals']['Alcohol']['Dependence Past Year']['12-17']*10
itemDict['Sums']['Population'] += item['Population']['12-17']
for key in returnVal.keys():
itemDict = returnVal[key]
itemDict['Rates']['Marijuana'] = round( itemDict['Sums']['Marijuana'] * 10000.0 / itemDict['Sums']['Population'] ) / 100
itemDict['Rates']['Illicit Drugs'] = round( itemDict['Sums']['Illicit Drugs'] * 10000.0 / itemDict['Sums']['Population'] ) / 100
itemDict['Rates']['Alcohol'] = round( itemDict['Sums']['Alcohol'] * 10000.0 / itemDict['Sums']['Population'] ) / 100
return returnVal
#print find_national_drugs()
#print find_state_drugs( 'CA' )
#--------------------------SCHOOL_SCORES---------------------------------
let_to_num = {'A':4.0, 'B':3.0, 'C':2.0, 'D':1.0, 'F':0.1}
states_school = school_scores.get_all()
def convert_scores():
overall = {}
for state in states_school:
weighted_data = []
name = state['State']['Code']
if not name in overall.keys():
overall[name] = {}
for letter in state['GPA']:
if letter in let_to_num.keys():
pt = let_to_num[letter]*400 + int(state['GPA'][letter]['Math']) + int(state['GPA'][letter]['Verbal'])
for i in range(0,int(state['GPA'][letter]['Test-takers'])/2):
weighted_data.append(pt)
overall[name][str(state['Year'])] = weighted_data
return overall
