Part B - reading CSV filesYou will need a Python repl to solve part B.Define a Python function named cheapest_rent_per_state that has one parameter. The parameter is a string representing the name of a CSV file. The CSV file will be portion of a dataset published by the USgovernment showing the median (middle) rent in every county in the US. Each row in the CSV file has the same formatArea Name, Efficiency, 1-Bedroom, 2-Bedroom, 3-Bedroom, 4-Bedroom, State CodeThe data in the Area Name and State Code columns are text. The data in all of the other columns are decimal numbers.Your function will need to use the accumulator pattern to return a dictionary. The keys of that dictionary will be the state codes read in from the file (state codes are at index 6). For each key in the dictionary, it'svalue should be the smallest median rent for an efficiency in that state (median rents for an efficiency are at index 1).Important Hints:* You will really, really want to use the built-in csv library because it makes processing a CSV file much easier and Area Name values may include commas.* You should get the value the accumulator associates with a key, since the state code may be new. A good default value would be 1000000 since that will always be greater than an area's median rent for anefficiency.)Sample test cases:cheapest_rent_per_state("empty.csv") would evaluate to { } (finds bug if accumulator variable not initialized correctly)cheapest_rent_per_state("simple.csv") would evaluate to { 'CA' : 2103.0, 'NY' : 1665.0} (finds bug if accumulator variable not updated correctly)

the python program is an given below :

Define a Python function named cheapest_rent_per_state that has one parameter. The parameter is a string representing the name of a CSV file. The CSV file will be portion of a dataset published by the US overnment showing the median (middle) rent in every county in the US. Each row in the CSV file has the same format Area Name, Efficiency, 1-Bedroom, 2-Bedroom, 3-Bedroom, 4-Bedroom, State Code he data in the Area Name and State Code columns are text. The data in all of the other columns are decimal numbers. our function will need to use the accumulator pattern to return a dictionary. The keys of that dictionary will be the state codes read in from the file (state codes are at index 6). For each key in the dictionary, it's alue should be the smallest median rent for an efficiency in that state (median rents for an efficiency are at index 1). mportant Hints: You will really, really want to use the built-in csv library because it makes processing a CSy file much easier and Area Name values may include commas.

Define a Python function named cheapest_rent_per_state that has one parameter. The parameter is a string representing the name of a CSV file. The CSV file will be portion of a dataset published by the US overnment showing the median (middle) rent in every county in the US. Each row in the CSV file has the same format Area Name, Efficiency, 1-Bedroom, 2-Bedroom, 3-Bedroom, 4-Bedroom, State Code he data in the Area Name and State Code columns are text. The data in all of the other columns are decimal numbers. our function will need to use the accumulator pattern to return a dictionary. The keys of that dictionary will be the state codes read in from the file (state codes are at index 6). For each key in the dictionary, it's alue should be the smallest median rent for an efficiency in that state (median rents for an efficiency are at index 1). mportant Hints: You will really, really want to use the built-in csv library because it makes processing a CSy file much easier and Area Name values may include commas.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

If a struct is declared in a .h file, the struct will need to be declared in the .cpp file as well, even if the .h file is #included in the .cpp file. Group of answer choices True False =================== Given the struct below, what is the correct method of accessing the data for the member variable age? struct Human{ string name; int age; }; Human human; Group of answer choices Human.age Human(age) Human[2] human.age human(age) human[2] ================= Consider the following code: struct MyStruct { int x; } void update(MyStruct test) { test.x=10; } MyStruct m1={15}; update(m1); cout<<m1.x<<endl; Group of answer choices 10 15 Compilation Error: Cannot initialize a structure that way Compilation Error: Structure must be passed by reference
I am looking to write two python programs for golf data. The Westminster Amateur Golf Club has a tournament every weekend. The club president has askedyou to design and write two programs. The first program will read each player's name and golf score as keyboard input, and then save(append) these records in a file named golf.dat (Each record will have a field for the player'sname and a field for the player's score, separated by commas). The second program will read the records from the golf.dat file and displays them. n addition, italso displays the name of the player with the best (lowest) score. The output should look like this: Program 1Enter a player's name: Larry FineEnter the player's score: 20Do you want to enter another record?Enter y for yes or anything else for no: y Enter a player's name: Moe HowardEnter the player's score: 21Do you want to enter another record?Enter y for yes or anything else for no: y Enter a player's name: Curly HowardEnter the player's score: 22Do you…
Write a function named city_pop that takes a string then a list as parameters where the string represents the name of a CSV file containing city data in the format "CountryCode,CityName,Region,Population,Latitude,Longitude". The second parameter is a list with a length of 3. . The entries represent the CountryCode, CityName, and Regionof the city whose population we are interested in (in that order).Return the population of the city provided in the second argument.Because city names are not unique, you must check that the country, name, AND region are a match adding the population to your accumulator.PYTHON
Computer Science csv file "/dsa/data/all_datasets/texas.csv" Task 6: Write a function "county_locator" that allows a user to enter in a name of a spatial data frame and a county name and have a map generated that shows the location of that county with respect to other counties (by using different colors and/or symbols). Hint: function(); $county ==; plot(); add=TRUE.
DescriptionWrite a program to compute average grades for a course. The course records are in a single file and are organized according to the following format: each line contains a student's first name, then one space, then the student's last name, then one space, then some number of quiz scores that, if they exist, are separated by one space. Each student will have zero to ten scores, and each score is an integer not greater than 100. Your program will read data from this file and write its output to a second file. The date in the output file will be nearly the same as the data in the input file except that you will print the names as last-name, first-name; each quiz score, and there will be one additional number at the end of each line:the average of the student's ten quiz scores.Both files are parameters. You can access the name of the input file with argv[1]. and the name of the output file with argv[2].The output file must be formatted as described below: 1. First and last names…
Which of these attacks is a form of Wi-Fi DoS attack? a. Rogue DHCP server b. FTP bounce c. Deauthentication attack d. Amplified DRDoS attack
CODE SHOULD BE PYTHON:
A bucket list is a collection of goals, dreams, and aspirations that you would like to accomplish within your lifetime. The purpose of this assignment is to develop a program that allows the user to manage their personal bucket list and save it to an XML file bucketlist.xml. For full credit, run the program and create a file with at least three entry elements. Submit a document containing a copy of the source file, a screenshot of the program in action, and the contents of the XML file. File Structure Below is the basic structure (i.e. schema) for the XML file. You may add additional elements. <bucketList> <entry> <rank></rank> <description></description> <status></status> </entry> </bucketList> Note: Before running the program, manually create an XML input file with at least one entry element that contains values in each child element. GUI Requirements At a minimum, your GUI must meet the below requirements. No minimize…
Javascript Create a function named "getUser". This function needs to accept a "userID" parameter. Use Fetch with Async/Await to request the data for the requested user. The function should return JSON data.
This part of the quiz will contain 4 parts. A function called grade, a function called pgrade, a prototype file called grade.h and a main function. In this part you will create the main function which will do the following: main This main function will use the functions grade and pgrade to produce the grades for the following students and display the appropriate grade with the appropriate message. The semester grade will be based on the fact that the quiz average is 25% of the grade, the final is 20% of the grade, assignments is 20% of the grade and programs are 35% of the grade. The student grades are as follows: Student Name Assignments Programs Quiz Ave Final Tom 63 Francis Maria Jan 75 90 95 85 sample of output Harry Grade B Good 85 75 95 90 93 92 71 69 87 91 73 A
Write a function named csv_to_kvs that takes a string as a parameter representing the name of a CSV file with 4 columns in the format "<string>,<float>,<float>,<float>" and returns a new dictionary mapping strings to decimal numbers. The returned dictionary will have a key-value pair for each row in the file. The key for each pair is the data in the initial column of the CSV file and values are the data from the column at index 2. (in python )
python please! the first answer i received didn't check out. it is graded by a computer on autolab. im so confused