Albert Gong was selected as one of top 300 STS scholar for 2019.

This notebook will convert the STS-book from pdf into csv, so one can easily browse data


In [1]:
# get a list of US state names from web
# save to text file="usa-states.txt"  (one per line)
# store them in mapState {key:state_name, value:line_number}
fo = open("usa-states.txt")
all_states = [l.strip().upper() for l in fo.readlines()]
fo.close()
print(all_states)


['ALABAMA', 'ALASKA', 'ARIZONA', 'ARKANSAS', 'CALIFORNIA', 'COLORADO', 'CONNECTICUT', 'DELAWARE', 'FLORIDA', 'GEORGIA', 'HAWAII', 'IDAHO', 'ILLINOIS', 'INDIANA', 'IOWA', 'KANSAS', 'KENTUCKY', 'LOUISIANA', 'MAINE', 'MARYLAND', 'MASSACHUSETTS', 'MICHIGAN', 'MINNESOTA', 'MISSISSIPPI', 'MISSOURI', 'MONTANA', 'NEBRASKA', 'NEVADA', 'NEW HAMPSHIRE', 'NEW JERSEY', 'NEW MEXICO', 'NEW YORK', 'NORTH CAROLINA', 'NORTH DAKOTA', 'OHIO', 'OKLAHOMA', 'OREGON', 'PENNSYLVANIA', 'RHODE ISLAND', 'SOUTH CAROLINA', 'SOUTH DAKOTA', 'TENNESSEE', 'TEXAS', 'UTAH', 'VERMONT', 'VIRGINIA', 'WASHINGTON', 'WEST VIRGINIA', 'WISCONSIN', 'WYOMING', 'CANADA', 'CHINA']

In [2]:
# add missing 'DISTRICT OF COLUMBIA'
all_states = ['ALABAMA', 'ALASKA', 'ARIZONA', 'ARKANSAS', 'CALIFORNIA', 'COLORADO', 'CONNECTICUT', 'DELAWARE', 'DISTRICT OF COLUMBIA', 'FLORIDA', 'GEORGIA', 'HAWAII', 'IDAHO', 'ILLINOIS', 'INDIANA', 'IOWA', 'KANSAS', 'KENTUCKY', 'LOUISIANA', 'MAINE', 'MARYLAND', 'MASSACHUSETTS', 'MICHIGAN', 'MINNESOTA', 'MISSISSIPPI', 'MISSOURI', 'MONTANA', 'NEBRASKA', 'NEVADA', 'NEW HAMPSHIRE', 'NEW JERSEY', 'NEW MEXICO', 'NEW YORK', 'NORTH CAROLINA', 'NORTH DAKOTA', 'OHIO', 'OKLAHOMA', 'OREGON', 'PENNSYLVANIA', 'RHODE ISLAND', 'SOUTH CAROLINA', 'SOUTH DAKOTA', 'TENNESSEE', 'TEXAS', 'UTAH', 'VERMONT', 'VIRGINIA', 'WASHINGTON', 'WEST VIRGINIA', 'WISCONSIN', 'WYOMING', 'CANADA', 'CHINA']

In [3]:
mapState = {}
for l in all_states:
    state = l.upper().strip()
    #print(state)
    mapState[state] = -1

mapState.keys()


Out[3]:
dict_keys(['ALABAMA', 'ALASKA', 'ARIZONA', 'ARKANSAS', 'CALIFORNIA', 'COLORADO', 'CONNECTICUT', 'DELAWARE', 'DISTRICT OF COLUMBIA', 'FLORIDA', 'GEORGIA', 'HAWAII', 'IDAHO', 'ILLINOIS', 'INDIANA', 'IOWA', 'KANSAS', 'KENTUCKY', 'LOUISIANA', 'MAINE', 'MARYLAND', 'MASSACHUSETTS', 'MICHIGAN', 'MINNESOTA', 'MISSISSIPPI', 'MISSOURI', 'MONTANA', 'NEBRASKA', 'NEVADA', 'NEW HAMPSHIRE', 'NEW JERSEY', 'NEW MEXICO', 'NEW YORK', 'NORTH CAROLINA', 'NORTH DAKOTA', 'OHIO', 'OKLAHOMA', 'OREGON', 'PENNSYLVANIA', 'RHODE ISLAND', 'SOUTH CAROLINA', 'SOUTH DAKOTA', 'TENNESSEE', 'TEXAS', 'UTAH', 'VERMONT', 'VIRGINIA', 'WASHINGTON', 'WEST VIRGINIA', 'WISCONSIN', 'WYOMING', 'CANADA', 'CHINA'])

In [4]:
# text file "STS-books-2019__2.txt" is copy-and-pasted out from the PDF
# set line_number for each state

fo2 = open("STS-books-2019__2.txt")
alllines = fo2.readlines()
fo2.close()

iline = 0
for l in alllines:
    tmp = l.upper().strip()
    if tmp in mapState.keys():
        mapState[tmp] = iline

    iline += 1

In [5]:
# if a state has value = -1, it means no student from that state was selected as scholar
print(mapState)


{'ALABAMA': 0, 'ALASKA': -1, 'ARIZONA': 5, 'ARKANSAS': 15, 'CALIFORNIA': 20, 'COLORADO': 159, 'CONNECTICUT': 163, 'DELAWARE': 177, 'DISTRICT OF COLUMBIA': 184, 'FLORIDA': 188, 'GEORGIA': 207, 'HAWAII': -1, 'IDAHO': -1, 'ILLINOIS': 215, 'INDIANA': 222, 'IOWA': 227, 'KANSAS': 232, 'KENTUCKY': 236, 'LOUISIANA': 248, 'MAINE': 255, 'MARYLAND': 264, 'MASSACHUSETTS': 327, 'MICHIGAN': 377, 'MINNESOTA': 393, 'MISSISSIPPI': -1, 'MISSOURI': 406, 'MONTANA': -1, 'NEBRASKA': 425, 'NEVADA': -1, 'NEW HAMPSHIRE': 429, 'NEW JERSEY': 441, 'NEW MEXICO': -1, 'NEW YORK': 491, 'NORTH CAROLINA': 815, 'NORTH DAKOTA': -1, 'OHIO': 833, 'OKLAHOMA': 848, 'OREGON': 859, 'PENNSYLVANIA': 877, 'RHODE ISLAND': -1, 'SOUTH CAROLINA': 894, 'SOUTH DAKOTA': -1, 'TENNESSEE': 903, 'TEXAS': 920, 'UTAH': 957, 'VERMONT': -1, 'VIRGINIA': 962, 'WASHINGTON': 1001, 'WEST VIRGINIA': 1006, 'WISCONSIN': 1010, 'WYOMING': -1, 'CANADA': 1014, 'CHINA': 1018}

In [6]:
# store State into a list maintaining its order in PDF
lstState = []
for k,v in mapState.items():
    #print(k,v)
    if v == -1:
        continue
    lstState.append(k)

In [7]:
print(lstState)


['ALABAMA', 'ARIZONA', 'ARKANSAS', 'CALIFORNIA', 'COLORADO', 'CONNECTICUT', 'DELAWARE', 'DISTRICT OF COLUMBIA', 'FLORIDA', 'GEORGIA', 'ILLINOIS', 'INDIANA', 'IOWA', 'KANSAS', 'KENTUCKY', 'LOUISIANA', 'MAINE', 'MARYLAND', 'MASSACHUSETTS', 'MICHIGAN', 'MINNESOTA', 'MISSOURI', 'NEBRASKA', 'NEW HAMPSHIRE', 'NEW JERSEY', 'NEW YORK', 'NORTH CAROLINA', 'OHIO', 'OKLAHOMA', 'OREGON', 'PENNSYLVANIA', 'SOUTH CAROLINA', 'TENNESSEE', 'TEXAS', 'UTAH', 'VIRGINIA', 'WASHINGTON', 'WEST VIRGINIA', 'WISCONSIN', 'CANADA', 'CHINA']

In [8]:
# mapState2 tracks end-of-line-number for a given state
mapState2 = {}
for i in range(len(lstState)):
    if i == len(lstState)-1:
        mapState2[lstState[i]] = len(alllines)
    else:
        mapState2[lstState[i]] = mapState[lstState[i+1]]

In [9]:
print(mapState2)


{'ALABAMA': 5, 'ARIZONA': 15, 'ARKANSAS': 20, 'CALIFORNIA': 159, 'COLORADO': 163, 'CONNECTICUT': 177, 'DELAWARE': 184, 'DISTRICT OF COLUMBIA': 188, 'FLORIDA': 207, 'GEORGIA': 215, 'ILLINOIS': 222, 'INDIANA': 227, 'IOWA': 232, 'KANSAS': 236, 'KENTUCKY': 248, 'LOUISIANA': 255, 'MAINE': 264, 'MARYLAND': 327, 'MASSACHUSETTS': 377, 'MICHIGAN': 393, 'MINNESOTA': 406, 'MISSOURI': 425, 'NEBRASKA': 429, 'NEW HAMPSHIRE': 441, 'NEW JERSEY': 491, 'NEW YORK': 815, 'NORTH CAROLINA': 833, 'OHIO': 848, 'OKLAHOMA': 859, 'OREGON': 877, 'PENNSYLVANIA': 894, 'SOUTH CAROLINA': 903, 'TENNESSEE': 920, 'TEXAS': 957, 'UTAH': 962, 'VIRGINIA': 1001, 'WASHINGTON': 1006, 'WEST VIRGINIA': 1010, 'WISCONSIN': 1014, 'CANADA': 1018, 'CHINA': 1022}

In [10]:
# split original text file by state
for state in mapState2.keys():
    filename = "%s.txt" % (state,)
    fo4 = open(filename, "w")
    fo4.write("".join(alllines[(mapState[state]+1):mapState2[state]]))
fo4.close()

In [11]:
# detect and parse the line with student name/age
def match_student(student):
    import re
    matchObj = re.match(r"(.*), (.*), (\d+)", student)
    if matchObj:
       #print ("matchObj.group() : ", matchObj.group())
       #print ("matchObj.group(1) : ", matchObj.group(1))
       #print ("matchObj.group(2) : ", matchObj.group(2))
       #print ("matchObj.group(3) : ", matchObj.group(3)) 
        return [matchObj.group(1), matchObj.group(2), matchObj.group(3)]
    else:
        return [student]

In [12]:
#mapSchool = {}
#mapStudent = {}

In [13]:
# map to store project_title, key="state#school#student" 
mapProject = {}

for state in mapState2.keys():
    #state = "FLORIDA"
    filename = "%s.txt" % (state,)
    fo5 = open(filename)
    data = fo5.readlines()
    fo5.close()

    #data

    i = -1
    for d in data:
        i += 1
        if len(d.strip()) < 1:
            continue  # skip blank line
        if "SCHOOL" in d.upper() or "ACADEM" in d.upper():
            school = d.strip()
            #mapSchool[school] = i
            continue
        student_info = match_student(d)
        if len(student_info) == 3:
            student = "_".join(student_info)
            #mapStudent[student] = i
            key = state+"#"+school+"#"+student
            mapProject[key] = []
            continue
        project = d.strip()
        print("key= ", key)
        mapProject[key].append(project)


key=  ALABAMA#Auburn Auburn High School#Lange_Noel_18
key=  ALABAMA#Auburn Auburn High School#Lange_Noel_18
key=  ARIZONA#Chandler Hamilton High School#Dani_Samihan_17
key=  ARIZONA#Chandler Hamilton High School#Dani_Samihan_17
key=  ARIZONA#Chandler Hamilton High School#Long_Mindy_18
key=  ARIZONA#Scottsdale BASIS Scottsdale (School)#Narayan_Saaketh_18
key=  ARKANSAS#Hot Springs Arkansas School for Mathematics Science & the Arts#Jia_Mary_17
key=  ARKANSAS#Hot Springs Arkansas School for Mathematics Science & the Arts#Jia_Mary_17
key=  CALIFORNIA#Atherton Menlo School#Kim_John_17
key=  CALIFORNIA#Menlo-Atherton High School#Quinlan_Anna_17
key=  CALIFORNIA#Menlo-Atherton High School#Quinlan_Anna_17
key=  CALIFORNIA#Cupertino Cupertino High School#Varghese_Leah_17
key=  CALIFORNIA#Cupertino Cupertino High School#Varghese_Leah_17
key=  CALIFORNIA#Homestead High School#Mishra_Reet_18
key=  CALIFORNIA#Homestead High School#Mishra_Reet_18
key=  CALIFORNIA#Monta Vista High School#Kamarshi_Vivek_18
key=  CALIFORNIA#Monta Vista High School#Kamarshi_Vivek_18
key=  CALIFORNIA#Dublin Dublin High School#Pajjuri_Mallika_17
key=  CALIFORNIA#Dublin Dublin High School#Pajjuri_Mallika_17
key=  CALIFORNIA#Fremont Mission San Jose High School#Ko_Jonathan_18
key=  CALIFORNIA#Hemet Western Center Academy(School)#Horton_Krystal_17
key=  CALIFORNIA#Irvine University High School#Jiang_Lan_18
key=  CALIFORNIA#Irvine University High School#Jiang_Lan_18
key=  CALIFORNIA#Irvine University High School#Liu_Patrick_18
key=  CALIFORNIA#Irvine University High School#Liu_Patrick_18
key=  CALIFORNIA#Irvine University High School#Zhong_Amy_17
key=  CALIFORNIA#Irvine University High School#Zhong_Amy_17
key=  CALIFORNIA#Irvine University High School#Zou_Joshua_17
key=  CALIFORNIA#Irvine University High School#Zou_Joshua_17
key=  CALIFORNIA#Woodbridge High School#Kopecky_Morgan_17
key=  CALIFORNIA#Woodbridge High School#Kopecky_Morgan_17
key=  CALIFORNIA#La Crescenta Crescenta Valley High School#Co Ting Keh_Lyron_17
key=  CALIFORNIA#La Crescenta Crescenta Valley High School#Co Ting Keh_Lyron_17
key=  CALIFORNIA#Los Altos Los Altos High School#Shi_Yongxin_17
key=  CALIFORNIA#Los Altos Los Altos High School#Shi_Yongxin_17
key=  CALIFORNIA#Los Angeles Yeshiva University High School of Los Angeles#Willner_Ari_17
key=  CALIFORNIA#Los Angeles Yeshiva University High School of Los Angeles#Willner_Ari_17
key=  CALIFORNIA#Los Angeles Yeshiva University High School of Los Angeles#Willner_Ari_17
key=  CALIFORNIA#Mission Viejo Trabuco Hills High School#Desai_Rishi_18
key=  CALIFORNIA#Mountain View St. Francis High School#Karthik_Ananya_17
key=  CALIFORNIA#Newport Beach Sage Hill School#Sheen_Grant_17
key=  CALIFORNIA#Newport Beach Sage Hill School#Sheen_Grant_17
key=  CALIFORNIA#North Hollywood North Hollywood High School#Michaels_Tai_17
key=  CALIFORNIA#North Hollywood North Hollywood High School#Michaels_Tai_17
key=  CALIFORNIA#Palo Alto Palo Alto High School#Xie_Anthony_17
key=  CALIFORNIA#San Diego Canyon Crest Academy#Huang_Allen_18
key=  CALIFORNIA#San Diego Canyon Crest Academy#Roy_Ronak_17
key=  CALIFORNIA#San Diego Canyon Crest Academy#Situ_Julia_18
key=  CALIFORNIA#San Diego Canyon Crest Academy#Situ_Julia_18
key=  CALIFORNIA#Del Norte High School#Krishnamoorthy_Vinod_17
key=  CALIFORNIA#Del Norte High School#Krishnamoorthy_Vinod_17
key=  CALIFORNIA#San Jose The Harker School#Alag_Ayush_17
key=  CALIFORNIA#San Jose The Harker School#Alag_Ayush_17
key=  CALIFORNIA#San Jose The Harker School#Jones_Cameron_17
key=  CALIFORNIA#San Jose The Harker School#Jones_Cameron_17
key=  CALIFORNIA#San Jose The Harker School#Maniar_Natasha_17
key=  CALIFORNIA#San Jose The Harker School#Maniar_Natasha_17
key=  CALIFORNIA#San Jose The Harker School#Sayana_Ruhi_17
key=  CALIFORNIA#San Jose The Harker School#Sayana_Ruhi_17
key=  CALIFORNIA#San Jose The Harker School#Tian_Katherine_17
key=  CALIFORNIA#San Jose The Harker School#Tian_Katherine_17
key=  CALIFORNIA#San Jose The Harker School#Wang_Cindy_17
key=  CALIFORNIA#San Jose The Harker School#Wang_Cindy_17
key=  CALIFORNIA#San Jose The Harker School#Wang_Richard_17
key=  CALIFORNIA#San Jose The Harker School#Wang_Richard_17
key=  CALIFORNIA#Leland High School#Lin_Brian_17
key=  CALIFORNIA#Leland High School#Lin_Brian_17
key=  CALIFORNIA#Leland High School#Lin_Jerry_17
key=  CALIFORNIA#Leland High School#Lin_Jerry_17
key=  CALIFORNIA#Lynbrook High School#Heh_Shannon_17
key=  CALIFORNIA#Lynbrook High School#Huang_Charles_17
key=  CALIFORNIA#Lynbrook High School#Huang_Charles_17
key=  CALIFORNIA#Lynbrook High School#Singh_Amol_18
key=  CALIFORNIA#Lynbrook High School#Singh_Amol_18
key=  CALIFORNIA#Lynbrook High School#Wang_Stanley_18
key=  CALIFORNIA#Lynbrook High School#Wang_Stanley_18
key=  CALIFORNIA#Lynbrook High School#Wang_Stanley_18
key=  CALIFORNIA#Lynbrook High School#Wang_Stanley_18
key=  CALIFORNIA#Santa Barbara San Marcos High School#Campagnari_Bianca_18
key=  CALIFORNIA#Yorba Linda Yorba Linda High School#Song_Andrew_18
key=  COLORADO#Monte Vista Monte Vista High School#Rawinski_Alyssa_17
key=  CONNECTICUT#Greenwich Greenwich Academy#Laumas_Anisha_18
key=  CONNECTICUT#Greenwich High School#Hawley_Bennett_17
key=  CONNECTICUT#Greenwich High School#Hawley_Bennett_17
key=  CONNECTICUT#Wallingford Choate Rosemary Hall(School)#Koljaka_Sarah_17
key=  CONNECTICUT#Wallingford Choate Rosemary Hall(School)#Lee_Se Ri_17
key=  CONNECTICUT#Wallingford Choate Rosemary Hall(School)#Lee_Se Ri_17
key=  DELAWARE#Wilmington Charter School of Wilmington#Krishnamani_Preeti_17
key=  DELAWARE#Wilmington Charter School of Wilmington#Lu_Grant_17
key=  DELAWARE#Wilmington Charter School of Wilmington#Lu_Grant_17
key=  DISTRICT OF COLUMBIA#Washington School Without Walls#Lossef_Sam_17
key=  FLORIDA#Boca Raton Florida Atlantic University High School#Herbst_Hannah_18
key=  FLORIDA#Boca Raton Florida Atlantic University High School#Herbst_Hannah_18
key=  FLORIDA#Boca Raton Florida Atlantic University High School#Suthakaran_Vithulan_18
key=  FLORIDA#Boca Raton Florida Atlantic University High School#Suthakaran_Vithulan_18
key=  FLORIDA#Miami Dr. Michael M. Krop High School#Gottlieb_Olivia_17
key=  FLORIDA#Osprey Pine View School#Zhu_Kevin_17
key=  FLORIDA#Osprey Pine View School#Zhu_Kevin_17
key=  FLORIDA#Plantation American Heritage School#DiStefano_Nicholas_18
key=  FLORIDA#Plantation American Heritage School#DiStefano_Nicholas_18
key=  GEORGIA#Atlanta Lakeside High School#Weiss_Zoe_17
key=  GEORGIA#College Park Woodward Academy#Hallas_Sydney_18
key=  GEORGIA#College Park Woodward Academy#Hallas_Sydney_18
key=  ILLINOIS#Aurora Illinois Mathematics and Science Academy#Ren_Jimmy_17
key=  ILLINOIS#Naperville Neuqua Valley High School#Porter_Imani_17
key=  INDIANA#Carmel Carmel High School#Jou_Parker_17
key=  INDIANA#Carmel Carmel High School#Jou_Parker_17
key=  IOWA#Fairfield	 Maharishi School#Chhaliyil_Pranav_18
key=  IOWA#Fairfield	 Maharishi School#Chhaliyil_Pranav_18
key=  KANSAS#Overland Park Blue Valley Northwest High School#Wang_William_17
key=  KENTUCKY#Bowling Green The Gatton Academy of Mathematics and Science in Kentucky#Wheeler_Sydney_18
key=  KENTUCKY#Bowling Green The Gatton Academy of Mathematics and Science in Kentucky#Wheeler_Sydney_18
key=  KENTUCKY#Bowling Green The Gatton Academy of Mathematics and Science in Kentucky#Wheeler_Sydney_18
key=  KENTUCKY#Bowling Green The Gatton Academy of Mathematics and Science in Kentucky#Wheeler_Sydney_18
key=  KENTUCKY#Paul Laurence Dunbar High School#Seevers_Rachel_17
key=  KENTUCKY#Paul Laurence Dunbar High School#Seevers_Rachel_17
key=  LOUISIANA#Baton Rouge Baton Rouge Magnet High School#Zaman_Anu_18
key=  LOUISIANA#Covington St. Paul’s School#Devier_Joshua_17
key=  MAINE#Bangor Bangor High School#Robinson_Noah_18
key=  MAINE#Bangor Bangor High School#Robinson_Noah_18
key=  MAINE#Bangor Bangor High School#Robinson_Noah_18
key=  MAINE#Bangor Bangor High School#Robinson_Noah_18
key=  MAINE#Bangor Bangor High School#Robinson_Noah_18
key=  MARYLAND#Baltimore Baltimore Polytechnic Institute (School)#Mokaya_Michelle_17
key=  MARYLAND#Baltimore Baltimore Polytechnic Institute (School)#Mokaya_Michelle_17
key=  MARYLAND#Gilman School#Duh_Alexander_18
key=  MARYLAND#Gilman School#Duh_Alexander_18
key=  MARYLAND#Great Mills Great Mills High School#Lindholm_Adam_18
key=  MARYLAND#Great Mills Great Mills High School#Lindholm_Adam_18
key=  MARYLAND#Ijamsville Urbana High School#Yu_Joshua_17
key=  MARYLAND#Marriottsville Marriotts Ridge High School#Herath_Isuru_17
key=  MARYLAND#Poolesville Poolesville High School#Bian_Vincent_18
key=  MARYLAND#Poolesville Poolesville High School#Chen_Peiqi_18
key=  MARYLAND#Poolesville Poolesville High School#Shastri_Ishana_17
key=  MARYLAND#Poolesville Poolesville High School#Shastri_Ishana_17
key=  MARYLAND#Potomac Winston Churchill High School#Brixi_Garyk_18
key=  MARYLAND#Potomac Winston Churchill High School#Brixi_Garyk_18
key=  MARYLAND#Potomac Winston Churchill High School#Ma_Jessie_17
key=  MARYLAND#Rockville Richard Montgomery High School#Han_Ivy_18
key=  MARYLAND#Rockville Richard Montgomery High School#Han_Ivy_18
key=  MARYLAND#Rockville Richard Montgomery High School#Shi_Tesia_17
key=  MARYLAND#Rockville Richard Montgomery High School#Shi_Tesia_17
key=  MARYLAND#Rockville Richard Montgomery High School#Shi_Tesia_17
key=  MARYLAND#Rockville Richard Montgomery High School#Shi_Tesia_17
key=  MARYLAND#Silver Spring Montgomery Blair High School#Borton_Allison_18
key=  MARYLAND#Silver Spring Montgomery Blair High School#Cai_Grace_17
key=  MARYLAND#Silver Spring Montgomery Blair High School#Cai_Grace_17
key=  MARYLAND#Silver Spring Montgomery Blair High School#Cui_Laura_17
key=  MARYLAND#Silver Spring Montgomery Blair High School#Durvasula_Naveen_17
key=  MARYLAND#Silver Spring Montgomery Blair High School#Durvasula_Naveen_17
key=  MARYLAND#Silver Spring Montgomery Blair High School#Qian_Kevin_18
key=  MARYLAND#Silver Spring Montgomery Blair High School#Qian_Kevin_18
key=  MARYLAND#Silver Spring Montgomery Blair High School#Qu_Steven_17
key=  MARYLAND#Silver Spring Montgomery Blair High School#Schäffer_Daniel_17
key=  MARYLAND#Silver Spring Montgomery Blair High School#Schäffer_Daniel_17
key=  MARYLAND#Silver Spring Montgomery Blair High School#Zhu_Daniel_17
key=  MASSACHUSETTS#Acton Acton-Boxborough Regional High School#Bhat_Sanjit_17
key=  MASSACHUSETTS#Acton Acton-Boxborough Regional High School#Kasar_Atharva_18
key=  MASSACHUSETTS#Acton Acton-Boxborough Regional High School#Kasar_Atharva_18
key=  MASSACHUSETTS#Andover Phillips Academy#Chang_Justin_18
key=  MASSACHUSETTS#Andover Phillips Academy#Chang_Justin_18
key=  MASSACHUSETTS#Andover Phillips Academy#Hou_Kaiying_18
key=  MASSACHUSETTS#Andover Phillips Academy#Hou_Kaiying_18
key=  MASSACHUSETTS#Andover Phillips Academy#Hou_Kaiying_18
key=  MASSACHUSETTS#Andover Phillips Academy#Hou_Kaiying_18
key=  MASSACHUSETTS#Belmont Belmont Hill School#Daley_Nicholas_17
key=  MASSACHUSETTS#Belmont Belmont Hill School#Daley_Nicholas_17
key=  MASSACHUSETTS#Boston The Winsor School#Su_Angela_17
key=  MASSACHUSETTS#Boston The Winsor School#Su_Angela_17
key=  MASSACHUSETTS#Brookline Brookline High School#Chow_Yuen Ting_17
key=  MASSACHUSETTS#Brookline Brookline High School#Xu_Frank_17
key=  MASSACHUSETTS#Concord Middlesex School#Dong_Zhengyang_18
key=  MASSACHUSETTS#Lexington Lexington High School#Chen_Robert_18
key=  MASSACHUSETTS#Lexington Lexington High School#Yoo_Seo-Hyun_18
key=  MASSACHUSETTS#Lexington Lexington High School#Yoo_Seo-Hyun_18
key=  MASSACHUSETTS#Sharon Sharon High School#Ravikumar_Akshaya_17
key=  MASSACHUSETTS#Sheffield	 Berkshire School#Lebenthal_Avalon_18
key=  MASSACHUSETTS#Sheffield	 Berkshire School#Tian_Daniel_18
key=  MASSACHUSETTS#Worcester Massachusetts Academy of Math & Science#Srivastava_Shashvat_17
key=  MASSACHUSETTS#Worcester Massachusetts Academy of Math & Science#Srivastava_Shashvat_17
key=  MICHIGAN#Ann Arbor Ann Arbor Pioneer High School#Suresh_Arundhathy_17
key=  MICHIGAN#Beverly Hills Detroit Country Day School#Yang_Madeleine_17
key=  MICHIGAN#Beverly Hills Detroit Country Day School#Yang_Madeleine_17
key=  MICHIGAN#Bloomfield Hills	 Cranbrook Kingswood School#Tan_Matthew_18
key=  MICHIGAN#Bloomfield Hills	 Cranbrook Kingswood School#Tan_Matthew_18
key=  MICHIGAN#Port Huron Port Huron Northern High School#Tumma_Neehal_17
key=  MICHIGAN#Port Huron Port Huron Northern High School#Tumma_Neehal_17
key=  MINNESOTA#Minnetonka Minnetonka High School#Krishna_Parthiv_17
key=  MINNESOTA#Minnetonka Minnetonka High School#Krishna_Parthiv_17
key=  MINNESOTA#Rochester Century High School#Mai_Michelle_17
key=  MINNESOTA#Rochester Century High School#Mai_Michelle_17
key=  MINNESOTA#Stillwater Stillwater Senior High School#Jostes_Haley_18
key=  MINNESOTA#Stillwater Stillwater Senior High School#Jostes_Haley_18
key=  MISSOURI#Ballwin Parkway West High School#Tomala_Neil_17
key=  MISSOURI#Ballwin Parkway West High School#Tomala_Neil_17
key=  MISSOURI#Columbia Rock Bridge High School#Anand_Kavin_17
key=  MISSOURI#Columbia Rock Bridge High School#Anand_Kavin_17
key=  MISSOURI#Kansas City Pembroke Hill School#Case_Paul_18
key=  MISSOURI#Saint Louis Ladue Horton Watkins High School#Jiang_Kevin_18
key=  MISSOURI#Saint Louis Ladue Horton Watkins High School#Jiang_Kevin_18
key=  MISSOURI#Springfield	 Central High School#Lu_Katie_17
key=  NEBRASKA#Omaha Millard North High School#Subramaniam_Vighnesh_18
key=  NEW HAMPSHIRE#Durham Oyster River High School#Kantipudi_Rohit_17
key=  NEW HAMPSHIRE#Durham Oyster River High School#Kantipudi_Rohit_17
key=  NEW HAMPSHIRE#Exeter Phillips Exeter Academy#Chi_Sun-Yu Gordon_18
key=  NEW HAMPSHIRE#Exeter Phillips Exeter Academy#Chi_Sun-Yu Gordon_18
key=  NEW HAMPSHIRE#Nashua Nashua High School South#Sathyamurthi_Tejas_17
key=  NEW JERSEY#Chatham Chatham High School#Andrews_Sophie_17
key=  NEW JERSEY#Colonia Colonia High School#Fantell_Gianna_18
key=  NEW JERSEY#Colonia Colonia High School#Fantell_Gianna_18
key=  NEW JERSEY#Colonia Colonia High School#Shah_Sharmi_17
key=  NEW JERSEY#Hackensack Bergen County Academies(School)#Karam_Julie_18
key=  NEW JERSEY#Hackensack Bergen County Academies(School)#Kudrin_Bertina_18
key=  NEW JERSEY#Hackensack Bergen County Academies(School)#Kudrin_Bertina_18
key=  NEW JERSEY#Hackensack Bergen County Academies(School)#Kumar_Varun_17
key=  NEW JERSEY#Hackensack Bergen County Academies(School)#Mao_Maiya_17
key=  NEW JERSEY#Hackensack Bergen County Academies(School)#Mao_Maiya_17
key=  NEW JERSEY#Hackensack Bergen County Academies(School)#Shi_Caleb_17
key=  NEW JERSEY#Hackensack Bergen County Academies(School)#Shi_Caleb_17
key=  NEW JERSEY#Hackensack Bergen County Academies(School)#Woo_Yena_18
key=  NEW JERSEY#Holmdel Holmdel High School#Ahteck_Amanda_17
key=  NEW JERSEY#Holmdel Holmdel High School#Ahteck_Amanda_17
key=  NEW JERSEY#Jersey City Dr. Ronald E. McNair Academic High School#Agrawal_Harshal_17
key=  NEW JERSEY#Jersey City Dr. Ronald E. McNair Academic High School#Agrawal_Harshal_17
key=  NEW JERSEY#Jersey City Dr. Ronald E. McNair Academic High School#Agrawal_Harshal_17
key=  NEW JERSEY#Lawrenceville Lawrenceville School#Wu_Jacob_17
key=  NEW JERSEY#Livingston Livingston High School#Chen_Alan_18
key=  NEW JERSEY#Livingston Livingston High School#Chen_Alan_18
key=  NEW JERSEY#Livingston Livingston High School#Chen_Alan_18
key=  NEW JERSEY#Morristown Delbarton School#Zhong_Kevin_18
key=  NEW JERSEY#Morristown Delbarton School#Zhong_Kevin_18
key=  NEW JERSEY#West Windsor West Windsor-Plainsboro High School South#Ferguson_Samuel_18
key=  NEW YORK#Albany The Albany Academies#Huang_Zachary_17
key=  NEW YORK#Albany The Albany Academies#Huang_Zachary_17
key=  NEW YORK#Ardsley Ardsley High School#Rivera_Alexandra_17
key=  NEW YORK#Ardsley Ardsley High School#Rivera_Alexandra_17
key=  NEW YORK#Armonk Byram Hills High School#Abbruzzese_Samantha_17
key=  NEW YORK#Armonk Byram Hills High School#Abbruzzese_Samantha_17
key=  NEW YORK#Armonk Byram Hills High School#Chang_Alan_17
key=  NEW YORK#Armonk Byram Hills High School#Chang_Alan_17
key=  NEW YORK#Armonk Byram Hills High School#Chernoff_Rachel_17
key=  NEW YORK#Armonk Byram Hills High School#Colella-Albino_Alessandra_18
key=  NEW YORK#Armonk Byram Hills High School#Jacobs_Ethan_17
key=  NEW YORK#Armonk Byram Hills High School#Jacobs_Ethan_17
key=  NEW YORK#Armonk Byram Hills High School#Perlman_Brent_17
key=  NEW YORK#Armonk Byram Hills High School#Perlman_Brent_17
key=  NEW YORK#Armonk Byram Hills High School#Schwam_Jonah_18
key=  NEW YORK#Armonk Byram Hills High School#Schwam_Jonah_18
key=  NEW YORK#Armonk Byram Hills High School#Schwam_Jonah_18
key=  NEW YORK#Bellmore John F. Kennedy High School#Levine_Jake_18
key=  NEW YORK#Bellmore John F. Kennedy High School#Levine_Jake_18
key=  NEW YORK#Bellmore John F. Kennedy High School#Mashal_Jonathan_17
key=  NEW YORK#Bellmore John F. Kennedy High School#Mashal_Jonathan_17
key=  NEW YORK#Bellmore John F. Kennedy High School#Sussman_Whitney_17
key=  NEW YORK#Brentwood Brentwood High School – Sonderling Center#Perez_Ahmad_17
key=  NEW YORK#Brentwood Brentwood High School – Sonderling Center#Perez_Ahmad_17
key=  NEW YORK#Briarcliff Manor Briarcliff High School#Daefler_Anna-Samsara_17
key=  NEW YORK#Bronx Bronx High School of Science#Aharonian_Leon_18
key=  NEW YORK#Bronx Bronx High School of Science#Aharonian_Leon_18
key=  NEW YORK#Bronx Bronx High School of Science#Brous_Daniel_18
key=  NEW YORK#Bronx Bronx High School of Science#Brous_Daniel_18
key=  NEW YORK#Bronx Bronx High School of Science#Chen_Alex_17
key=  NEW YORK#Bronx Bronx High School of Science#Chen_Alex_17
key=  NEW YORK#Bronx Bronx High School of Science#Chen_William_17
key=  NEW YORK#Bronx Bronx High School of Science#Chen_William_17
key=  NEW YORK#Bronx Bronx High School of Science#Doraid_Joseph_17
key=  NEW YORK#Bronx Bronx High School of Science#Doraid_Joseph_17
key=  NEW YORK#Bronx Bronx High School of Science#Felmus_Nathan_17
key=  NEW YORK#Bronx Bronx High School of Science#Felmus_Nathan_17
key=  NEW YORK#Bronx Bronx High School of Science#Frajmund_Chloe_18
key=  NEW YORK#Schools and HIV Outcomes in the Southern States of the United States#Kalra_Anika_17
key=  NEW YORK#Schools and HIV Outcomes in the Southern States of the United States#Khmelnitsky_Olga_18
key=  NEW YORK#Schools and HIV Outcomes in the Southern States of the United States#Khmelnitsky_Olga_18
key=  NEW YORK#Schools and HIV Outcomes in the Southern States of the United States#Lee_Yea Won_18
key=  NEW YORK#Schools and HIV Outcomes in the Southern States of the United States#Lee_Yea Won_18
key=  NEW YORK#Schools and HIV Outcomes in the Southern States of the United States#Liu_Annie_17
key=  NEW YORK#Schools and HIV Outcomes in the Southern States of the United States#Liu_Annie_17
key=  NEW YORK#Schools and HIV Outcomes in the Southern States of the United States#Liu_Annie_17
key=  NEW YORK#Schools and HIV Outcomes in the Southern States of the United States#Liu_Kevin_17
key=  NEW YORK#Schools and HIV Outcomes in the Southern States of the United States#Zerof_Eli_18
key=  NEW YORK#Chappaqua Horace Greeley High School#Kumar_Chirag_17
key=  NEW YORK#Chappaqua Horace Greeley High School#Kumar_Chirag_17
key=  NEW YORK#Chappaqua Horace Greeley High School#Singh_Aditi_17
key=  NEW YORK#Chappaqua Horace Greeley High School#Singh_Aditi_17
key=  NEW YORK#Chappaqua Horace Greeley High School#Zhang_Anna_17
key=  NEW YORK#Chappaqua Horace Greeley High School#Zhang_Anna_17
key=  NEW YORK#Commack Commack High School#Muthukumar_Pragati_18
key=  NEW YORK#Cortlandt Manor Walter Panas High School#Bhandarkar_Riti_17
key=  NEW YORK#Cross River John Jay High School#Sherr_Heather_17
key=  NEW YORK#Cross River John Jay High School#Sherr_Heather_17
key=  NEW YORK#Croton-on-Hudson Croton-Harmon High School#Stok_Melissa_18
key=  NEW YORK#Croton-on-Hudson Croton-Harmon High School#Stok_Melissa_18
key=  NEW YORK#Dix Hills Half Hollow Hills High School East#Bhansali_Rinni_17
key=  NEW YORK#Dix Hills Half Hollow Hills High School East#Weltmann_Matthew_17
key=  NEW YORK#Dix Hills Half Hollow Hills High School East#Weltmann_Matthew_17
key=  NEW YORK#East Setauket Ward Melville High School#Ge_Kelsey_17
key=  NEW YORK#East Setauket Ward Melville High School#Peña-Lobel_Maya_17
key=  NEW YORK#East Setauket Ward Melville High School#Peña-Lobel_Maya_17
key=  NEW YORK#East Setauket Ward Melville High School#Specht_Megan_18
key=  NEW YORK#East Setauket Ward Melville High School#Specht_Megan_18
key=  NEW YORK#East Setauket Ward Melville High School#Wang_Elizabeth_18
key=  NEW YORK#East Setauket Ward Melville High School#Wang_Elizabeth_18
key=  NEW YORK#Farmingville Sachem High School East#Zhang_Vincent_17
key=  NEW YORK#Farmingville Sachem High School East#Zhang_Vincent_17
key=  NEW YORK#Great Neck John L. Miller Great Neck North High School#Geula_Aaron_17
key=  NEW YORK#Great Neck John L. Miller Great Neck North High School#Geula_Aaron_17
key=  NEW YORK#Great Neck John L. Miller Great Neck North High School#Goh_Michelle_18
key=  NEW YORK#Great Neck John L. Miller Great Neck North High School#Goh_Michelle_18
key=  NEW YORK#Great Neck John L. Miller Great Neck North High School#Lu_Christopher_17
key=  NEW YORK#Great Neck John L. Miller Great Neck North High School#Rothbaum_Joshua_17
key=  NEW YORK#Great Neck John L. Miller Great Neck North High School#Rothbaum_Joshua_17
key=  NEW YORK#William A. Shine Great Neck South High School#Wang_Ethan_17
key=  NEW YORK#William A. Shine Great Neck South High School#Wang_Ethan_17
key=  NEW YORK#Hewlett George W. Hewlett High School#Bogdanov_Samuel_17
key=  NEW YORK#Hewlett George W. Hewlett High School#Bogdanov_Samuel_17
key=  NEW YORK#Hewlett George W. Hewlett High School#Grossman_Julia_17
key=  NEW YORK#Hewlett George W. Hewlett High School#Grossman_Julia_17
key=  NEW YORK#Hewlett George W. Hewlett High School#Yue_Siyuan_17
key=  NEW YORK#Hewlett George W. Hewlett High School#Yue_Siyuan_17
key=  NEW YORK#Irvington Irvington High School#Dunefsky_Jacob_17
key=  NEW YORK#Irvington Irvington High School#Horowitz_Annie_18
key=  NEW YORK#Jericho Jericho Senior High School#Hu_Jiaxuan_17
key=  NEW YORK#Jericho Jericho Senior High School#Hu_Jiaxuan_17
key=  NEW YORK#Jericho Jericho Senior High School#Pahlavan_Arianna_17
key=  NEW YORK#Jericho Jericho Senior High School#Shah_Dia_16
key=  NEW YORK#Jericho Jericho Senior High School#Shah_Dia_16
key=  NEW YORK#Jericho Jericho Senior High School#Shayani_Gabriella_17
key=  NEW YORK#Jericho Jericho Senior High School#Shekar_Shruthi_17
key=  NEW YORK#Jericho Jericho Senior High School#Shekar_Shruthi_17
key=  NEW YORK#Jericho Jericho Senior High School#Subramanian_Madhav_18
key=  NEW YORK#Jericho Jericho Senior High School#Xu_David_17
key=  NEW YORK#Jericho Jericho Senior High School#Xu_David_17
key=  NEW YORK#Jericho Jericho Senior High School#Zhang_Jiaqi_18
key=  NEW YORK#Kings Park Kings Park High School#Cai_Merrick_17
key=  NEW YORK#Kings Park Kings Park High School#Cai_Merrick_17
key=  NEW YORK#Levittown Island Trees High School#Wendt_David_17
key=  NEW YORK#Lincolndale Somers High School#Joseph_Rachel_18
key=  NEW YORK#Lincolndale Somers High School#Joseph_Rachel_18
key=  NEW YORK#Lynbrook Lynbrook High School#Condoleo_Juliana_17
key=  NEW YORK#Lynbrook Lynbrook High School#Condoleo_Juliana_17
key=  NEW YORK#Lynbrook Lynbrook High School#Hausknecht_Kaylie_17
key=  NEW YORK#Lynbrook Lynbrook High School#Hausknecht_Kaylie_17
key=  NEW YORK#Manhasset Manhasset High School#Lee_Richard_17
key=  NEW YORK#Manhasset Manhasset High School#Lee_Richard_17
key=  NEW YORK#Manhasset Manhasset High School#Tak_Kendrick_18
key=  NEW YORK#Manhasset Manhasset High School#Tak_Kendrick_18
key=  NEW YORK#Manhasset Manhasset High School#Tak_Kendrick_18
key=  NEW YORK#New Hyde Park Herricks High School#Maheshwari_Eish_16
key=  NEW YORK#New Hyde Park Herricks High School#Maheshwari_Eish_16
key=  NEW YORK#New York Columbia Grammar & Preparatory School#Yuan_Bi Tian_17
key=  NEW YORK#Stuyvesant High School#Cai_Fiona_17
key=  NEW YORK#Stuyvesant High School#Cai_Fiona_17
key=  NEW YORK#Stuyvesant High School#Eckert_Lucien_18
key=  NEW YORK#Stuyvesant High School#Eckert_Lucien_18
key=  NEW YORK#Stuyvesant High School#McGillis_Clare_17
key=  NEW YORK#Northport Northport High School#Sierra_Katie_17
key=  NEW YORK#Old Westbury The Wheatley School#Shukla_Manan_18
key=  NEW YORK#Old Westbury The Wheatley School#Zhu_Brandon_17
key=  NEW YORK#Ossining Ossining High School#Montgomery_Emma_18
key=  NEW YORK#Ossining Ossining High School#Sukumar_John_17
key=  NEW YORK#Ossining Ossining High School#Sukumar_John_17
key=  NEW YORK#Ossining Ossining High School#Ocheltree_Elliot_17
key=  NEW YORK#Ossining Ossining High School#Ocheltree_Elliot_17
key=  NEW YORK#Pawling Trinity-Pawling School#Wang_Ziqing_18
key=  NEW YORK#Pawling Trinity-Pawling School#Wang_Ziqing_18
key=  NEW YORK#Pawling Trinity-Pawling School#Wang_Ziqing_18
key=  NEW YORK#Pelham Pelham Memorial High School#Wong_Caitlin_17
key=  NEW YORK#Plainview Plainview-Old Bethpage John F. Kennedy High School#Philip_Stefan_17
key=  NEW YORK#Plainview Plainview-Old Bethpage John F. Kennedy High School#Philip_Stefan_17
key=  NEW YORK#Port Washington Paul D. Schreiber High School#Bercow_Jolie_18
key=  NEW YORK#Port Washington Paul D. Schreiber High School#Bercow_Jolie_18
key=  NEW YORK#Port Washington Paul D. Schreiber High School#Levin_Emma_18
key=  NEW YORK#Port Washington Paul D. Schreiber High School#Taylor_Leah_17
key=  NEW YORK#Putnam Valley Putnam Valley High School#Rippon_Dora_17
key=  NEW YORK#Putnam Valley Putnam Valley High School#Rippon_Dora_17
key=  NEW YORK#Rochester Brighton High School#Raynor_Maia_17
key=  NEW YORK#Roslyn Heights Roslyn High School#Ke_Adrian_17
key=  NEW YORK#Roslyn Heights Roslyn High School#Ke_Adrian_17
key=  NEW YORK#Roslyn Heights Roslyn High School#Lee_Brandon_18
key=  NEW YORK#Roslyn Heights Roslyn High School#Lee_Brandon_18
key=  NEW YORK#Can You be Just a Little Bit of a Cheater : Perceptions of Academic Dishonesty#Rust_Lindsey_18
key=  NEW YORK#Can You be Just a Little Bit of a Cheater : Perceptions of Academic Dishonesty#Rust_Lindsey_18
key=  NEW YORK#Can You be Just a Little Bit of a Cheater : Perceptions of Academic Dishonesty#Schiavo_Justin_18
key=  NEW YORK#Saint James Smithtown High School East#D’Amore_Anthony_17
key=  NEW YORK#Scarsdale Edgemont High School#Jang_Angie_18
key=  NEW YORK#Shrub Oak Lakeland Senior High School#Ramaswamy_Jothi_17
key=  NEW YORK#Shrub Oak Lakeland Senior High School#Ramaswamy_Jothi_17
key=  NEW YORK#Smithtown Smithtown High School West#Rodriguez_Alexander_17
key=  NEW YORK#Smithtown Smithtown High School West#Rodriguez_Alexander_17
key=  NEW YORK#Syosset Syosset High School#Lam_Thomas_17
key=  NEW YORK#Syosset Syosset High School#Lee_Serena_17
key=  NEW YORK#Syosset Syosset High School#Pugach_Spencer_18
key=  NEW YORK#Syosset Syosset High School#Pugach_Spencer_18
key=  NEW YORK#Syosset Syosset High School#Wang_Michael_17
key=  NEW YORK#Syosset Syosset High School#Wang_Michael_17
key=  NEW YORK#Upper Nyack Nyack High School#Jiao_Lucy_18
key=  NEW YORK#Webster Webster Schroeder High School#Sharma_Anirudh_17
key=  NEW YORK#Webster Webster Schroeder High School#Sharma_Anirudh_17
key=  NEW YORK#Yorktown Heights Yorktown High School#Satpute_Sayli_17
key=  NEW YORK#Yorktown Heights Yorktown High School#Shah_Shrila_17
key=  NEW YORK#Yorktown Heights Yorktown High School#Shah_Shrila_17
key=  NEW YORK#Yorktown Heights Yorktown High School#Yang_Diane_18
key=  NORTH CAROLINA#Durham North Carolina School of Science and Mathematics#Gong_Albert_18
key=  NORTH CAROLINA#Durham North Carolina School of Science and Mathematics#Gong_Albert_18
key=  NORTH CAROLINA#Durham North Carolina School of Science and Mathematics#Gupta_Abhijit_18
key=  NORTH CAROLINA#Durham North Carolina School of Science and Mathematics#Jain_Navami_18
key=  NORTH CAROLINA#Durham North Carolina School of Science and Mathematics#Jain_Navami_18
key=  NORTH CAROLINA#Durham North Carolina School of Science and Mathematics#Patil_Aarushi_17
key=  NORTH CAROLINA#Durham North Carolina School of Science and Mathematics#Venkatakrishnan_Aarushi_18
key=  NORTH CAROLINA#Durham North Carolina School of Science and Mathematics#Venkatakrishnan_Aarushi_18
key=  NORTH CAROLINA#Durham North Carolina School of Science and Mathematics#Wu_Megan_18
key=  NORTH CAROLINA#Durham North Carolina School of Science and Mathematics#Wu_Megan_18
key=  OHIO#Beachwood Beachwood High School#Shen_Jing-Jing_17
key=  OHIO#Beachwood Beachwood High School#Shen_Jing-Jing_17
key=  OHIO#Gates Mills Hawken School#Hamilton_Claudia_17
key=  OHIO#Shaker Heights Hathaway Brown School#Cywinska_Greta_18
key=  OHIO#Toledo Maumee Valley Country Day School#Jayatissa_Nipun_17
key=  OHIO#Toledo Maumee Valley Country Day School#Jayatissa_Nipun_17
key=  OKLAHOMA#Oklahoma City Oklahoma School of Science & Mathematics#Wang_William_17
key=  OKLAHOMA#Oklahoma City Oklahoma School of Science & Mathematics#Wang_William_17
key=  OKLAHOMA#Tulsa Cascia Hall Preparatory School#Milford_Braden_17
key=  OKLAHOMA#Tulsa Cascia Hall Preparatory School#Milford_Braden_17
key=  OKLAHOMA#Tulsa Cascia Hall Preparatory School#Milford_Braden_17
key=  OKLAHOMA#Tulsa Cascia Hall Preparatory School#Milford_Braden_17
key=  OREGON#Portland Oregon Episcopal School#Gupta_Aneesh_17
key=  OREGON#Portland Oregon Episcopal School#Gupta_Aneesh_17
key=  OREGON#Sunset High School#Jin_Kevin_17
key=  OREGON#Westview High School#Li_Lauren_18
key=  OREGON#Salem South Salem Senior High School#Joshi_Megha_17
key=  OREGON#Salem South Salem Senior High School#Joshi_Megha_17
key=  OREGON#West Linn West Linn High School#Yu_Jessica_17
key=  PENNSYLVANIA#Allison Park Hampton High School#Kamel_Kerollos_18
key=  PENNSYLVANIA#Allison Park Hampton High School#Kamel_Kerollos_18
key=  PENNSYLVANIA#Glen Mills Garnet Valley High School#Mamidala_Sai_17
key=  PENNSYLVANIA#Glen Mills Garnet Valley High School#Mamidala_Sai_17
key=  PENNSYLVANIA#Rosemont Harriton High School#Weissman_Samuel_17
key=  PENNSYLVANIA#Rosemont Harriton High School#Weissman_Samuel_17
key=  PENNSYLVANIA#Rosemont Harriton High School#Weissman_Samuel_17
key=  PENNSYLVANIA#West Doylestown Central Bucks High School#Anderson_Walker_18
key=  PENNSYLVANIA#West Doylestown Central Bucks High School#Anderson_Walker_18
key=  PENNSYLVANIA#West Doylestown Central Bucks High School#Anderson_Walker_18
key=  PENNSYLVANIA#West Doylestown Central Bucks High School#Anderson_Walker_18
key=  SOUTH CAROLINA#Spring Valley High School#Trifonova_Kristina_17
key=  SOUTH CAROLINA#Spring Valley High School#Trifonova_Kristina_17
key=  TENNESSEE#Brentwood Ravenwood High School#Liu_Gabrielle_17
key=  TENNESSEE#Brentwood Ravenwood High School#Liu_Gabrielle_17
key=  TENNESSEE#Nashville Hume Fogg Academic High School#Halbert_Ella_18
key=  TENNESSEE#Nashville Hume Fogg Academic High School#Halbert_Ella_18
key=  TENNESSEE#Martin Luther King Jr. Magnet High School#An_Julia_17
key=  TENNESSEE#Martin Luther King Jr. Magnet High School#An_Julia_17
key=  TENNESSEE#Martin Luther King Jr. Magnet High School#An_Julia_17
key=  TENNESSEE#Martin Luther King Jr. Magnet High School#Lee_Samuel_18
key=  TENNESSEE#Martin Luther King Jr. Magnet High School#Lee_Samuel_18
key=  TEXAS#Austin Liberal Arts and Science Academy#Chieng_Sarah_17
key=  TEXAS#Coppell Coppell Senior High School#Liang_Stephen_17
key=  TEXAS#Denton Texas Academy of Mathematics and Science#Patel_Mira_17
key=  TEXAS#Denton Texas Academy of Mathematics and Science#Patnaik_Ritik_17
key=  TEXAS#Denton Texas Academy of Mathematics and Science#Patnaik_Ritik_17
key=  TEXAS#Denton Texas Academy of Mathematics and Science#Shridharan_Rishi_18
key=  TEXAS#Grand Prairie Peninsula Academy#Wilhoit_Kayla_18
key=  TEXAS#Grand Prairie Peninsula Academy#Wilhoit_Kayla_18
key=  TEXAS#Lubbock Lubbock High School#Zhang_Phyllis_18
key=  TEXAS#Plano Plano West Senior High School#Huang_Vincent_18
key=  TEXAS#Plano Plano West Senior High School#Jha_Harshika_17
key=  TEXAS#Plano Plano West Senior High School#Jha_Harshika_17
key=  TEXAS#Plano Plano West Senior High School#Jha_Harshika_17
key=  TEXAS#Plano Plano West Senior High School#Suri_Paritosh_18
key=  TEXAS#Plano Plano West Senior High School#Suri_Paritosh_18
key=  TEXAS#Plano Plano West Senior High School#Zhang_Eric_17
key=  TEXAS#The Woodlands The Woodlands College Park High School#Dasari_Shobha_18
key=  UTAH#Midvale Hillcrest High School#Cheng_Alexander_18
key=  UTAH#Midvale Hillcrest High School#Cheng_Alexander_18
key=  VIRGINIA#Alexandria T. C. Williams High School#Humphrey_Ana_18
key=  VIRGINIA#Alexandria T. C. Williams High School#Humphrey_Ana_18
key=  VIRGINIA#Alexandria T. C. Williams High School#Naughton-Rockwell_Tessa_18
key=  VIRGINIA#Alexandria T. C. Williams High School#Naughton-Rockwell_Tessa_18
key=  VIRGINIA#Thomas Jefferson High School for Science and Technology#Allamsetty_Abhishek_18
key=  VIRGINIA#Thomas Jefferson High School for Science and Technology#Ardeishar_Adam_17
key=  VIRGINIA#Thomas Jefferson High School for Science and Technology#Naidich_Rachel_18
key=  VIRGINIA#Thomas Jefferson High School for Science and Technology#Naidich_Rachel_18
key=  VIRGINIA#Thomas Jefferson High School for Science and Technology#Qi_Grace_17
key=  VIRGINIA#Thomas Jefferson High School for Science and Technology#Wu_Lauryn_18
key=  VIRGINIA#Thomas Jefferson High School for Science and Technology#Wu_Lauryn_18
key=  VIRGINIA#Thomas Jefferson High School for Science and Technology#Wu_Wenbo_17
key=  VIRGINIA#Thomas Jefferson High School for Science and Technology#Wu_Wenbo_17
key=  VIRGINIA#Charlottesville Albemarle High School#Mandal_Mriganka_17
key=  VIRGINIA#McLean Langley High School#Chen_Alex_17
key=  VIRGINIA#Potomac School#Beaumont_Carolyn_17
key=  VIRGINIA#Potomac School#Beaumont_Carolyn_17
key=  VIRGINIA#Potomac School#Beaumont_Carolyn_17
key=  VIRGINIA#Vienna Oakton High School#Qu_Carolyn_17
key=  VIRGINIA#Vienna Oakton High School#Qu_Carolyn_17
key=  WASHINGTON#Bellevue Interlake High School#Saxena_Eshika_17
key=  WASHINGTON#Bellevue Interlake High School#Saxena_Eshika_17
key=  WEST VIRGINIA#Charleston George Washington High School#Morris_Rachel_18
key=  WISCONSIN#Milwaukee University School of Milwaukee#Karan_Aayush_17
key=  CANADA#Lethbridge Alberta Catholic Central High School#Schultz_Marin_18
key=  CHINA#Hefei Anhui Hefei No. 1 High School#Bi_Dasheng_16

In [14]:
#print(mapSchool)
#print(mapStudent)
#print(mapProject)

In [15]:
# write out parsed records into csv
fo6 = open("STS-books-20190109.csv", "w")
fo6.write("State, School, LastName, FirstName, Age, ProjectTitle\n")
for k,v in mapProject.items():
    project_title = " ".join(v).replace(",", " ")
    state, school, student = k.split("#")
    last, first, age = student.split("_")
    fo6.write("%s, %s, %s, %s, %s, %s\n" % (state, school, last, first, age, project_title))
fo6.close()

In [ ]: