Question

Write a function crimes_by_code(code,dict) that takes an integer value code and a dictionary dict containing the statistics in the crime codes as arguments. This function returns a list of all the crimes with the given code that have occurred in the database. See the sample output for an example.

Sample run:
crimes_by_code(110, dict) returns

[['Theft of Vehicle', '2005', '2', '12', '22', '30', '', 'Victoria-Fraserview', '495178', '5452000'], ['Theft of Vehicle', '2003', '6', '5', '17', '0', '10XX ALBERNI ST', 'West End', '491059.4824', '5459122.418'], ['Theft of Vehicle', '2003', '9', '26', '8', '30', '10XX ALBERNI ST', 'West End', '491059.4824', '5459122.418'], ['Theft of Vehicle', '2004', '7', '24', '11', '15', '10XX ALBERNI ST', 'West End', '491059.4824', '5459122.418'], ['Theft of Vehicle', '2004', '8', '24', '21', '0', '10XX ALBERNI ST', 'West End', '491059.4824', '5459122.418'],...]

So for this question the "code" which in the example is 110 comes from a json file that in the previous question was sorted into a dictionary that looks like this:

{'101': 'Break and Enter Commercial', '102': 'Break and Enter Residential/Other', '103': 'Vehicle Collision or Pedestrian Struck (with Fatality)', '104': 'Vehicle Collision or Pedestrian Struck (with Injury)', '105': 'Homicide', '106': 'Mischief', '107': 'Offence Against a Person', '108': 'Other Theft', '109': 'Theft from Vehicle', '110': 'Theft of Vehicle', '111': 'Theft of Bicycle'}

And "dict" are the types of the corresponding crime code. The rest of the information (ie. '2005', '2', '12', '22', '30', '', 'Victoria-Fraserview', '495178', '5452000) will come from a previous function with output in the format of a 2D list:

[['Break and Enter Commercial', '2012', '12', '14', '8', '52', '', 'Oakridge', '491285', '5453433'], ['Break and Enter Commercial', '2019', '3', '7', '2', '6', '10XX SITKA SQ', 'Fairview', '490612.9648', '5457109.822'], ....] (This is only a part of it, it's really long)

So all in all the function should take the code and dict value from a previous function which saved the values to a dictionary and use it to get the rest of the information from another previous function which saved the information to a 2D list.

Thanks

Answer 1

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<python code>>>>>>>>>>>>>>>>>>>>>>>>

crime_code={'101': 'Break and Enter Commercial', '102': 'Break and Enter Residential/Other', '103': 'Vehicle Collision or Pedestrian Struck (with Fatality)', '104': 'Vehicle Collision or Pedestrian Struck (with Injury)', '105': 'Homicide', '106': 'Mischief', '107': 'Offence Against a Person', '108': 'Other Theft', '109': 'Theft from Vehicle', '110': 'Theft of Vehicle', '111': 'Theft of Bicycle'}

prev_output=[['Break and Enter Commercial', '2012', '12', '14', '8', '52', '', 'Oakridge', '491285', '5453433'], ['Break and Enter Commercial', '2019', '3', '7', '2', '6', '10XX SITKA SQ', 'Fairview', '490612.9648', '5457109.822'],]

def crimes_by_code(num, crime_code):
#creating a empty list to record crimes by code given
crimes=[]
#change prev_output to your returned list by the previous function
for i in prev_output:
#if value of dictionary key matches with 1st value of output list of previous function
#append that crime to crime list
if str(i[0]) in crime_code.values():
crimes.append(i)
#return list of crime commited by code
return crimes

crimes_by_code(101, crime_code)

<<<<<<<<<<<<<<<<<<<<<<<<<<<<sample O/P>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>