Answered: get_total_cases() takes the a 2D-list…

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

Question

(PYTHON)

a) get_total_cases() takes the a 2D-list (similar to database) and an integer x from this set {0, 1, 2} as input parameters. Here, 0 represents Case_Reported_Date, 1 represents Age_Group and 2 represents Client_Gender (these are the fields on the header row, the
integer value represents the index of each of these fields on that row). This function computes the total number of reported cases for each instance of x in the text file, and it stores this information in a dictionary in this form {an_instance_of_x : total_case}. Finally, it returns the dictionary and the total number of all reported cases saved in this dictionary.
(Suppose we want to know the total number of cases reported on each date, so use x = 0.)
>>> result, total_cases = get_total_cases(database, 0)
>>> display_dict(result)
2021-05-19: 8
2021-05-20: 2
2021-05-21: 1
2021-05-22: 1
>>> print(total_cases)

Case Repo Age_Group Client_Gen Reporting Reporting Reporting Reporting Reporting Reporting
#####HA# 40s
MALE
2241 Kingston Fr Kingston K7M 1V5 www.kflap
44.2
MALE
2265 Region of VWaterloo N2J 4V3
43.5
FEMALE
2244 Middlesex-London
www.healt
4913 Southwest St. Thomas N5P 1G9 www.swpu
N6A 5L7
43
MALE
42.8
FEMALE
2251 Ottawa Pul Ottawa
K2G 6J8
www.ottav
www.healt
45.3
FEMALE
2244 Middlesex-London
N6A 5L7
43
GENDER DI
3895 Toronto Pu Toronto
M5B 1W2 www.toror
43.7
MALE
2237 Hamilton P Hamilton L8P 4S6
2268 Windsor-EsWindsor
www.hami
43.3
MALE
N9A 4J8
2270 York RegioiNewmarke L3Y 6Z1
www.wech
42.3
MALE
44
www.york,
2253 Peel Public Mississaug: L5W 1N4 www.peelr
FEMALE
43.6
UNSPECIFIE
3895 Toronto Pu Toronto
M5B 1W2 www.toror
43.7

Expert Solution

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