(d) create_area_dict(list2D) that takes a 2D-list containing the database as input andcreates a dictionary called area_dict (you may rename it), where keys are the identitynumber of a CMA (ID) and values are the name of the CMA (Area). This function mustreturn the dictionary. See sample output below.area_dict = create_area_dict(database)display_dict(area_dict)31 - Cityview - Crestview - Meadowlands903 - Billings Bridge - Alta Vista908 - Byward Market912Carson GroveCarson Meadows923Glebe - Dows Lake940Overbrook - McArthur942 - Portobello South949 - Sandy Hill957 - West Centertown(e) create_crime_dict(filename) that takes the filename of a csv file as input andreturns a dictionary called crime_dict (you may rename it). This function reads theheader of the csv file and stores data in crime_dict such that keys are the indices of acrime type on the header row, and values are the corresponding crime types (names arecase sensitive). You can assume that indices start from zero (0) on the header row. Thefunction must return this dictionary. See sample output below.crime_dict = create_area_dict(filename)display_dict(crime_dict)3 - Arson4 - Break and Enter5 - Fraud6 -Mischief7 - Possession / Trafficking Stolen Goods8 - Theft - Motor Vehicle9 - Theft $5000 and UnderTheft Over $500010 -

def create_area_dict(database): d={} for i in range(len(database)): key=database[i][0]…

(d) create_area_dict(list2D) that takes a 2D-list containing the database as input and creates a dictionary called area_dict (you may rename it), where keys are the identity number of a CMA (ID) and values are the name of the CMA (Area). This function must return the dictionary. See sample output below. area_dict = create_area_dict(database) display_dict(area_dict) 31 - Cityview - Crestview - Meadowlands 903 - Billings Bridge - Alta Vista 908 - Byward Market 912 Carson Grove - Carson Meadows 923 - Glebe - Dows Lake 940 - Overbrook - McArthur 942 949 Portobello South Sandy Hill West Centertown 957

(d) create_area_dict(list2D) that takes a 2D-list containing the database as input and creates a dictionary called area_dict (you may rename it), where keys are the identity number of a CMA (ID) and values are the name of the CMA (Area). This function must return the dictionary. See sample output below. area_dict = create_area_dict(database) display_dict(area_dict) 31 - Cityview - Crestview - Meadowlands 903 - Billings Bridge - Alta Vista 908 - Byward Market 912 Carson Grove - Carson Meadows 923 - Glebe - Dows Lake 940 - Overbrook - McArthur 942 949 Portobello South Sandy Hill West Centertown 957

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: numList: head: tail: data: 73 next: data: 37 next: data: 85 next: null After ListPrepend(numList,…

A: The ListPrepend operation is typically used to add a new node at the beginning of a linked list.…

Q: Function in python thst inverts the key and value in a dictionary If dictionary encounters more…

Q: Assume a dictionary with some values: students = { 'CCU101': ['Anna', 88.5, 98.5, 78, 85, 92.5],…

A: def display_average(students): print(students) for studentId in students.keys():…

Q: def level_up(leveling_factor, *args, **kwargs): """ Returns a dictionary with number of levels…

A: Let's break down the changes made to the original code: Variable Renaming:The original code had a…

Q: get_movie_dict() takes a 2-D list similar to movie_db and a dictionary similar to ratings as the…

A: Define get_movie_dict() function to return the dictionary containing name, year and ratings of the…

Q: You are hired to create a simple Dictionary application. Your dictionary is capable of taking a…

A: DATA STRUCTURE using a data structure called hash tables. Because doing this work specifically will…

Q: Which of the following data structures store values in contiguous memory? Check all that apply .…

A: Contiguous memory refers to a block of consecutive addresses in a computer's memory space that are…

Q: To show a single row function in a database, we used the function named "single row". Scalar…

A: The difference between a scalar and a vector is as follows: Scalar quantities differ from vector…

Q: Spot and fix two errors in the following code: import pandas_datareader as pd…

A: The given code is - import pandas_datareader as pd MoetChandonSharePrice=pd.data.DataReader('MC.PA',…

Q: Write a function called make_dict(n), where n is an integer parameter. With a given number n, make a…

A: Solution :

Q: Question 3 1. Create a dictionary. a) Implement a dictionary car with the keys brand, model, and…

A: According to the information given:- We Have to follow the instruction in order to get desired…

Q: Define a function called create_pattern_dictionary (colours_list) which takes a list of colour names…

A: Since no programming language is mentioned, I am using python. Code: import numpy as npdef…

Q: python question Define a function named filter_list with three parameters: the 1st parameter,…

A: PROGRAM EXPLANATION Define a function filter list as given in the question. This function will…

Q: Define a function named print_details() which takes a dictionary library as a parameter. The key of…

A: Python programming allows to create a dictionary that contains the (key, value) pair values. The…

Q: As a software engineer, you are hired to arrange cricket players based on their country and type.…

A: solution: # Note ************** I have given an answer as asked in the question *************#…

Q: To create a JSON for Population census with objects and arrays Scenario: ABC Census Company is…

A: sample.json { "Country":"India", "State":"Uttar Pradesh", "YearOfSurvey":2015,…

Q: You are now working for Prof. Midas on a research project. You are given this piece of code to…

A: The built in lookUp function in python dictionary has complexity of O(1). The given user define…

Q: The function below, get_value_if_key, takes two arguments: the dictionary data_dict and a key of any…

A: In Python, to access all the available keys in the dictionary, keys() method is used. It returns a…

Concept explainers

Types of Linked List

A sequence of data elements connected through links is called a linked list (LL). The elements of a linked list are nodes containing data and a reference to the next node in the list. In a linked list, the elements are stored in a non-contiguous manner and the linear order in maintained by means of a pointer associated with each node in the list which is used to point to the subsequent node in the list.

Linked List

When a set of items is organized sequentially, it is termed as list. Linked list is a list whose order is given by links from one item to the next. It contains a link to the structure containing the next item so we can say that it is a completely different way to represent a list. In linked list, each structure of the list is known as node and it consists of two fields (one for containing the item and other one is for containing the next item address).

Question

(d) create_area_dict(list2D) that takes a 2D-list containing the database as input and
creates a dictionary called area_dict (you may rename it), where keys are the identity
number of a CMA (ID) and values are the name of the CMA (Area). This function must
return the dictionary. See sample output below.
area_dict = create_area_dict(database)
display_dict(area_dict)
31 - Cityview - Crestview - Meadowlands
903 - Billings Bridge - Alta Vista
908 - Byward Market
912
Carson Grove
Carson Meadows
923
Glebe - Dows Lake
940
Overbrook - McArthur
942 - Portobello South
949 - Sandy Hill
957 - West Centertown
(e) create_crime_dict(filename) that takes the filename of a csv file as input and
returns a dictionary called crime_dict (you may rename it). This function reads the
header of the csv file and stores data in crime_dict such that keys are the indices of a
crime type on the header row, and values are the corresponding crime types (names are
case sensitive). You can assume that indices start from zero (0) on the header row. The
function must return this dictionary. See sample output below.
crime_dict = create_area_dict(filename)
display_dict(crime_dict)
3 - Arson
4 - Break and Enter
5 - Fraud
6 -
Mischief
7 - Possession / Trafficking Stolen Goods
8 - Theft - Motor Vehicle
9 - Theft $5000 and Under
Theft Over $5000
10 -

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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

Overview This program will welcome a user to the trivia builder 3000, then prompt the user to add questions to the trivia bank. After the user indicates they are done it will print out the contents of the trivia bank. Expected Output Example 1 Welcome to the trivia builder 3000 Enter the next question: Who was the fifth Beatle? Enter the correct answer for that question: Pete Best Enter the next question: You did not enter a question, let's try again. Enter the next question: How many dimples does a golf ball have Enter the correct answer for that question: 336 Enter the next question: Done We will stop entering questions now Here is the final trivia dictionary: The question is: Who was the fifth Beatle? And the answer is: Pete Best The question is: How many dimples does a golf ball have? And the answer is: 336 Example 2 Welcome to the trivia builder 3000 Enter the next question: What was the first name for the Beatles? Enter the correct answer for that question: The Quarymen Enter the…
Define the function print_trophic_class_summary(tli3_values) that accepts a list of trophic level index values and prints a summary outlining the number of lakes in each trophic classification, in order from highest trophic classification to lowest. See the examples for the required format. Notes: Your function must print the summary, not return it. In each state line, the initial number should be formatted with width 3. (Hint: :3 will be helpful) All possible states must be included in the output, even states with zero lakes. The following list will be helpful: ['Hypertrophic', 'Supertrophic', 'Eutrophic', 'Mesotrophic', 'Oligotrophic', 'Microtrophic', 'Ultra-microtrophic'] You must include and use one of your number_in_trophic_class functions (take your pick!), plus your trophic_class function. Basically, you can start with your answer to Question 5 or 6 and add your print_trophic_class_summary function definition after your previous definitions. For example: Test Result…
get_top_regions() that takes three input parameters; the 2-D list (similar to the database), the dictionary that stores information of all regions, and a non-zero positive integer x. This function returns a new dictionary that contains the information of top-x regions in terms of the total number of hospitalization cases recorded in these regions. That means these top-x regions have the largest numbers of hospitalization cases. Each {key:value} pair in this resulting dictionary stores the name of a top region as the key and the value is the total number of hospitalization cases reported in this region. The result does not need to be sorted, the regions of the resulting dictionary can appear in any order as long as the top-x regions have been identified correctly. If the value of x is less than 1, or more than the total number of unique regions, your function should print a message informing the user and return an empty dictionary. See sample outputs below. >>> topx_regions…
Campground reservations, part 3: Available campsites Excellent job! This next one's a little more challenging. Which campsites are available to reserve? We want to be able to quickly find which campsites are available. Can you help us? Given a campgrounds array, return an array with the campsite numbers of all currently unreserved (isReserved === false) campsites. Call the function availableCampsites. Dataset As a reminder, our data looks like this. It's an array with a bunch of campsite objects in it. Here is a small subset of the data to give you an idea: const campgrounds = [ { number: 1, view: "ocean", partySize: 8, isReserved: false }, { number: 5, view: "ocean", partySize: 4, isReserved: false }, { number: 12, view: "ocean", partySize: 4, isReserved: true }, { number: 18, view: "forest", partySize: 4, isReserved: false }, { number: 23, view: "forest", partySize: 4, isReserved: true }, ];
Integer num_rows is read from input, representing the number of rows of data remaining in the input. Two-dimensional list vals_2d consists of data read from the remaining input. Output each row of numbers in vals_2d on one line, ending each number with a space.
You are writing an application. You need a data structure that will allow you to store a large set of distinctive objects. The common operations performed on the set of objects are: lookup, insert, and delete. No traversal will be performed on the data set. The client wants the program to be as efficient as possible. Which of the following data structures should you use in your design? Question 25 options: hash table linked list heap binary search tree
Python question, need some help
A date-to-event dictionary is a dictionary in which the keys are dates (as strings in the format 'YYYY-MM-DD'), and the values are lists of events that take place on that day. Complete the following function according to its docstring. Your code must not mutate the parameter! def group_by_year (events: Dict[str, List[str]]) -> Dict [str, Dict [str, List[str]]]: """Return a dictionary in which in the keys are the years that appear in the dates in events, and the values are the date-to-event dictionaries for all dates in that year. >>> date_to_event = {'2018-01-17': ['meeting', 'lunch'], '2018-03-15': ['lecture'], '2017-05-04': ['gym', 'dinner']} >>> group_by_year (date_to_event) {'2018': {'2018-01-17': ['meeting', 'lunch'], '2018-03-15': ['lecture']}, '2017': {'2017-05-04': ['gym', 'dinner']} } || || ||
The following lines of code define three dictionaries for a movie database. They indicate the movies' genre, production year, and budget. The movie titles are dictionary keys in each case. Write a program that prompts the user to enter a search criteria including three elements: 1) a genre, 2) a year, 3) a minimum budget (in million dollars), separated by semicolons (;). Then searches the database and returns a list of all movie titles in the requested genre that are produced within or after the entered year and their budget were equal or greater than the entered minimum. If there is no movie matching the entered criteria just tell the user so. Example 1:Enter genre, starting year, and min budget: drama;2000;5We found these matching movies: ['the pianist','the salesman'] Example 2:Enter genre, starting year, and min budget: action;2020;10Sorry! We could not find a match! # Defining dictionaries (do not change this part of code) genres=…
F3 Match std::vector method on left to the respective description on right. emplace pop_back capacity R 4 size data $ F4 Q Search % 5 DII T F5 6 V [Choose] [Choose] Returns the size of the storage space currently allocated for the vector, expressed in terms of elements. Returns the maximum number of elements that the vector can hold. Removes the last element in the vector, effectively reducing the container size by one. The vector is extended by inserting a new element at a given position Returns a direct pointer to the memory array used internally by the vector to store its owned elements. The vector is extended by inserting new elements before the element at the specified position, effectively increasing the container size by the Returns the number of actual objects held in the vector Adds a new element at the end of the vector, after its current last element Inserts a new element at the end of the vector, right after its current last element [Choose] [Choose ] F6 L 10 7 F7 11 > C >…
Python
Define the function number_in_trophic_class(tli3_values, classification) which takes a list of trophic level index values and a trophic classification, returning the number of lakes in that trophic class. For this version of the question you MUST use a list comprehension. You cannot use a for loop or while loop in your answer. Notes: You must include, and use/call your trophic_class function in your submission. Your tropic_class function must work in the same way it did for Question 2. You can assume that classification will always be valid, i.e. it will always be one of the states in the following list: ['Hypertrophic', 'Supertrophic', 'Eutrophic', 'Mesotrophic', 'Oligotrophic', 'Microtrophic', 'Ultra-microtrophic'] There are several ways to proceed, but you will probably find either the len function or the count method of the list class useful in conjunction with your list comprehension. For example: Test Result tli3_list_1 = [4.1061, 2.54561, 4.16276, 2.33801,…