Define a Python function named expensive_counties that has two parameters. The first parameter is a string representing the name of a text file. Each line of this text file will be a state code. The second parameter is a string representing the name of a CSV file. The CSV file will be portion of the US government's dataset documenting median rents in each US county. Each row in the CSV file has the format: Area Name, Efficiency, 1-Bedroom, 2-Bedroom, 3-Bedroom, 4-Bedroom, State Code Your function will need to use the accumulator pattern to return a new list. You will need to add to this list the Area Name from every row that meets 2 criteria: (1) The state code (the column at index 6) was a line in the text file named in the first parameter; AND

C++ Programming: From Problem Analysis to Program Design
8th Edition
ISBN:9781337102087
Author:D. S. Malik
Publisher:D. S. Malik
Chapter9: Records (struct)
Section: Chapter Questions
Problem 16SA
icon
Related questions
Question
Part C - advanced file reading
You will need a Python repl to solve part C.
Define a Python function named expensive_counties that has two parameters. The first parameter is a string representing the name of a text file. Each line of this text file will be a state code. The second
parameter is a string representing the name of a CSV file. The CSV file will be portion of the US government's dataset documenting median rents in each US county. Each row in the CSV file has the format:
Area Name, Efficiency, 1-Bedroom, 2-Bedroom, 3-Bedroom, 4-Bedroom, State Code
Your function will need to use the accumulator pattern to return a new list. You will need to add to this list the Area Name from every row that meets 2 criteria:
(1) The state code (the column at index 6) was a line in the text file named in the first parameter; AND
(2) The median rent on a 1-bedroom apartment (the column at index 2) is over 1000.
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.
* Reusing 1 of your functions part A will be very helpful in solving this problem.
Sample test cases:
expensive_counties ("empty.txt","empty.csv") would evaluate to [] (finds bug if accumulator variable not initialized correctly)
expensive_counties("codes.txt", "simple.csv") would evaluate to ['San Fran', 'Sunnyvale, CA', 'New York City'] (finds bug if accumulator variable not updated correctly)
Transcribed Image Text:Part C - advanced file reading You will need a Python repl to solve part C. Define a Python function named expensive_counties that has two parameters. The first parameter is a string representing the name of a text file. Each line of this text file will be a state code. The second parameter is a string representing the name of a CSV file. The CSV file will be portion of the US government's dataset documenting median rents in each US county. Each row in the CSV file has the format: Area Name, Efficiency, 1-Bedroom, 2-Bedroom, 3-Bedroom, 4-Bedroom, State Code Your function will need to use the accumulator pattern to return a new list. You will need to add to this list the Area Name from every row that meets 2 criteria: (1) The state code (the column at index 6) was a line in the text file named in the first parameter; AND (2) The median rent on a 1-bedroom apartment (the column at index 2) is over 1000. 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. * Reusing 1 of your functions part A will be very helpful in solving this problem. Sample test cases: expensive_counties ("empty.txt","empty.csv") would evaluate to [] (finds bug if accumulator variable not initialized correctly) expensive_counties("codes.txt", "simple.csv") would evaluate to ['San Fran', 'Sunnyvale, CA', 'New York City'] (finds bug if accumulator variable not updated correctly)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Datatypes
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
C++ Programming: From Problem Analysis to Program…
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning