Question

Problem 1 (Reading Statistics)

Write a function called read_stats(filename) that takes a csv (comma separated values) filename as an argument and returns a 2D list containing the statistics in that file. The returned list should contain lists of stats for each crime reported and should not include the header line from the file.

The file crime_in_vancouver.csv (included in the folder) has the following structure:

• The first row provides headers for each column

• Each subsequent row represents the stats for a single crime reported

• Each stat is separated by a comma (,)

• Each crime is described by the following stats:

1. TYPE: The type of crime activities

2. YEAR: A four-digit field that indicates the year when the reported crime activity occurred

3. MONTH: A numeric field that indicates the month when the reported crime activity occurred

4. DAY: A two-digit field that indicates the day of the month when the reported crime activity occurred

5. HOUR: A two-digit field that indicates the hour time (in 24 hours format) when the reported crime activity occurred 6. MINUTE: A two-digit field that indicates the minute when the reported crime activity occurred

7. BLOCK: Generalized location of the report crime activity

8. NEIGHBOURHOOD: Neighbourhoods within the City of Vancouver are based on the census tract (CT) concept within census metropolitan area (CMA).

9. X: Coordinate values are projected in UTM Zone

10. All data must be considered offset and users should not interpret any locations as related to a specific person or specific property. 10. Y: Coordinate values are projected in UTM Zone 10. All data must be considered offset and users should not interpret any locations as related to a specific person or specific property.

You may assume that the file is properly formatted, i.e., that the first column is the TYPE, the second is the YEAR and so on. See the sample output for an example.

Sample run:

read_stats('crime_in_vancouver.csv') returns [['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'], ….]

In Python

Make sure the program is available. Please upload the complete program picture and program content.

Answer 1

import csv
def read_stats(filename):#method that returns 2D list
with open(filename) as f:#open file
reader=csv.reader(f)
data=list(reader)#read data to a list
return (data[1:])#return list

file=input("Enter file name:")
print(read_stats(file))

Screenshots:

The Screenshots are attached below for reference.

Please follow them for proper indentation.

The sample file with sample data is chosen for execution.