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