Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Exercise 3.3 (readscores.py). Download the file actsat.txt provided on Canvas. It contains the following columns of Column 1 2-letter state/territory code (includes DC) CSE/IT 107L

image text in transcribed
Exercise 3.3 (readscores.py). Download the file actsat.txt provided on Canvas. It contains the following columns of Column 1 2-letter state/territory code (includes DC) CSE/IT 107L Lab 9 File and Column 2 Column 3 Column 4 Column 5 Column 6 Column 7 You % of graduates in that state taking the ACT Average composite ACT score % of graduates in that state taking the SAT Average SAT Math score Average SAT Reading score Average SAT Writing score must open this file and te a list of dictionaries containing each row of data. Please use these keys for the dictionaries: "state" "act percent.taking sat average.math For example, your code should process this two line file to form the following list of dictionaries. 27 21.2 48 81 519 563 517 491 2 AL 20.3 9 556 554 [{"state": "Al". actpercent.taking": 27 "act average score*: 21.2 4"sat.percent.taking": 48 "sat average math": 517 6"sat average reading: 519 "sat average vriting:491 {"state" , "AK", 10"act.percent taking:81 11"act average acore": 20.3 12 "sat percent taking":9 3"sat average math" 556 "sat average reading 563 "sat-average-writing": 584 151

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions